Positioning-action - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Positioning‑action

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

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.