GET DIAGNOSTICS EXCEPTION

Translation reference to convert Teradata GET DIAGNOSTICS EXCEPTION statement to Snowflake Scripting

Description

GET DIAGNOSTICS retrieves information about successful, exception, or completion conditions from the Diagnostics Area.

For more information regarding Teradata GET DIAGNOSTICS, check here.

GET DIAGNOSTICS
{
  [ EXCEPTION < condition_number >
    [ < parameter_name | variable_name > = < information_item > ]...
  ] 
  |
  [ < parameter_name | variable_name > = < information_item > ]...
}

Sample Source Patterns

Teradata

Query

CREATE PROCEDURE getDiagnosticsSample ()
BEGIN
    DECLARE V_MESSAGE, V_CODE VARCHAR(200);
    DECLARE V_Result INTEGER;
    SELECT c1 INTO V_Result FROM tab1;
    GET DIAGNOSTICS EXCEPTION 1 V_MESSAGE = MESSAGE_TEXT;
END;

Snowflake

Javascript

CREATE OR REPLACE PROCEDURE PUBLIC.getDiagnosticsSample ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
	// REGION SnowConvert Helpers Code
	
	var V_MESSAGE;
	var V_CODE;
	var V_RESULT;
	EXEC(`SELECT
	   c1
	FROM
	   PUBLIC.tab1`,[]);
	[V_RESULT] = INTO();
	V_MESSAGE = MESSAGE_TEXT;
 
$$

Know Issues

1. Unsupported condition attributes statements

   1. CLASS_ORIGIN

   2. CONDITION_IDENTIFIER

   3. CONDITION_NUMBER

   4. MESSAGE_LENGTH

   5. RETURNED_SQLSTATE

   6. SUBCLASS_ORIGIN

Related EWIS

1. MSCEWI1029: NO TRANSFORMATION RULE FOUND FOR THIS NODE