The View exists in DB2, but no table exists with that name. Yes, 42704 is throws if table is not found.
I can run the SQL generated SQL by iBatis (that is spit out in Console) in DB2 control center and get successful results. Yes, while table does not exist, the view exist. The error code of 42704 is thrown if table is not found. The goal is to run the query against the View (which exists for the schema), not the table. -- View this message in context: http://old.nabble.com/Select-from-View-%28as-opposed-to-table%29-using-iBatis-tp28835900p28836170.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org