Define a new stored procedure.
定义一个新的存储过程。
Create a new stored procedure within a Data Development project.
在DataDevelopment项目中创建一个新的存储过程。
Migration of the stored procedure call: the new stored procedure call looks as follows.
存储过程调用的迁移:新的存储过程调用看起来像下面这样。
Here, you need to start a new project, which can be used to create a new stored procedure that can be deployed inside the SAMPLE database.
在这里,首先需要启动一个新项目,该项目用于创建可部署在SAMPLE数据库内的新存储过程。
Error handling: the new stored procedure now returns SQLCA with proper SQLCODE and SQLSTATE that is more inline with the error handling framework when using SQL.
错误处理:新的存储过程现在返回带有适当SQLCODE和SQLSTATE的SQLCA,在使用SQL时与错误处理框架更加内联。
Create new stored procedure - SELECT this option to have the wizard create a new stored procedure (in the database) based on the specified SELECT statement.
“创建新存储过程”-选择此选项使向导根据指定的select语句创建一个新的存储过程(在数据库中)。
Listing 7 shows an example of a stored procedure that determines an employee's new salary and bonus, depending on their performance rating.
清单7展示了一个存储过程的例子,该存储过程根据业绩评分评定雇员新的工资和奖金。
There is a new CONNECT_PROC database configuration parameter that you can set to the name of a stored procedure.
有一个新的CONNECT _ PROC数据库配置参数,可以把它设置为存储过程的名称。
To rebind the package for a stored procedure, drop and recreate it with new REOPT level, or rebind the package for this specific SQL stored procedure.
要重新绑定存储过程的包,我们需要先删除它,然后再重新创建绑定新REOPT级别的存储过程,或者为这个特定的SQL存储过程重新绑定一个包。
Currently, the IBM tooling handles altering of a stored procedure by always dropping the existing procedure and then re-creating the new procedure using the new definition.
目前,IBM工具通过始终删除现有过程并使用新定义重新创建新过程来处理存储过程的更改。
After closing the Preferences window, you can use your template by following the steps in Create a Stored Procedure and selecting your new template, My template.
关闭Preferences窗口之后,按照创建一个存储程序中的步骤并选择您的新模板MyTemplate,您就可以使用自己的模板。
Expand the new project and right click on the Stored Procedure folder.
展开这个新项目并右键单击Stored Procedure文件夹。
To fix the problem, remove line 23 from the above code, recompile the stored procedure, and move the new class file to the sqllib\function folder.
要纠正这个问题,可以从上面的代码中删除第 23行,重新编译存储过程,并且将新的类文件转移到sqllib\function文件夹。
After registration, the following stored procedure can be used to update the existing schema with the new one.
注册之后,可以用以下存储过程将现有模式更新为新模式。
If you make any changes to the stored procedure, you should first uninstall it from DB2 before registering the new version.
如果更改了存储过程,那么在注册新版本之前应该首先从DB 2卸载它。
You see the new package created under the packages folder for that stored procedure in the Database Explorer.
在DatabaseExplorer中这个存储过程的Packages文件夹下会看到创建的新包。
This same technique might be used to execute a DROP TABLE statement or to execute a system stored procedure that created a new user account and added that user to the sysadmin role.
这一技术可能会被用来执行DROPtable语句,或执行创建新用户帐户并将该用户添加到sysadmin角色的系统存储过程。
Lets users create these stored procedure package variations from the Packages folder, using the new package variation wizard.
允许用户使用NewPackageVariation向导在Packages文件夹中创建这些存储过程包变体。
Essentially the new ADMIN_CMD stored procedure ACTS as a wrapper to the CLP (it even includes a parser).in DB2 V8.2.2, the following commands are supported with the ADMIN_CMD routine.
新的ADMIN_CMD存储过程基本上充当了CLP的包装器(它甚至包括分析器)。
This new feature allows you to decide which stored procedure package to use at runtime, by letting you pick the collection id in the run Settings Options Panel.
这个新特性使我们能够在RunSettingsOptionsPanel中选择集合id,从而决定在运行时使用哪个存储过程包。
Create a new script file based on a standard Stored Procedure template.
按照标准的存储过程模板创建新的脚本文件。
So if I need to add a new column, I need to modify the stored procedure, and modify both client and server code!
所以如果我需要添加一个新列,我需要修改存储过程,并修改客户机和服务器代码!
Otherwise, continue with step 4 to create a new query that calls a stored procedure that returns rows.
否则,请继续步骤4创建一个调用返回行的存储过程的新查询。
The subgradient set, optimization and procedure are constructed. In particular, a new deletion rule is suggested to reduce the amount of information to be stored during the computation procedure.
文中给出了最优性条件、次梯度集合的构造方法及算法的迭代程序,提出了新的删除定理,可以减少迭代过程所储存的次梯度的信息量。
I am new with stored procedure.
我是新的存储过程。
I am new with stored procedure.
我是新的存储过程。
应用推荐