it could not compile...i already tried putting semicolon after the query..
the error was..
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
create procedure procedure_name()
First, add @ at the end of your procedure.
Second, you should see an input field right at the bottom of the command editor named "Statement termination character".
Means if you set @ as "Statement termination character", the editor once see the @, it will know this is the end of your procedure.