Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SQLCODE -927

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ramoji

New User


Joined: 25 May 2007
Posts: 2
Location: hyderabad

PostPosted: Mon Jul 18, 2011 6:24 pm    Post subject: SQLCODE -927
Reply with quote

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...
Back to top
View user's profile Send private message

Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Mon Jul 18, 2011 6:37 pm    Post subject: Re: SQLCODE -927
Reply with quote

ramoji wrote:
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...


Why are you not refering documentation? What does it say?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jul 18, 2011 7:55 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
ramoji

New User


Joined: 25 May 2007
Posts: 2
Location: hyderabad

PostPosted: Tue Jul 19, 2011 12:04 pm    Post subject: Reply to: SQLCODE -927
Reply with quote

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.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1777
Location: Bloomington, IL

PostPosted: Wed Jul 20, 2011 2:19 am    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
prasanth_thavva

New User


Joined: 28 Jul 2005
Posts: 86
Location: Chennai

PostPosted: Wed Jul 20, 2011 12:25 pm    Post subject: Reply to: SQLCODE -927
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jul 20, 2011 7:40 pm    Post subject:
Reply with quote

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. . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us