17.10 - Positioning-statement-number - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

Usage Notes

Positioning-statement-number specifies the statement number for the Fetch that is to be performed when Positioning-action indicates other than Next-parcel.

Language Variable Name
C: DBCAREA.H: positioning_stmt_number or dbfiPSNm
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-statement-number depends only upon the setting of Positioning-action, not Change-option.