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
 
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 IBEGENER RETURN CODE 12 anilkumar922 All Other Mainframe Topics 5 Wed Dec 13, 2017 11:41 am
No new posts Finding the plan when code compiled u... Ahemad DB2 1 Fri Dec 01, 2017 6:38 pm
No new posts Strange Code amitc23 COBOL Programming 6 Tue Nov 28, 2017 11:25 am
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm

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