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!
|