DBCHQE - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-12
dita:mapPath
dsu1527114222346.ditamap
dita:ditavalPath
dsu1527114222346.ditaval
dita:id
B035-2417
lifecycle
previous
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 Teradata 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 - Teradata 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).