Use - 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

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