Changing the Value for Segment-data - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
lvt1544831946862.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities
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'
  • Two-phase commit 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 Stored Procedures.