Options - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Options

Specifies which statement options are used when a request is sent to Teradata Database.

Usage Notes

The Options parcel is generated by CLIv2 at the direction of an application.

Parcel Data

The following information applies to the Options parcel.

 

Flavor

Parcel Body Length

Parcel Body Fields

85

10 to 18

RequestMode: 1 byte

Function: 1 byte

Select-data: 1 byte

Continued-characters-state: 1 byte

APH-response: 1 byte

Return-statement-info: 1 byte

UDTTransformsOff: 1byte

Maximum DECIMAL precision: 1 byte
(ignored if Field Response-mode)

IdentityColumnRetrieval: 1 byte

DynamicResultSets: 1 byte

If present, SP-ReturnResult: 1 byte

 

 

If present, PeriodStructOn: 1 byte

 

 

If present, ColumnInfo: 1 byte

 

 

If present, TrustedSesions: 1 byte

 

 

If present, MultiStatementErrors: 1 byte

 

 

If present, ArrayTransformsOff: 1 byte

 

 

If present, XMLResponseFormat: 1 byte

 

 

If present, TASMFastFailReq: 1 byte

Field Notes

The following information applies to Options fields.

  • RequestMode indicates which mode is used to process a response. The settings are as follows:
  • F – specifies Field Mode
  • R – specifies Record Mode
  • I – specifies Indicator Mode
  • M – MultipartIndicator Mode
  • If this field contains a binary zero, the Teradata Database uses the mode specified elsewhere (in the Req, IndicReq, or FMReq parcel) in the request.

    When two or more parcels in a request specify conflicting modes, Teradata Database uses the mode specified in the Options parcel.

  • Function corresponds to the Request Processing Option field of the DBCAREA, and indicates whether the intent is to prepare and execute, to prepare, or to execute the request.
  • The settings are as follows:

  • E – specifies that the request should be executed.
  • A binary zero in this field is interpreted as an E.
  • P – specifies that a PrepInfo parcel is built for each statement in the request. The statements may not contain parameterized SQL.
  • S – specifies that a PrepInfo parcel is built for each statement in the request. The statements may contain parameterized SQL.
  • B – specifies that a PrepInfo parcel is built for each statement in the request and that the request should be executed. The statements may contain parameterized SQL. This setting is supported for both Indicator mode and Record mode. For SQL statements that return no data, such as Insert, Update, Delete and DDL statements, an “empty” PrepInfo parcel is returned. Empty means that the column count in the PreInfo parcel is set to zero.
  • Select-data specifies the way data associated with a Large Object is returned, chosen as one of the following ASCII characters:
  • I – if the actual data is to be returned in the initial response.
  • L – if a locator token associated with the data within the transaction is to be returned.
  • S – if a locator token associated with the data within the spool file is to be returned.
  • If the field contains a binary zero, a value of 'I' is assumed.

  • Continued-characters-state indicates whether character data crossing response parcels is well-formed within each parcel or only when all relevant parcels are considered. This option has effect only for MultipartIndicator response mode because only in that mode may data cross parcel boundaries. If not applicable, the option is ignored.
  • The supported values are:

  • L – the default, specifies that character data crossing response parcels may be in the locked shift state
  • U – specifies that character data crossing response parcels must be in the unlocked shift state
  • APH-response indicates whether response parcels may use the alternate parcel header. The supported values are:
  • Y – specifies that alternate parcel headers may be used in response parcels
  • Binary zero – the default, if alternate parcel headers may not be used in response parcels
  • Return-statement-info indicates whether response parcels may use the alternate parcel header. The supported values are:
  • 'Y' – specifies that StatementInformation response parcels will be returned instead of DataInfo[X] and PrepInfo[X] response parcels. This setting will be rejected if the ResponseMode option specifies 'F' (Field mode).
  • 'N', – the default, if StatementInformation response parcels may not be used.
  • TrustedSesions allowed indicates the trusted-request options.
  • 'N' –the default. it indicates that this is not a trusted request. If the trusted user possesses the trust-only attribute, this setting will prevent “SET QUERY_BAND PROXYUSER...” from being affected.
  • 'Y' – it indicates that this is a trusted request. If the trusted user possesses the trust-only attribute, this setting will allow “SET QUERY_BAND PROXYUSER...” to be affected.
  • Maximum DECIMAL precision indicates the precision of decimal data types in responses. The supported values are:
  • a positive value up to a maximum obtained using the DBCHQE SQL-limits query.
  • binary zero, the default, if the client default, 15, is to be used.
  • IdentityColumnRetrieval indicates whether data is returned in response to an SQL Insert operation when Identity columns are involved. The supported values are:
  • binary zero, the default, that no fields are returned.
  • 'C' – specifies that the values for any Identity columns are returned.
  • 'R' – specifies that the values for all fields in an inserted row that contains Identity columns are returned.
  • DynamicResultSets indicates whether stored procedures may include the results of its SQL requests in the response to the response to the SQL CALL statement invoking the procedure. The supported values are:
  • 'N', – the default, if such results may not be included.
  • 'Y' – if such results may be included.
  • SP-ReturnResult indicates where the results of the associated request are to be returned. The supported values are:
  • 0, the default, if the results are returned to the stored procedure itself.
  • 1, if the results are to be returned to the client.
  • 2, if the results are to be returned to the CALLer of the stored procedure.
  • 3, if the results are to be returned to both the stored procedure and the client.
  • 4, if the results are to be returned to both the stored procedure and its CALLer.
  • PeriodStructOn indicates Period data types are treated as Structured UDTs:
  • 'N' – Period data types are treated as simple data types.
  • 'Y' – Period data types are treated as Structured UDTs in honoring the Transforms-off option. Setting PeriodStructOn to 'Y' requires setting the UDTTransformsOff to 'Y' at the same time. If not, the database will return an error since the support of Period as Struct is an extension of the support of Structured UDTs.
  • UDTTransformsOff indicates whether Structured UDTs are transformed into their external type:
  • 'N' – the flag is off and Structured UDTs are transformed into their external type.
  • 'Y' – the flag is on and Structured UDTs are to be returned from the server in the un-translated mode.
  • ColumnInfo allowed indicates whether the response parcels to this request contain large column or extended object name size.
  • 0 – the default, indicates that client can not accept extended object name in response parcels.
  • 1 – it indicates that client can accept extended object name in response parcels.
  • RFU1 through RFU2 are reserved for future use and must be set to binary zero. An error occurs if these fields are not set to binary zero.
  • MultiStatementErrors indicates whether statement independence results are returned.
  • 'N' – the default value, indicates that a problem with any statement in a multi-statement request results in a single Failure parcel indicating which statement had the problem. A problem with any statement in a multi-statement request ends the processing of that request. None of the statements are executed.
  • 'Y' – indicates that processing is the same unless all errors are of certain limited types, in which case the response to statements having those problems is a StatementError (192) parcel. The responses to all other statements are Success, OK, or ResultSummary parcels. Certain problems with a statement in a multi-statement request allows other statements to be processed.
  • xmlResponseFormat indicates whether XML Data Types are supported. Besides the default value of 0, 'C' is the only other option currently supported. Both result in values being encoded in the character string (text) format. Other options, such as 'B', will be supported in future releases.
  • 0 – the default, indicates that XML values to be returned by the DBS be encoded in character string (text) format.
  • 'C' – indicates that XML values to be returned by the DBS be encoded in character string (text) format.
  • tasmFastFailReq indicates whether the TASM FastFail feature is supported.
  • 'N' – the default, indicates that the TASM FastFail request not be processed.
  • 'Y' – indicates that the TASM FastFail request be processed.