Re: Creating Stored procedure on DB2/400 (System i5, OS400 etc )

On 7/4/07, Forder, Nick <Nick.Forder@xxxxxxxxxx> wrote:
> Robert,
>
> Bang on the nail!
> "New Session Properties" statement separator to "~" (I do a little
> concatenating of fields) new session and a slight tweak to the syntax
> (DB2/400 has always got to be a little bit more pedantic than the rest!)
> And hey presto a nice new stored proc; tried it on my original proc and
> that works as well.
>

Very good.  I have a fix in CVS, which will be available in this
weekends snapshot if you want to try it out.  It should allow you to
change statement separator temporarily for the current session without
having to restart (just as it worked in versions prior to 2.5)

Rob

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/