Common Routines Supporting CLIv2 - Teradata Tools and Utilities

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Tools and Utilities
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
oxw1641281447623.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
vfj1470443597526
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.