Set Current SQLID (IFCID 055)

This topic provides a sample and the field description of the Authorization Change type of Set Current SQLID (IFCID 055).

Set Current SQLID (IFCID 055) - Authorization Change

This sample shows the layout for an authorization change type of Set Current SQLID (IFCID 055):

TYPE:               SET CURRENT SQLID                STATUS:            SUCCESS 
PREVIOUS SQLID:     THIS IS AN EXAMPLE OF A VERY LONG PREVIOUS SQLID THAT 
                    EXCEEDS THE LINE                   
NEW SQLID:          THIS IS AN EXAMPLE OF A VERY LONG NEW SQLID THAT EXCEEDS 
                    THE LINE

Field description

The fields are described in the following:

TYPE

The kind of authorization change or establishment: SET CURRENT SQLID.

STATUS

The success or failure of the attempted authorization change. Possible values are:

SUCCESS for a successful authorization change
FAILURE for a failed attempt

Note: The SQL statement is always successful if the user has SYSADM authority.

Derivation : DB2® field QW0055ST

PREVIOUS SQLID

The initial value of the SQLID before execution of the request.

Derivation : DB2 field QW0055OI.

NEW SQLID

If the command completed successfully, the new value of the SQLID is shown. If the command did not complete successfully, the value of the attempted SQLID change is shown.

Derivation : DB2 field QW0055NI.