17.10 - Positioning-action - 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

Positioning-action specifies the position in the response from which the Fetch is to be performed.

Language Variable Name
C: DBCAREA.H: positioning_action or dbfiPAct
Routine Action Taken
DBCHINI: writes
DBCHCL: reads (FET)
Used by Action Taken
application program writes

One of the following values may be set before calling the Fetch function:

Set Value To...
0 fetch the next parcel. This is the default.
1 fetch the first parcel in the row number, specified by Positioning-value for the statement and Positioning-statement-number.
2 fetch bytes in the Binary Large Object (BLOB), beginning at the byte offset. Specified by Positioning-value for the statement and Positioning-statement-number. This may be done only if a single BLOB was selected using a locator.
3 fetch characters in the Character Large Object (CLOB), beginning at the character offset. Specified by Positioning-value for the statement and Positioning-statement-number. This may be done only if a single CLOB was selected using a locator.

Use of this option requires that Keep-response=P be specified when initiating the request.

Use of this setting does not require use of Change-option. That is, Positioning-action overrides Change-option setting.