16.20 - Positioning-action - Teradata Tools and Utilities

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

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

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.