sqlcode -927



IBM's flagship relational database management system

sqlcode -927

Postby Kal El » Fri Jul 23, 2010 7:02 pm

Hello,
Can anyone explain -927 Sqlcode?
I am getting this error while opening a cursor in my program.
I have found the basic details but it is not very clear to me...

THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING
ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED
UNDER THE DSN COMMAND

Can any one please explain what exactly wen wrong iin simple terms?
Kal El
 
Posts: 9
Joined: Mon Jun 21, 2010 1:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sqlcode -927

Postby NicC » Fri Jul 23, 2010 8:18 pm

How are you trying to invoke your program? You should be doing it under TSO i.e. by running IJKEFT01. I cannot find a sample on my PC or find the correct manual. More research needed. You could find another rundeck that executes a DB2 program and copy that.
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: sqlcode -927

Postby dick scherrer » Fri Jul 23, 2010 11:11 pm

Hello,

Suggest you post the jcl and control statements you submitted.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: sqlcode -927

Postby Kal El » Tue Jul 27, 2010 6:06 pm

Hello i found the issue. It was because the DB2 was being invoked in our environment using IMS.However, while compiling the compiler options IMS was set to no.
Kal El
 
Posts: 9
Joined: Mon Jun 21, 2010 1:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sqlcode -927

Postby dick scherrer » Wed Jul 28, 2010 2:49 am

Good to hear you have this solved - thank you for letting us know :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post