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):
SET SIP ON;
To disable the SIP facility (for C/PLI)
SET SIP OFF;
To enable the SIP facility (for COBOL)
SET SIP ON
To disable the SIP facility (for COBOL)
SET SIP OFF
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.