Printing/displaying to screen in Procedure

Database
Enthusiast

Printing/displaying to screen in Procedure

Is there any way to write to the screen in a Procedure, for troubleshooting purposes? I'm looking for the equivalent of DBMS_OUTPUT.PUT_LINE from Oracle. We'd remove it from production code, but it would be immensely useful for debugging a very large complex ETL procedure we have.

Thanks in advance.
1 REPLY
Teradata Employee

Re: Printing/displaying to screen in Procedure

For external Stored Procedures and User-Defined Functions there is special "trace table" functionality available for debugging. For SQL SPs, you can add regular INSERT statements; GLOBAL TEMPORARY tables are often used.