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 SQLCODE = -927

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

New User


Joined: 04 Jul 2005
Posts: 23

PostPosted: Tue Oct 04, 2005 7:48 am    Post subject: Getting SQLCODE = -927
Reply with quote

I am getting -927 as sqlcode Please help!

Thanks in advance
Back to top
View user's profile Send private message

iknow

Active User


Joined: 22 Aug 2005
Posts: 413
Location: Colarado, US

PostPosted: Tue Oct 04, 2005 10:31 am    Post subject: Re: sqlcode = -927
Reply with quote

Hi

I got this message from IBMMAINFRAMES-Error Descriptor. Please correct me if I am wrong.

THE LANGRAGE INTERFACE WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND

Quote:

Knowledge in your hands for your journey ahead
Back to top
View user's profile Send private message
satish1978

New User


Joined: 22 Jun 2006
Posts: 13
Location: mumbai

PostPosted: Thu Nov 16, 2006 2:52 pm    Post subject: -927 sqlcode
Reply with quote

http://ibmmainframes.com/references/a2.html#-927
Back to top
View user's profile Send private message
vana

New User


Joined: 27 Jul 2006
Posts: 6

PostPosted: Thu Nov 16, 2006 4:23 pm    Post subject: Re: Getting error as sqlcode = -927
Reply with quote

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


Explanation:
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.



System Action: The statement cannot be executed.


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:


The DYNAM option can result in the incorrect language interface module being loaded at runtime.
Back to top
View user's profile Send private message
pasupuleti

New User


Joined: 30 Jun 2006
Posts: 8
Location: India

PostPosted: Wed Dec 06, 2006 10:12 pm    Post subject:
Reply with quote

Hi,

I read a discussion on the web where it states an instance where you're likely to get -927. Please be warned that your situation could be different from this. Hope this would be of help:

If you're situation is that you're trying to execute a non-db2 cobol program that is calling a db2-calling program. You HAVE to use the IKJEFT01-JCL even if your main program doesn't use DB2-commands. And you have to bind a plan for this program. Ohterwise you cannot connect to the DB2-system an receive a SQL-Code -927.

Code:
//GO       EXEC PGM=IKJEFT01,DYNAMNBR=20,REGION=4M
//STEPLIB  DD DISP=SHR,DSN=TEST.LM
//         DD DISP=SHR,DSN=PROD.LM
//         DD DISP=SHR,DSN=DBNT.DSNEXIT
//         DD DISP=SHR,DSN=DBNT.DSNLOAD
//SYSOUT   DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//CEEDUMP  DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN  DD *
  DSN SYSTEM(DBNT)
  RUN PROGRAM(COBOLPGM) PLAN(BATCH01) -             
  END                                               
//*


Please correct me if I am 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 SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am
No new posts -81 SQLCODE returned when Remote Stor... kameswaramanoj.Akella DB2 1 Wed Dec 03, 2014 5:36 am


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