Previous Topic

Next Topic

Book Contents

Book Index

ON DB2: Data Selection Statement

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:

  • DS (Dataset)–Line and column values are based on the start of the dataset.
  • PG (Page)–Line and column values are based on the start of the page. Default.

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.

  • blank – A Datastamp is not generated. Default.
  • 1 – A Datastamp is calculated using the original algorithm to ensure compatibility with prior versions of Control-M/Analyzer.
  • 2 – A Datastamp is calculated using the newer, more efficient algorithm.

Parent Topic

Rule Definition