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