After you add a DB2® SQL or IDS SPL procedure file to your IBM® database project, you can view and change the properties by using the Property Pages window. Most of the properties are read-only. You can configure and use specific properties during the build process.
The properties are divided between
a Behavior category and a z/OS Options category.
DB2 procedure properties
are configuration specific. You can specify
a different set of options for each solution
configuration.
Changing the properties of overloaded procedures that are based on
data type produces undefined results.
To change the properties of an SQL or SPL procedure:
- In the Solution Explorer, right-click the procedure
node, and then select Properties on the shortcut menu.
The Property Pages window displays the properties of the procedure.
- Change any of the properties, as appropriate.
- Rebuild the procedure to implement the changes that you made to the properties on the server.
After you rebuild the procedure, you can run the procedure to verify your changes and the result set.
See Also
Developing IBM Database SQL and SPL Procedures | DB2 SQL Procedures | IDS SPL Procedures | Creating SQL and SPL Procedures | Building Procedures, Functions, and Objects
.NET Development Forum DB2 FAQs IDS FAQs
© Copyright IBM Corporation 2002, 2019. All Rights Reserved.