SQL Body and Parameter Declaration List Display
When you work with stored procedures in , only one of the following can be displayed on the panel at any given time:
When you work with stored procedures in
CA RC/Update™ for DB2 for z/OS, only one of the following can be displayed on the panel at any given time:
- Parameter Declaration List, in which you manage the number of parameters for your stored procedure, the data type of each parameter, and the name of each parameter
- SQL body, in which you use standard ISPF editor commands to copy, replicate, delete, and move lines to manage an SQL procedure's SQL text
You cannot apply commands to an item that is not displayed. For example, if the Parameter Declaration List is active, you cannot enter a command that is applicable only to the SQL body.
You can issue the SQL or PARMS primary commands, respectively, to toggle the display between the Parameter Declaration List and SQL body.
The current toggled setting can be saved, using the SAVESETTINGS (SS) command, so that it will be retained across multiple sessions and used as the default setting each time you start a new create/alter session for an SQL procedure.
Follow these steps:
- Verify that the SQL body or Parameter Declaration List appears at the bottom of the panel.If there is insufficient room for either section to be displayed, enterHEADERin the command line to turn off the header, at which point the Parameter Declaration List or SQL body will appear by itself.You are ready to make a replacement as needed on the panel.
- EnterSQLorPARMSin the command line to toggle between the display of the SQL body and Parameter Declaration List.Toggling occurs as requested.If the SQL body or Parameter Declaration List is not visible because there is not enough room on the panel, enterHEADERin the command line to toggle the header OFF.