StatementInformation Parcel - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product
Teradata Preprocessor2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
whb1544831946911.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.