Positioning-action - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities

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.