Shell Programming and Scripting

db2 -tvf query.sql

SET SERVEROUTPUT ON;
BEGIN
 call dbms_output.put_line( 'Hello' );
END;

BEGIN
call  dbms_output.put_line( 'Hello' )
DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned: SQL0104N  An unexpected token "END-OF-STATEMENT" was found following ".PUT_LINE( 'Hello' )".  Expected tokens may include:  "<psm_semicolon>". LINE NUMBER=2.  SQLSTATE=42601

END
DB21034E  The command was processed as an SQL statement because it was not a valid Command Line Processor command.  During SQL processing it returned: SQL0104N  An unexpected token "END-OF-STATEMENT" was found following "END". Expected tokens may include:  "JOIN <joined_table>".  SQLSTATE=42601

SET SERVEROUTPUT ON /
BEGIN
call dbms_output.put_line('Hello');
END /

$ db2 -td/ -vf  query.sql
SET SERVEROUTPUT ON
DB20000I  The SET SERVEROUTPUT command completed successfully.

BEGIN
call dbms_output.put_line('Hello');
END
DB20000I  The SQL command completed successfully.

Hello