SQLSCRIPT_PRINT

[chinabba_lc]

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 

[pfefferf · Accepted solution]

As the documentation says (check it here), the print library is only supported by HDBSQL. So it is not supported e.g. in the console of HANA Studio.

[chinabba_lc · Accepted solution]

Thank you. Can we connect to HDBSQL without ADMIN pwd? For example using HANA Developer User?

Kindly suggest.

[pfefferf · Accepted solution]

Sure, you can use any DB user. Check the CLI reference for the -u and -p options.