IFCID 324 - Function Resolution

This topic shows detailed information about Record Trace - IFCID 324 - Function Resolution.

Record trace - IFCID 324 - Function Resolution

The field labels shown in the following sample layout of Record Trace - IFCID 324 - Function Resolution are described in the following section.

QUERYNO       :       1853             PLANNAME : PLAN01          APP
         BIND_TIME     :  MM/DD/YY HH:MM:SS.MS  VERSION  : VBR1.000        
         CONSIS_TOKEN  : X'C3D6D5E2E3D6D2F1'    GRP_MBR  : 'BLANK'             
         COLLECTION_ID : COLLID01                                               
         PROGNAME      : PROGRAM001                                              
         CURRENT_PATH  : "SYSIBM","SYSFUN","SYSPROC","ABCDE"

QUERYNO

The query number.

Field Name: QW0324QN

PLANNAME

The plan name.

Field Name: QW0324PN

COLLECTION_ID

The collection ID.

Field Name: QW0324CI

APPLNAME

The name of the application.

Field Name: QW0324AL

PROGNAME

The program name.

Field Name: QW0324PG

CONSIS_TOKEN

The consistency token.

Field Name: QW0324CT

GRP_MBR

The group member name.

Field Name: QW0324GM

BIND_TIME

The time stamp of the bind time.

Field Name: QW0324TS

VERSION

The version.

Field Name: QW0324VN

CURRENT_PATH

The current path.

Field Name: QW0324CP

FUNCT_SCHEMA

A short SQL identifier, either ordinary or delimited, following the concept of qualified names consistent with the ANSI/ISO SQL92 standard.

Field Name: QW0324FS

FUNCT_NAME

The name of a function without a qualifier.

Field Name: QW0324FN

SPECIFIC_NAME

Identifies the particular function. The specific name must identify a specific function name in the explicitly or implicitly specified schema.

Field Name: QW0324FI

FUNCT_TYPE

The classification of the function:

SU: Scalar UDF
TU: Table UDF

Field Name: QW0324FY

VIEW_CREATOR

The name of the view creator if the function is referenced in a view definition.

Field Name: QW0324CV

VIEW_NAME

The name of the view if the function is referenced in a view definition.

Field Name: QW0324NV

QUERY_BLOCKNO

A number that identifies the query block number being explained.

Field Name: QW0324QB

FUNCT_TEXT

Contains the text of the function reference, function name, and parameters. It can be up to 254 characters long.

Field Name: QW0324FT