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
 

 

Getting -927 as sql code, What is it?

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

New User


Joined: 18 Oct 2005
Posts: 5
Location: Bangalore

PostPosted: Wed Oct 19, 2005 4:18 pm    Post subject: Getting -927 as sql code, What is it?
Reply with quote

hi all...i am getting -927 as sql code.....according to the error desc its related to db2 connection....can some one explain it
Back to top
View user's profile Send private message

Souvik.Sinha

New User


Joined: 22 Apr 2005
Posts: 24
Location: New York, USA

PostPosted: Wed Oct 19, 2005 9:13 pm    Post subject:
Reply with quote

Pradeep,
This is what I have regarding SQL Code -927:

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

In the TSO environment, the user has attempted to execute an
application program without first establishing the correct execution
environment by issuing the DSN command. In the IMS, CICS, or call
attachment facility (CAF) environment, the user has attempted to execute
an application program that is not using the correct language interface
module.

Programmer Response: In the TSO environment, DB2 application programs should be invoked under the RUN subcommand of the DSN command processor.
In the IMS, CICS or CAF environment check that the application was
link-edited with or is dynamically allocating the correct language
interface module. The language interface modules required in each
environment are as follows:

o IMS: DFSLI000
o CICS: DSNCLI
o CAF: DSNALI
o TSO: DSNELI

The DYNAM option can result in the incorrect language interface module
being loaded at runtime.

So, please specify the correct language-interface module during compilation.

With regards,
Souvik
Back to top
View user's profile Send private message
nikyojin

New User


Joined: 05 Oct 2005
Posts: 94

PostPosted: Thu Oct 20, 2005 4:09 pm    Post subject:
Reply with quote

Hi pradeep,
The explanation given by souvik is exactly correct.
Pls chk the run JCL u r using.If the pgm to be run is a Cobol-DB2 pgm use the appropriate PGM ie IKJEFT01,IKJEFT1B.....
If it is a pure cobol pgm mention the pgm name...

Hope this helps.....
Back to top
View user's profile Send private message
praveenkumar ponamala

New User


Joined: 26 Jul 2010
Posts: 3
Location: chennai

PostPosted: Thu Jun 09, 2011 4:56 pm    Post subject: Reply to: Getting -927 as sql code, What is it?
Reply with quote

Hi all ,

Even i'm getting the same error, i have an IMS program which is calling a cobol-DB2 program with static call....i compiled my IMS program(no db2 components in it) in chgman with "IMS DLITxxx ENTRY" option as Y ....and the cobol-DB2 program with "DB2-IMS ATTACH" option as Y....

my binding the db2 program is correct n also run JCL for IMS program is
also correct ( i have 100% positive abt it)

now i'm getting -927 error when it encountering the first db2 query....

can some help me here , it would be very thankful icon_smile.gif
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 Jun 09, 2011 8:20 pm    Post subject:
Reply with quote

Hello,

If you are 100% positive that everything is correct, we may not be able to help.

Suggest you talk with your dba and/or some senior on your project and compare this problem process with a similar process that is working.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7996
Location: Bellevue, IA

PostPosted: Thu Jun 09, 2011 8:29 pm    Post subject:
Reply with quote

It must be nice to be 100% positive you've done something correctly, especially when the computer is 100% positive there's something not right since it's giving the -927 code. I rarely hit more than 95% positive things are correct, even when the programs are running as they should -- there's always that chance I missed something that's going to catch me next time the job runs!

But then, I only have 36 years of experience with how things can go wrong.
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 JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 2 Thu Jan 12, 2017 12:02 pm


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