IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQL ERROR Code = -927


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 2358
Location: Israel

PostPosted: Mon Aug 13, 2007 12:13 pm
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
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
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
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
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: 2358
Location: Israel

PostPosted: Mon Aug 13, 2007 6:03 pm
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
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

Moderator Emeritus


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

PostPosted: Thu Nov 12, 2009 12:52 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
Search our Forums:

Back to Top