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 |