Segment Data is a one byte field that specifies the processing to be performed when statements of an SQL Stored Procedure are being segmented into multiple requests. The value indicates whether the request is for the first, intermediate, or last segment, or if processing is cancelled.
|
In this language... |
The variable name for Segment Data is... |
|
COBOL |
DBRISEG |
|
PL/I |
DBRISEG |
|
C |
dbriSeg |
|
IBM Assembler |
DBRISEG |
|
This routine... |
Does this for Segment Data. . . |
|
DBCHINI |
writes |
|
DBCHCL |
Reads (IRQ; IWPF) |
|
Segment Data is used by... |
To... |
|
applications |
write |
DBCHINI initializes the value 'N'. When segmenting data is appropriate for the application, you should perform the following procedure before calling DBCHCL for the Initiate Request or Initiate With Protocol Function functions (although with the latter the Initiate Protocol function must be 'N').
1 Set Change Options to 'Y'.
2 Change the value for Segment Data as follows:
|
If the desired segmenting is. . . |
Then change the value for Segment Data to... |
|
no segmenting |
N |
|
first segment |
F |
|
intermediate segment |
I |
|
last (or only) segment |
L |
|
cancel segmenting |
C |
Use mnemonics for the codes. Mnemonics are provided in the language definition for the DBCAREA.
If Segment Data is other than 'N', then the following options must be used:
For details on SQL Stored Procedures, refer to Chapter 17: “Stored Procedures.”