05-30-2002, 12:37 AM
We have just implemented Version 5.1 which has upset an external application that makes use of a stored procedure on the AS/400. IBM have updated SQL so that it now returns a message SQL0466 saying that a Result Set is available. This apparently is the proper way SQL should work! Unfortunately the JDBC driver (Hit Soft) that calls this stored procedure on the AS/400 doesnít know what it means and is erroring. IBM has released a work around but only for a different message Ė SQL0030 ! Does anyone have any ideas for surpressing the SQL0466 message? Iíve tried a RCVMSG RMV(*YES) but canít seem to intercept it.