Response Processing - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities

After each segment is sent, its response should be processed as usual for any CLIv2 request. Depending on the response parcel, one of the following actions occurs:

If this response parcel is returned... Then...
Failure any previous segments have been discarded by the database.
Error any previous segments have been retained by the database, and the failing request may be retried (if possible).

Such retry is not possible if other segments were sent before fetching the response containing the error.

Success (if Record, Indicator, or Extended Indicator mode)

or

OK (if Field mode)

the next segment can be sent.

When all segments have been sent, the stored procedure is compiled, and any compilation messages are returned. If the value of the Success or OK parcel Warning Code field is 5527, then compilation was successful but warning messages were returned; if the value is 5526, then compilation was not successful and error messages are returned. In both cases, the Success or OK parcel Activity Count field indicates the number of messages.

The format of the messages depends upon the CLIv2 Response Mode Option. For Field mode, each message is treated as a separate row consisting of a single VARCHAR column. For Record, Indicator, and Extended Indicator modes, each message is in a separate Data parcel.