Page 1 of 1

sqlcode -927

PostPosted: Fri Jul 23, 2010 7:02 pm
by Kal El
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?

Re: sqlcode -927

PostPosted: Fri Jul 23, 2010 8:18 pm
by NicC
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.

Re: sqlcode -927

PostPosted: Fri Jul 23, 2010 11:11 pm
by dick scherrer
Hello,

Suggest you post the jcl and control statements you submitted.

Re: sqlcode -927

PostPosted: Tue Jul 27, 2010 6:06 pm
by Kal El
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.

Re: sqlcode -927

PostPosted: Wed Jul 28, 2010 2:49 am
by dick scherrer
Good to hear you have this solved - thank you for letting us know :)

d