Positioning-action
Usage Notes
Positioning-action specifies the position in the response from which the Fetch is to be performed.
|
Language |
Variable Name |
|
C: DBCAREA.H: |
positioning_action or dbfiPAct |
|
Routine |
Action Taken |
|
DBCHINI: |
writes |
|
DBCHCL: |
reads (FET) |
|
Used by |
Action Taken |
|
application program |
writes |
One of the following values may be set before calling the Fetch function:
|
Set Value |
To... |
|
0 |
fetch the next parcel. This is the default. |
|
1 |
fetch the first parcel in the row number, specified by Positioning‑value for the statement and Positioning‑statement-number. |
|
2 |
fetch bytes in the Binary Large Object (BLOB), beginning at the byte offset. Specified by Positioning-value for the statement and Positioning-statement-number. This may be done only if a single BLOB was selected using a locator. |
|
3 |
fetch characters in the Character Large Object (CLOB), beginning at the character offset. Specified by Positioning-value for the statement and Positioning-statement-number. This may be done only if a single CLOB was selected using a locator. |
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 overrides Change-option setting.