Abort, Cancel, and Restart Processing - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
zwv1608578409227.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
Product Category
Teradata Tools and Utilities

Any time a segment request is active, the CLIv2 Abort function may be used to abort processing. Any time a segment request is not active and before sending the last segment, processing may be canceled by setting the appropriate Segment-data option and initiating another request (the Request-pointer and Request-length are ignored). The response from such a cancellation will be a Failure parcel.

After the first segment has been successful, segmenting is active even after CLIv2 return codes or Error parcels, so segmenting must either be completed normally, canceled, receive a Failure parcel, or the session logged off. If the database restarts, any segments that were received are discarded and the next segment sent will receive a Failure response.

Advanced Applications

Advanced applications can build the request buffers to send a procedure to the database. If it becomes necessary to cancel the sending of a procedure, then a Cancel parcel (flavor 7) may be included after a Multi-TSR parcel that sets the flag indicating that this is the last segment.

Using the Procedure

To invoke a previously compiled and saved procedure, an SQL CALL statement is sent to the database.