Set statement termination character

db2 -svf myProc.txt -td@

com.ibm.db2.jcc.b.nm: An unexpected token "END-OF-STATEMENT" was found following "END P1".  Expected tokens may include:  "JOIN <joined_table>".. SQLCODE=- 104 , SQLSTATE= 42601 , DRIVER= 3 . 50 . 152 

create procedure tst1()
begin atomic
	declare aa int;
	set aa= 1 ;
end

Changing the SQL statement terminator
By default, the SQL editor uses a semicolon ( ; ) as the default statement terminator. You can specify a different statement terminator for an SQL statement that you create in the SQL editor.
A statement terminator is specific to the SQL statement in which you specify it. You can specify different statement terminators in different SQL statements. The statement terminator can be a string of one or more case-sensitive characters. If you specify a string as the statement terminator, the statement terminator must be preceded by a space in your code.

The statement terminator that you specify for an SQL statement persists every time that you open the statement in the SQL editor.

Prerequisite: The SQL statement for which you want to change the statement terminator must be open in the SQL editor.
To change the statement terminator for an SQL statement:

Right-click in the SQL editor, and then click Set Statement Terminator on the pop-up menu. 
In the Set Statement Terminator window, type one or more characters to use as the statement terminator and then click OK. 
If you specify a statement terminator other than the default, a comment is added to the top of the SQL statement that indicates the statement terminator that you specified. Existing occurrences of the default statement terminator are not updated in the SQL statement; you must change them manually.

-- <ScriptOptions statementTerminator="!" />
drop procedure tst1!
create procedure tst1()
begin atomic
	declare aa int;
	set aa= 1 ;
end!