Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQL ERROR Code = -927

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

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Mon Aug 13, 2007 12:08 pm    Post subject: SQL ERROR Code = -927
Reply with quote

Hi,

I am getting below error.

SQLCODE = -927, ERROR:
THE LANGUAGE INTERFACE (LI) WAS CALLED
WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND

can anybody help??

regards,
Nagu
Back to top
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Mon Aug 13, 2007 12:13 pm    Post subject:
Reply with quote

I believe the message is self-explanatory. Can you show us how the program was invoked? Is it batch of foreground?

O.
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Mon Aug 13, 2007 12:49 pm    Post subject: Re: SQL ERROR Code = -927
Reply with quote

Its batch...

the BMP step that execute both IMS & DB2...
Back to top
View user's profile Send private message
sanjayis01
Warnings : 1

New User


Joined: 13 Jun 2007
Posts: 55
Location: banaglore

PostPosted: Mon Aug 13, 2007 3:06 pm    Post subject: Re: SQL ERROR Code = -927
Reply with quote

can any one please assist for me , i m also facing the same problem.
Back to top
View user's profile Send private message
Prajesh_v_p

Active User


Joined: 24 May 2006
Posts: 133
Location: India

PostPosted: Mon Aug 13, 2007 4:03 pm    Post subject:
Reply with quote

Can you look if DYNAM option is specified, while compilation?

Thanks,
Prajesh
Back to top
View user's profile Send private message
sanjayis01
Warnings : 1

New User


Joined: 13 Jun 2007
Posts: 55
Location: banaglore

PostPosted: Mon Aug 13, 2007 4:35 pm    Post subject:
Reply with quote

Can please post specific post.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Mon Aug 13, 2007 6:03 pm    Post subject:
Reply with quote

The message says that you should run it under the DSN interface, that is: The EXEC PGM should be IKJEFT01, and in SYSTSIN you should have DSN RUN PROGRAM() etc...

O.
Back to top
View user's profile Send private message
nagaraj_bez

New User


Joined: 09 Jun 2005
Posts: 10

PostPosted: Wed Nov 11, 2009 11:28 am    Post subject: Reply to: SQL ERROR Code = -927
Reply with quote

Thankx a lot! This helped me resolving my prob which was the same. i was not using the DSN=(pgm name) format for a db2+cobol pgrm. instead was giving just exec pgm = 'xyz' which threw -927 sql code
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: Thu Nov 12, 2009 12:52 am    Post subject: Reply to: SQL ERROR Code = -927
Reply with quote

Good to hear this helped - thanks for letting us know.

d
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 Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us