Processes data from DB2 tables using the dynamic SQL facility.
Figure 256 ON DB2 Statement Format
Type DB2 (or its abbreviation DB) to the right of ON in the Rule Definition screen. When Enter is pressed, the following fields are displayed:
Table 258 ON DB2 Statement Fields
Field |
Description |
---|---|
SUBSYSTEM ID |
DB2 subsystem name, for which a connection will be made. A maximum of four characters can be specified. Should begin with a letter or one of the following characters: #, @, or $. Mandatory. For details, refer to the IBM DATABASE 2 Administration Guide or the database administrator (DBA) at the site. |
SQL SELECTa |
Valid SQL SELECT statement. Mandatory. |
C (Continue?) |
The C (Continue?) field, when set to Y (Yes), provides additional space for specifying the SQL select statement. A maximum of 10 lines can be opened. Specifying N (No) in the C (Continue?) field closes the following preexisting line. |
MODE |
Determines the starting point upon which absolute WHEN line and column specifications are based. (See WHEN: Rule Definition Structure.) Optional. Available modes are:
|
LINECT |
Specifies the number of lines per printed page. Optional. If not specified, the default is 60. |
DATASTAMP |
Determines whether a unique Datastamp is calculated and assigned to the data sources. For more information see Datastamp Calculation.
|
Parent Topic |