MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

SQLCODE -927

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
Manas Biswal
Intermediate


Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India

PostPosted: Fri Jan 03, 2003 1:28 am    Post subject: SQLCODE -927 Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12358
Topics: 75
Location: San Jose

PostPosted: Fri Jan 03, 2003 5:52 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Manas Biswal
Intermediate


Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India

PostPosted: Fri Jan 03, 2003 8:05 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
Kev
Beginner


Joined: 02 Jan 2003
Posts: 2
Topics: 0

PostPosted: Fri Jan 03, 2003 9:49 am    Post subject: Reply with quote

If you have QwikRef you could have got the info from there.
Back to top
View user's profile Send private message
Manas Biswal
Intermediate


Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India

PostPosted: Mon Jan 06, 2003 12:07 am    Post subject: Reply with quote

My fault Kev. Smile When I got the SQLCODE of -927, I checked the code and found the following in a reference book(Mullins) -
Quote:

The language interface was called when the connecting environment was not established. Invoke the program using the DSN command.

On reading the above, I somehow foolishly thought that it was the job of the SYSPROG and didn't try to resolve the same. When Kolusu talked about DSNCLI, only then I realized that there was some problem while link editing the program.

Regards,
Manas
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group