SQLCODE -927

ramoji · New User Joined: 25 May 2007 Posts: 2 Location: hyderabad

Hi,

I am running a IMS-DB2 cobol program with enterprise cobol version. I am facing an abend with sqlcode -927. Could anyone please help me to resolve the issue...

Escapa · Posted: Mon Jul 18, 2011 6:37 pm

dick scherrer · Posted: Mon Jul 18, 2011 7:55 pm

Hello and welcome to the forum,

When you have a question, you need to post more useful information than merely some db2 return code. . .

What command/statement/process failed? What is running on the system that is similar? What do your support people have to say?

The forum can be quite useful but we need something to work with.

The description for the -927 looks to be quite clear and the resolution will be site-specific, so you need to take this to your peers or support people.

ramoji · New User Joined: 25 May 2007 Posts: 2 Location: hyderabad

Hi,
Thanks for the reply.

Sorry I am new to this forum. We are moving all old cobol codes to enterprise cobol. While running one program which has both Db2 as well IMS is running fine with old verion of cobol but failing with enterprise cobol.

It is failing in the first executable SQL in the program while opening a cursor.

I have checked in google but could not find much. It might be environmental issue or compilation option. Posted this here to check if somebody else has faced the same issue. I am using changeman as changemanagement tool.

In the abend it is not giving more information.

Akatsukami · Posted: Wed Jul 20, 2011 2:19 am

SQLCODE -927:

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

Pretty simple to diagnose and resolve if you know what you're doing, yes?

prasanth_thavva · New User Joined: 28 Jul 2005 Posts: 86 Location: Chennai

Welcome to our forum.

But dick was expecting to provide usefull information about failed SQL statement which can daignozied in this forum.

Pls try to understand and provide us the details with SQl statement and all relevant error message.

dick scherrer · Posted: Wed Jul 20, 2011 7:40 pm

Hello,

Have you read about and understood the -927? If not you need to do so - possibly by talking with your dba and other support people. . .

If there is no connection, nothing can work. . .