15.10 - StatementInformation Parcel - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

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.