Skip to Content
0
Dec 18, 2018 at 08:51 AM

SQLSCRIPT_PRINT

216 Views

Hi All,

I am trying to display messages in the sql console by using SQLSCRIPT_PRINT in HANA version 2.00.031.00.. Program is executing sucessfully but no messages are displayed in the output.

I remember in Oracle we have to use SET SERVEROUTPUT ON;

Is there a similar function available here?

Thanks in advance!

DO
BEGIN
  USING SQLSCRIPT_PRINT As PRTLIB; 


           PRTLIB:PRINT_LINE ( 'Example Print Line' );  
  
END
;


Statement 'DO BEGIN USING SQLSCRIPT_PRINT As PRTLIB; PRTLIB:PRINT_LINE ( 'Example Print Line' ); END ;' 
successfully executed in 49 ms 809 µs  (server processing time: 1 ms 10 µs) - Rows Affected: 0