Getting error in changing DB2 environment thru set



IBM's flagship relational database management system

Getting error in changing DB2 environment thru set

Postby vivekfun2002 » Wed Nov 23, 2011 5:13 am

Hi ,

I have one CICS program which we are doing the changes and its there in "DB2T" region which is DB2 region.In that program we are calling one other program which have sql query in different region and different DB2 region. So in 1st program we are setting the DB2 region dynamically using set statement. I am able to connect to the different region but getting -805 sql code. As per my understanding , due to different plan its giving the error but dont know where i can define the plan so that i can access the table of different region in CICS program. Please help me out as its one urgent change came to project. Thanks in advance
vivekfun2002
 
Posts: 2
Joined: Tue Nov 22, 2011 11:16 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Getting error in changing DB2 environment thru set

Postby NicC » Wed Nov 23, 2011 12:18 pm

Please, do not double post. Wastes your time and ours.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Getting error in changing DB2 environment thru set

Postby Anuj Dhawan » Wed Nov 23, 2011 1:27 pm

Topic Locked,

Thanks,
Anuj Dhawan
 
Posts: 273
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post