HANA SQLScript dbms_output.put_line() equivalent?

Question

Does HANA SQLScript have an equivalent function to dbms_output.put_line()? Looking for something that can be used to print an output like I do with PL/SQL or Python.

Answer 1

Nope, there is nothing similar to that. As the documentation shows in some of the example codings, you may enter trace text into a logging table.

• Lars

Answer 2

hana has built-in library SQLSCRIPT_PRINT. For details see SAP_HELP

a sample code:

DO BEGIN
  USING SQLSCRIPT_PRINT as LIB;
  BEGIN
    LIB:PRINT_LINE('Hello World!');
  END;
END;