Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search 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
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
References
PostPosted: Wed Oct 19, 2005 4:18 pm    Post subject: Re: Getting -927 as sql code, What is it? Reply with quote

Souvik.Sinha

New User


Joined: 22 Apr 2005
Posts: 15
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

Active User


Joined: 05 Oct 2005
Posts: 84

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
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1