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

Home Questions Articles Browse Topics Latest Top Members FAQ

home > topics > db2 database > questions > db2 on aix throw exception with sql that has (
+ 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.

Question stats

  • viewed: 792
  • replies: 0
  • date asked: Aug 13 '07
BYTES.COM © 2019 About Bytes | Advertise on Bytes | Privacy Policy | Manage Cookies
Sitemap | DB2 Database Answers Sitemap | DB2 Database Insights Sitemap

Follow us to get the Latest Bytes Updates