DBCHQE - 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

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).