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.
Use these statements after logging on to the database. If SIP is ON, the StatementInformation Parcel is returned; if SIP is OFF, the Prepinfo, Datainfo, and variant parcels are returned as usual.