467,198 Members | 1,269 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,198 developers. It's quick & easy.

DB2 on AIX throw exception with SQL that has (

Hi All,

Anyone has encountered problem with SQL that contains "parenthesis" () on AIX DB2 v8.2.3

e.g. select name, address from account where (flag = 0 and account_id = 1000) order by name

SQL is in a java class and when the program executes to the SQL, it throws errors
Failed in search:com.ibm.db2.jcc.b.SqlException: Invalid operation: result set closed

Anyone? Many thanks!
Aug 13 '07 #1
  • viewed: 842

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Lasse Vågsæther Karlsen | last post: by
17 posts views Thread by hplloyd | last post: by
6 posts views Thread by Arjen | last post: by
6 posts views Thread by Fir5tSight | last post: by
6 posts views Thread by jason.cipriani@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.