Skip to Content
Information
Space announcement: BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.

Delete control table

The Delete Control Table (member Db2DCT in the control card PDSE) contains information about the tables from which data is to be deleted. It is the input (SYSIN) for the DELETE step.

Db2 Delete Control Table

*FR.21.01.00 F=1------- D B 2  D E L E T E   C O N T R O L   T A B L E ---------
*
*
*  TARGET OBJECT
*  ----------------------------------
TI: ID=003  ROW COUNT=       888   NNN
TC: TSOID01
TT: PART_TABLE
*
*  TARGET OBJECT
*  ----------------------------------
TI: ID=002  ROW COUNT=       357   NNN
TC: TSOID01
TT: ORDER_TABLE
*
*  TARGET OBJECT
*  ----------------------------------
TI: ID=001  ROW COUNT=      1462   NNN
TC: TSOID01
TT: ORDER_LINE_TABLE
*

The Delete Control Table contains the following columns:

Delete Control Table

Field Name

Description

TI

Target Information:

ID

Internal table control number; corresponds to the Hnnn record in the extract file.

ROW COUNT

Identifies the number of rows to be deleted; the number of records extracted from the table when the extract file was generated.

N or Y

Represents the D record supplement indicator (see also Product Record — 0).

N or Y

Represents the extract IMPLICITLY HIDDEN columns indicator (see also Extract IMPLICITLY HIDDEN columns).

N, C or V

Represents the compression indicator (see also Compress).

TC

The target creator ID. Creator ID of the table from which data is to be deleted.

TT

The target table; the table from which data is to be deleted.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Compuware File-AID/RDX 21.01