IFCID 059 - Fetch Start

This topic shows detailed information about Record Trace - IFCID 059 - Fetch Start.

START         LOCATION NAME    : PMO5D851
PKG COLLECTION ID: HSRTEP2VL1XXXXXXXXX2XXXXXXXXX3XXXX
XXXXX4XXXXXXXXX5XXXXXXXXX6XXXXXXXX
X7XXXXXXXXX8XXXXXXXXX9XXXXXXXXX0XX
XXXXXXX1XXXXXXXXX2XXXXXXXZ
PROGRAM NAME     : DSN@EP2L
CURSOR NAME      : C1
CONSISTENCY TOKEN: X'172A1C98193C380E'
STATEMENT NUMBER :       1627
STATEMENT TYPE   : X'01'
QUERY COMMAND ID : ----
QUERY INSTANCE ID: ----
FETCH SENSITIVITY: UNSPECIFIED
FETCH ORIENTATION: NEXT

LOCATION NAME

The location name.

Field Name: QW0059LN

PKG COLLECTION ID

The package collection identifier.

Field Name: QW0059PC

PROGRAM NAME

The program name.

Field Name: QW0059PN

CURSOR NAME

The name of the cursor used by the FETCH statement.

Field Name: QW0059CN

CONSISTENCY TOKEN

The consistency token.

Field Name: QW0059TS

STATEMENT NUMBER

The statement number.

Field Name: QW0059SN

STATEMENT TYPE

The statement type. X'01' indicates FETCH.

Field Name: QW0059ST

QUERY COMMAND ID

The ID of the query command.

Field Name: QW0059CID

QUERY INSTANCE ID

The ID of the query instance.

Field Name: QW0059QID

FETCH SENSITIVITY

Identifies the fetch sensitivity. It can be one of the following:

• Sensitive
• Insensitive
• Unspecified

Field Name: QW0059FS

FETCH ORIENTATION

Identifies the fetch orientation. It can be one of the following:

• First
• Last
• Before
• After
• Next
• Previous
• Current
• Absolute
• Relative
• Unspecified

Field Name: QW0059FO