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

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