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 MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 1 Tue Jan 24, 2017 1:23 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am


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