Joined: 22 Apr 2005 Posts: 24 Location: New York, USA
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
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.
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...
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....
Joined: 06 Jun 2008 Posts: 8165 Location: East Dubuque, Illinois, USA
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.