Positioning-value - 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
ft:locale
en-US
ft:lastEdition
2024-11-15
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
lifecycle
latest
Product Category
Teradata Tools and Utilities

Usage Notes

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 or OK). 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, Data-information-extended, and No-operation parcels before the Multipart-record parcel for the start of the data.

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

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.