Uses of CLIv2 Parameters: Tabular Summary - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-12
dita:mapPath
dsu1527114222346.ditamap
dita:ditavalPath
dsu1527114222346.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table lists the use of three most common CLIv2 routines and describes how they are used.

Routine Description
DBCHINI What Initializes the application allocated DBCAREA.
Why Prepares for interaction with CLIv2.
DBCHCL What Manages interaction with Teradata Database; each type of interaction is called a function.
Why Sends/receives Teradata SQL requests/responses to/from Teradata Database. The following table lists the functions associated with the DBCHCL routine.
Function Name What it Represents Use
CON Connect Logs a session on to Teradata Database and specifies a set of services
RSUP RunStartUp Submits a request to execute the startup request stored on Teradata Database
IRQ Initiate Request Submits a Teradata SQL request from the application
IWPF Initiate With Protocol-function Submits a Teradata SQL request from the application and allows Teradata Database Two-phase commit protocol sync point performance optimization
CRQ Continue Request Provides data requested by Teradata Database to complete an SQL request
CMD Command Issues a TDP command within a CLIv2 program
ABT Abort Aborts a request asynchronously
FET Fetch Makes available the next parcel or buffer (which one depends on the setting of Parcel Mode) of the Teradata SQL response
REW Rewind Repositions to start of Teradata SQL response (spool file)
ERQ End Request Closes a Teradata SQL request and has Teradata Database discard the response
DSC Disconnect Logs off and deletes a session
DBCHCLN What Logs off all sessions and releases the internal CLIv2 memory areas allocated by DBCHINI
Why To clean up after interacting with Teradata Database