15.10 - GET DIAGNOSTICS - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Keywords introducing the GET DIAGNOSTICS SQL procedure diagnostic statement.See 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 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 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 SQL Fundamentals, B035-1141.
condition_information_item
Name of the Condition Area field from which condition information is to be retrieved. See SQL Stored Procedures and Embedded SQL, B035-1148 for a list of the valid condition information item names.
See SQL Fundamentals, B035-1141 for the rules for naming database objects.