Online Documentation for SQL Manager for DB2

Procedures from Table

SQL Manager for DB2 provides you with an ability to create SELECT/INSERT/UPDATE/DELETE procedures from a table and set their properties using the Create Procedures from Table dialog.

To open the dialog, right-click the table in DB Explorer and select the Tasks | Create SIUD Routines... context menu item, or open the table in Table Editor and use the Create Procedure item of the Navigation bar.

• Options
• SELECT procedure
• INSERT procedure
• UPDATE procedure
• DELETE procedure