MVSFORUMS.com

Manas Biswal · Posted: Fri Jan 03, 2003 1:28 am Post subject: SQLCODE -927

Hi all,

What can be the possible causes of a -927 SQLCODE in a CICS-DB2 Program?. I checked the DB2TRAN and DB2E. They look fine. I double checked the plan into which I bound my DBRM. I am also not able to get any dump in the DSNMSTR job. Please provde me with some hints on how to solve this.

Regards,
Manas

kolusu · Posted: Fri Jan 03, 2003 5:52 am Post subject:

Manas,

Did you link-edit your CICS porgram with DSNCLI??

Here is a detailed explanation for -927

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.425?SHELF=&DT=20010718150520

Hope this helps...

cheers

kolusu

Manas Biswal · Posted: Fri Jan 03, 2003 8:05 am Post subject:

Thanks a ton Kolusu. Indeed, I had forgotten to include DSNCLI while link-editing my program. I never could map -927 to that.
Now, the problem is resolved.
Thanks Again,

Regards,
Manas

Kev · Beginner Joined: 02 Jan 2003 Posts: 2 Topics: 0

If you have QwikRef you could have got the info from there.

Manas Biswal · Posted: Mon Jan 06, 2003 12:07 am Post subject:

My fault Kev. Smile

When I got the SQLCODE of -927, I checked the code and found the following in a reference book(Mullins) -