Positioning-value - 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-value specifies either the row number, the byte offset into a BLOB, or the character offset into a CLOB, from which the Fetch is to be performed when Positioning-action indicates other than Next-parcel.

When specifying a row number, by convention, a value of zero represents parcels that precede the first row (such as Success, OK, or StatementStatus). When specifying a byte or character offset, by convention, a value of zero corresponds to the first byte or character. A value of zero also returns Success or StatementStatus, Data-information-extended, and No-operation parcels before the Multipart-record parcel for the start of the data.

In this language... The variable name for Positioning-value is...
COBOL DBFIPVAL
PL/I DBFIPVAL
C, C++ dbfiPVal
IBM Assembler DBFIPVAL
This routine... Does this for Positioning-value...
DBCHINI writes
DBCHCL reads (FET)
Positioning-value is used by... To...
applications write

Use of this setting does not require use of Change-option. That is, honoring Positioning-value depends only upon the setting of Positioning-action, not Change-option.