Page 1 of 1

Getting error in changing DB2 environment thru set

PostPosted: Wed Nov 23, 2011 5:13 am
by vivekfun2002
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

Re: Getting error in changing DB2 environment thru set

PostPosted: Wed Nov 23, 2011 12:18 pm
by NicC
Please, do not double post. Wastes your time and ours.

Re: Getting error in changing DB2 environment thru set

PostPosted: Wed Nov 23, 2011 1:27 pm
by Anuj Dhawan
Topic Locked,

Thanks,