“创建新存储过程”-选择此选项使向导根据指定的select语句创建一个新的存储过程(在数据库中)。
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.
在DatabaseExplorer中这个存储过程的Packages文件夹下会看到创建的新包。
You see the new package created under the packages folder for that stored procedure in the Database Explorer.
克隆过程中创建的新存储单元与原始(被克隆的)存储单元大小相同。
The new storage unit created by the cloning process will be the same size as the original (cloned) storage unit.
要重新绑定存储过程的包,我们需要先删除它,然后再重新创建绑定新REOPT级别的存储过程,或者为这个特定的SQL存储过程重新绑定一个包。
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.
目前,IBM工具通过始终删除现有过程并使用新定义重新创建新过程来处理存储过程的更改。
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.
在这里,首先需要启动一个新项目,该项目用于创建可部署在SAMPLE数据库内的新存储过程。
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.
其他对象的存储过程也是一样,例如链接会创建一个新的PDOMBinding作为存储已命名节点的一部分的情况。
The storage process is similar for other objects, such as when the linkage creates a new PDOMBinding as part of storing a named node.
否则,请继续步骤4创建一个调用返回行的存储过程的新查询。
Otherwise, continue with step 4 to create a new query that calls a stored procedure that returns rows.
该向导还可以根据输入到向导中的sql语句在数据库中创建新的存储过程。
The wizard can also create new stored procedures in the database based on SQL statements you enter into the wizard.
创建新的存储过程时,系统会向您询问两个名称。
When creating new stored procedures, you are asked for two names.
创建新的存储过程时,系统会向您询问两个名称。
When creating new stored procedures, you are asked for two names.
应用推荐