15.10 - Segment Data - Call-Level Interface Version 2

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

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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:

  • Keep Response option must also be 'N'
  • Request Mode option must be 'P'
  • Request Processing option must be 'E'
  • 2PC option must be 'N'
  • Initiate Protocol‑function option must be 'N' if the Initiate with Protocol Function function is used.
  • For details on SQL Stored Procedures, refer to Chapter 17: “Stored Procedures.”