View previous topic :: View next topic
|
Author |
Message |
Keanehelp
New User
Joined: 27 May 2008 Posts: 71 Location: USA, CA.
|
|
|
|
I have access on an alias of a DB2 table but not on the main table.
This table is accessed through a subroutine/API called from a main program.
I included the package of the subroutine in the main program's plan(I used alias name only).
Although main program binds successfully but as soon as DB2 table is accessed in the subroutine it returns -805. Also in log it shows that system resolved table name as Schema(I don't have access to).tablename rather Alias(I have access to).table name
Any pointers??? |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Pointer :
Google on : DB2 805 |
|
Back to top |
|
|
Keanehelp
New User
Joined: 27 May 2008 Posts: 71 Location: USA, CA.
|
|
|
|
Thanks Peter for your suggestion, but doesn't work.
I need to know why the table did not get resolve as alias.tablename. Couldn't find any appropriate reasoning on google.
Thanks |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
sounds as if the subroutine was not bound with the alias.
why don't you investigate at your shop how others have accomplished this. |
|
Back to top |
|
|
|