Positioning-action - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
lvt1544831946862.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

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

In this language... The variable name for Positioning-action is...
COBOL DBFIPACT
PL/I DBFIPACT
C, C++ dbfiPAct
IBM Assembler DBFIPACT
This routine... Does this for Positioning-action...
DBCHINI writes.
DBCHCL reads.

FET

Positioning-action is used by... To...
applications write.

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

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

Use mnemonics for the codes. Mnemonics are provided in the language definition file for the DBCAREA.

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 is honored whatever the setting of Change-option.