if you are connected to db with usera it will prefix all objects with usera if not specified. hence the error, because the object does not exists
always specify the complete schema.name
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
Hard coding is not possible. The file may reside in any number of different libraries, depending on the site that the account exists in. I am going to guess that I have to go another route, a stored procedure possibly? I also read that the Zend tools do allow this; the i5_ equivalents of db2_, but I dont want to go back and forth between the two (seems like db2_ tools are eaiser to use).