DBCHQE - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
zwv1608578409227.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
Product Category
Teradata Tools and Utilities

DBCHQE is called by a CLIv2 application to obtain information about its execution environment.

When used by an application supporting multiple releases of CLIv2, TDP, or the database, some return codes that indicate downlevel versions of these components must be handled by the application, most often as equivalent to the information not being available.
  • 202 - CLIv2 does not support the query item
  • 359 - Database version does not support the requested information
  • 365 - TDP version does not support the requested information
  • 451 - TDP does not support the query item

For queries that return collections of items (Aggregate-support-list, CLIv2-limits, SQL-limits, Procedure-data, Utility-session, Build-information, and Integrated-LOB), these applications should also allow for downlevel versions of CLIv2 by ensuring that items of interest are present by checking the returned length (QEPRALEN).