MVSFORUMS.com

[Suresh Kumar R]

In a new DB2 stored procedure program I'm using two tables Tab1 and Tab2.

Tab1 table is a local database table and Tab2 is in central database.

When i am trying to bind this stored procedure with a package i am getting a bind error(SQLCODE -204).

To avoid this problem I'm calling a subprogram that will contain Tab2 table (to bind it separately) and the main program will only contain local table and use the data returned by subprogram.

Is there any way that I can use both the tables in a single program?
I want a single Bind card to accomodate both tables.

Regards
RSK

[programmer1]

If I understood your problem, Tab1 table is created on your User Id and Tab2 is on the central database.

In the program, use Tab1 qualified with your user id and use Tab2 without a qualifier.

The package must have an access to the Central database.
_________________
Regards,
Programmer