Re: Friendlier way to create stored procedures in Navigator?

It seems most likely the error is with the IF syntax in the given:

> if workc < 0 then;
> set workc = 0
> end;

Presumably it should be:

> if workc < 0 then
> set workc = 0;
> end if;

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstifstmt.htm

Oddly, I do not see the semicolon listed in the syntax diagram at the above link, but it is in the example.

Without any ELSEIF or ELSE, an example:
IF search-condition THEN SQL-procedure-statement ;
END IF ;

FWiW: Using the Run SQL Scripts feature of V5R4 iNav, the above noted error in IF-condition syntax was both highlighted and positioned to.

Regards, Chuck