By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

DB2 on AIX throw exception with SQL that has (

P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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