What is the best way (if there is one) to change bind options for a SQL procedure package ? I have taken a look at SYSPROC.REBIND_ROUTINE_PACKAGE, but it does not accept input like 'QUERYOPT 2' in db2 version 9.5.

Thanks

I think you need to do a bind with replace and specify the new/updated options

You would have to drop the SQL procedure and recreate it after setting the routine preopts appropriately.

Andy