How do I code bind parameters to include 2 diff'nt subsystem

gireeshsk · New User Joined: 20 Dec 2005 Posts: 6 Location: chennai

I am having a program which uses two tables that points to different subsystems (DBA1 & DBA2). How do I code my bind parameters to include both the subsystem. Please answer its urgent

twissi · Posted: Thu May 18, 2006 5:24 pm

Hi Girish,

You'll have to split the program into two such a way that one PGM could be bound to one subsystem and the other PGM to the other subsystem.

You can even design them such a way that one PGM calls the other.

You should then have a PACKAGE bind where one PGM bound to DBA1 (PACKAGE) and the other PGM bound to DBA2 (PACKAGE), finally stuffing the packages into one PLAN.

Hope this makes sense!

Cheers, Twissi.