17.10 - Change 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
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

Usage Notes

The Change Options field specifies whether any options have been changed since the last time they were scanned by CLI.

Language Variable Name
COBOL: DBCAREA-CHANGE-OPTS
C: DBCAREA.H: change_opts
Routine Action Taken
DBCHINI: writes
DBCHCL: reads (CON; RSUP; IRQ; FET; REW; ERQ; ABT)
Used by Action Taken
application program writes

Change Options is initialized by DBCHINI to the default value provided for Change Options in the site’s SPB.

If the value provided is not appropriate for the application, the application program may change the value. Options processing is expensive, so use it only when necessary. It may be necessary immediately after the call to DBCHINI to establish application-specific defaults. After that, it is only necessary if some processing option is changed.

Set Change Options to N after CLI picks up the new option settings. If Change Options is set to Y, DBCHCL uses the option flags that are appropriate for the value specified in function. The following table summarizes the option flags scanned for each function if Change Options is set to Y.

Options Scanned Function
Connect Run Startup* Initiate Request Fetch Rewind End Request Abort Disconnect Continue Request
columnInfo No Yes Yes No No No No No No
Connect Type Yes No No No No No No No No
Connect Wait No No No No No No No No No
Continuation Code No No No No No No No No Yes
Data Encryption Yes Yes Yes No No No No No No
Date Form Yes No No No No No No No No
Dynamic Result Sets Allowed No Yes Yes No No No No No No
Extended Load Usage Yes No No No No No No No No
Keep Response Yes Yes Yes No No No No No No
Language Conformance Yes No No No No No No No No
Locate Mode Yes Yes Yes No No No No No Yes
Maximum Integer Precision No Yes Yes No No No No No No
Maximum Parcel Yes Yes Yes No No No No No Yes
Multi-Statement-Errors No Yes Yes No No No No No No
Parcel Mode Fetch Yes Yes Yes No No No No No Yes
Period-as-Struct No Yes Yes No No No No No No
Positioning-action No No No Yes No No No No No
Positioning-statement-number No No No Yes No No No No No
Positioning-value No No No Yes No No No No No
Request Mode No No Yes No No No No No Yes
Request Processing Option Yes Yes Yes No No No No No No
Response Mode Yes Yes Yes No No No No No No
Return Identity Data No Yes Yes No No No No No No
Return Statement Info No Yes Yes No No No No No No
Return Time Yes Yes Yes Yes Yes Yes Yes No Yes
Return Object No Yes Yes No No No No No No
Save Response Buffer Yes Yes Yes No No No No No Yes
Segment Data No Yes No No No No No No No
Set Character Set Yes Yes Yes No No No No No No
Statement-status Yes No Yes Yes No No No No No
Stored Procedure Return Result No Yes Yes No No No No No No
TASM FastFail Request No Yes Yes No No No No No No
Tell About Crash Yes Yes Yes Yes Yes Yes Yes No Yes
Transaction Semantics Yes No No No No No No No No
Transforms-Off No Yes Yes No No No No No No
Trusted-request No Yes Yes No No No No No No
Two Response Buffer Yes Yes Yes No No No No No No
Use Presence Bits Yes Yes Yes No No No No No No
Utility Workload Yes No No No No No No No No
Variable Length Fetch Yes Yes Yes No No No No No Yes
Variable Length Request Yes Yes Yes No No No No No Yes
Wait Across Delay Yes Yes Yes No Yes Yes Yes No Yes
Wait For Response Yes Yes Yes Yes Yes Yes Yes No Yes
xmlResponseFormat No Yes Yes No No No No No No
Use uppercase Y or N when setting options.