Table 8 on page 194 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 Teradata Database |
|
|
Where: |
All clients |
|
|
DBCHCL |
What: |
Manages interaction with the Teradata Database. Each type of interaction is called a function. |
|
Why |
To send Teradata SQL requests to, and receive Teradata SQL from, the Teradata Database |
|
|
Where |
All clients |
|
|
Function |
Use |
|
|
DBFCON |
Logs a session on to the Teradata 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 Teradata 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 Teradata SQL response (spool file) |
|
|
DBFERQ |
Closes a Teradata SQL request and has the Teradata Database discard the response |
|
|
DBFDSC |
Logs off and deletes a session from the Teradata 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 |
|