16.20 - GET DIAGNOSTICS - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

Keywords introducing the GET DIAGNOSTICS SQL procedure diagnostic statement.See Teradata Vantage™ SQL Stored Procedures and Embedded SQL , B035-1148 for details.

parameter_name
Parameter whose value is set to the value contained in statement_information_item.
The maximum length of a database object name is either 30 LATIN characters or 128 Unicode characters. For details about object name length limits, see Teradata Vantage™ SQL Fundamentals, B035-1141.
variable_name
Variable whose value is set to the value contained in statement_information_item.
statement_information_item
One of the field names from the Statement Area of the Diagnostics Area. See Teradata Vantage™ SQL Stored Procedures and Embedded SQL , B035-1148 for details.
EXCEPTION
A language element that indicates to return information from the Condition Area of the Diagnostics Area.
condition_number
Number, parameter, or variable that resolves to the number of the Condition Area from which information is to be retrieved.
parameter_name
variable_name
An output parameter or variable to which the condition_information_item retrieved from the specified Condition Area is assigned.
The maximum length of a database object name is either 30 LATIN characters or 128 Unicode characters. For details about object name length limits, see Teradata Vantage™ SQL Fundamentals, B035-1141.
condition_information_item
Name of the Condition Area field from which condition information is to be retrieved. See Teradata Vantage™ SQL Stored Procedures and Embedded SQL , B035-1148 for a list of the valid condition information item names.
See Teradata Vantage™ SQL Fundamentals, B035-1141 for the rules for naming database objects.