Not sure if this is Squirrel issue or JTOpen issue, but I am seeing this:

 

BEGIN

                IF EXISTS(SELECT 1 FROM QSYS2.SYSPROCS WHERE ROUTINE_SCHEMA = 'S' AND ROUTINE_NAME = 'N') THEN

                                DROP PROCEDURE S.N;

                END IF;

END;

 

Error:

 

Error: [SQL0104] Token <END-OF-STATEMENT> was not valid. Valid tokens: ;.

SQLState:  42601

ErrorCode: -104

 

Same SQL runs in iSeries Navigator fine.

 

Thank you!

Alex