Download CBL Interactive (CBLi)

DB2 Dynamic SQL
The DB2 Dynamic SQL window may be opened via the following:
• Select 'DB2 Dynamic SQL' from the File menu in the CBLi Main Menu.
• Enter the CBLi command SQL on the command line of any window.
DB2 Dynamic SQL window may be used to submit SQL commands to a DB2 database and display the resultant messages and
table views.
The DB2 Dynamic SQL capability is available only to MVS sites where SELCOPY is installed.
The SELCOPY DB2 interface, SELCOPQL load module is used to pass SQL statements to the DB2 data base and so must also
be available in the SELCOPY load library.
On startup, the Dynamic SQL window connects the user to the DB2 subsystem using the DB2 subsystem name and plan specified
in the CBLNAME load module.
The Dynamic SQL window has the same characteristics as a CBLi List window including selecting, sorting and filtering of row and
column data and "point and shoot" sorting on column headers.
Figure 26. DB2 Dynamic SQL window.
DB2 Subsystem>
Specify the DB2 sub-system name to be the target of the CONNECT.
Changing the Subsystem name will cause CBLi to disconnect the user from the current subsystem and reconnect to the
new subsystem.
Default is that defined by the CBLiINI option, DB2.SSN, otherwise the sub-system name specified in the DB2SubSys field
of the CBLNAME load module is used.
Plan>
Specify the SELCOPY (SELCOPQL) DB2 plan name which has been bound to the DB2 sub-system.
This is the name assigned to the SELCOPY plan during the BIND to the DB2 subsystem.
Default is that defined by the CBLiINI option, DB2.Plan, otherwise the plan name specified in the DB2Plan field of the
CBLNAME load module is used.
Select Limit>
Limit the number of rows to be displayed in the Dynamic SQL window following a SELECT transaction. Once the limit
threshold has been reached, a pop-up message window is displayed and no further attempt is made to retrieve selected
2009/07/20 16:03:29
CBL Interactive (CBLi)
37