16.20 - Common Routines Supporting CLIv2 - Teradata Tools and Utilities

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

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

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 Teradata Database (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 Teradata 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 Teradata Database, see CLIv2 Query Routine.

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