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