IFCID 273 - Allocate Cursor

This topic shows detailed information about Record Trace - IFCID 273 - Allocate Cursor.

Record trace - IFCID 273 - Allocate Cursor

The field labels shown in the following sample layout of Record Trace - IFCID 273 - Allocate Cursor are described in the following section.


LOCATION NAME     : LOCATION01XXXXXXXXX2XXXXXXXXX3XXXXXXXXX4XXXXXXXXX5XXXXXXXXX6XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9XXXXXXXXX0X
XXXXXXXX1XXXXXXXXX2XXXXXXXZ
PKG COLLECTION ID : PACKAGE001XXXXXXXXX2XXXXXXXXX3XXXXXXXXX4XXXXXXXXX5XXXXXXXXX6XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9XXXXXXXXX0X
XXXXXXXX1XXXXXXXXX2XXXXXXXZ
PROGRAM NAME      : PROGRAM001XXXXXXXXX2XXXXXXXXX3XXXXXXXXX4XXXXXXXXX5XXXXXXXXX6XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9XXXXXXXXX0X
XXXXXXXX1XXXXXXXXX2XXXXXXXZ
STO PROC LOCATION : LOCATION OF STORED PROCEDURE 01XXXXXXXX4XXXXXXXXX5XXXXXXXXX6XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9XXXXXXXXX0X
XXXXXXXX1XXXXXXXXX2XXXXXXXZ
STO PROC QUALIFIER: QUALIFIER OF STORED PROCEDURE 01XXXXXXX4XXXXXXXXX5XXXXXXXXX6XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9XXXXXXXXX0X
XXXXXXXX1XXXXXXXXX2XXXXXXXZ
STO PROC NAME     : STORED PROCEDURE NAME 01XXXXX3XXXXXXXXX4XXXXXXXXX5XXXXXXXXX6XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9XXXXXXXXX0X
XXXXXXXX1XXXXXXXXX2XXXXXXXZ
ALLOCATED CURSOR  : ALLOCATE CURSOR NAME01XXXXXXX3XXXXXXXXX4XXXXXXXXX5XXXXXXXXX6XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9XXXXXXXXX0X
XXXXXXXX1XXXXXXXXX2XXXXXXXZ
REAL CURSOR NAME  : REAL CURSOR NAME 001XXXXXXXXX3XXXXXXXXX4XXXXXXXXX5XXXXXXXXX6XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9XXXXXXXXX0X
XXXXXXXX1XXXXXXXXX2XXXXXXXZ
STATEMENT NUMBER  :       4711  LOCATOR VALUE     :        815  CONSISTENCY TOKEN : X'F2F0F0F4C6C5C2F1'
QUERY COMMAND ID  : QRYCMDID    QUERY INSTANCE ID : QRYINSID

LOCATION NAME

The location name where the store procedure executes.

Field Name: QW0273LN

PKG COLLECTION ID

The Package collection identificator. This is BLANK when the statement executes without a package.

Field Name: QW0273PC

PROGRAM NAME

The program name.

Field Name: QW0273PG

STO PROC LOCATION

The location of the stored procedure.

Field Name: QW0273LP

STO PROC QUALIFIER

The qualifier of the stored procedure.

Field Name: QW0273QN

STO PROC NAME

The name of the stored procedure.

Field Name: QW0273PN

ALLOCATED CURSOR

The name of the ALLOCATE CURSOR statement.

Field Name: QW0273CN

REAL CURSOR NAME

The name of cursor in the stored procedure.

Field Name: QW0273RN

STATEMENT NUMBER

The statement number of ALLOCATE CURSOR statement.

From QW0273SN or QW0273TS.

Field Name: RT0325SN

LOCATOR VALUE

The value of the locator associated with the result set for which this cursor is defined.

Field Name: QW0273LV

CONSISTENCY TOKEN

The consistency token.

Field Name: QW0273TS

QUERY COMMAND ID

The ID of the query command.

Field Name: QW0273CID

QUERY INSTANCE ID

The ID of the query instance.

Field Name: QW0273QID