17.10 - Use - Call-Level Interface Version 2

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

Call-Level Interface Version 2
Release Number
October 2021
Last Update
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

The following table lists the common routines and describes how they are used.

Routine Description
DBCHINI What: Initializes the application program allocated by DBCAREA and allocates and initializes internal CLI memory areas.
Why: To prepare for interaction with the database
Where: All clients
DBCHCL What: Manages interaction with the database. Each type of interaction is called a function.
Why: To send Teradata SQL requests to, and receive Teradata SQL from, the database.
Where: All clients
Function Use
DBFCON Logs a session on to the database and specifies a set of services.
DBFCRQ Sends LOB data in deferred mode.
DBFRSUP Submits a request to execute the Startup Request stored in the database.
DBFIRQ Submits a Teradata SQL request from the application
DBFABT Aborts a request asynchronously
DBFFET Makes available the next parcel or buffer (which one depends on the setting of Parcel Mode) of the Teradata SQL response
DBFREW Repositions to start of the Teradata SQL response (spool file)
DBFERQ Closes a Teradata SQL request and has the database discard the response.
DBFDSC Logs off and deletes a session from the database.
DBCHCLN What: Releases the internal CLI memory areas that were allocated by DBCHINI.
Why: To clean up after interacting with the database computer.
Where: All clients