Page 1 of 1

Getting error in changing DB2 environment thru set

PostPosted: Wed Nov 23, 2011 8:14 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.Same process working fine in batch mode.. 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 10:00 am
by enrico-sorichetti
Please help me out as its one urgent change came to project.


a forum is not the best place to ask when You have time constraints,
replying is on voluntary base, on our own time and free of charge ...
and.... You might not even get a reply at all .
wiser to investigate other sources of help... the manuals maybe

Re: Getting error in changing DB2 environment thru set

PostPosted: Wed Nov 23, 2011 12:17 pm
by NicC
Or search the forum as, I think, the same subject, or similar, came up a month or so back (but it may have been on another forum).