StatementInformation Parcel
The SIP (StatementInformation Parcel) refers to the metadata returned by the database as a result of preparing or executing a request. The metadata includes information about parameters used in the request and columns returned from execution of the request as well as information related to the request as a whole, such as the estimated time to execute the request.
The two possible states for SIP are ON and OFF.
To enable the SIP facility (for C/PLI):
EXEC SQL
SET SIP ON;
To disable the SIP facility (for C/PLI)
EXEC SQL
SET SIP OFF;
To enable the SIP facility (for COBOL)
EXEC SQL
SET SIP ON
END-EXEC.
To disable the SIP facility (for COBOL)
EXEC SQL
SET SIP OFF
END-EXEC.
Note: Use these statements after logging on to Teradata Database. If SIP is ON, the StatementInformation Parcel is returned; if SIP is OFF, the Prepinfo, Datainfo, and variant parcels are returned as usual.