Change Options

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

Product

Call-Level Interface Version 2

Release Number

15.00

Language

English (United States)

Last Update

2018-09-25

dita:id

B035-2418

lifecycle

Product Category

Teradata Tools and Utilities

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. Table 7 summarizes the option flags scanned for each function if Change Options is set to Y.

Table 7: Processing Options for Network‑Attached Systems
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

Note: Use uppercase Y or N when setting options.