Common Routines Supporting CLIv2 - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
lvt1544831946862.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following common routines are used in most basic applications.

Routine Description
DBCHINI Initializes the DBCAREA, which is shared by an application and most CLIv2 routines. DBCHINI also does the internal initialization of CLIv2.
DBCHCL
  • Connects a session on the database itself.
  • Checks that the logon was successful.
  • Ends the Connect request.
  • Sends Teradata SQL statements (for example, selects rows from a table).
  • Process the response (for example, obtains rows from table).
  • Ends the request.
  • Disconnects the session.
DBCHCLN

Cleans up after an application is finished using the database.

When DBCHCLN is called and the return code is zero, data structures allocated internally during the calls to CLIv2 routines have been deallocated.

For more information about CLIv2 routines, see Common Routines.

For information about routines that provide information about CLIv2, TDP, or the database, see CLIv2 Query Routine.

For information about CLIv2 routines that perform additional services, see Other CLIv2 Routines.