hbycer
Posts: 24
|
Posted: 05/24/2004, 12:26 PM |
|
When building a datagrid using a DB2 table as the data source in the JSP environment, my data connection seems to set up just fine. I am able to select my table(s) and columns in the query builder etc.
However, when I either review the data or view the live page a message displays saying "xxxxx.tblname is an undefined name" where xxxxx is my user id.
I am able to correct this by going into the query builder into SQL mode and prefix any table reference with the the DB2 schema name. Example:
SELECT * FROM schema.tblname
Question...
Are there any settings in either the connection tool or query builder or otherwise which would not require our users to to deal with this error message and need to mannually handle it?
Thanks
|
|
|
|