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
 

 

What is SQLCODE -927 and how to resolve it?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
swikruti

New User


Joined: 20 Jun 2005
Posts: 3
Location: bangalore

PostPosted: Fri Oct 05, 2007 12:07 am    Post subject: What is SQLCODE -927 and how to resolve it?
Reply with quote

What is SQLCODE -927 and how to resolve it?
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Fri Oct 05, 2007 12:11 am    Post subject: Reply to: What is SQLCODE -927 and how to resolve it?
Reply with quote

You might want to start with either of these two previous topics:

http://ibmmainframes.com/viewtopic.php?t=6372
http://ibmmainframes.com/viewtopic.php?t=6073
Back to top
View user's profile Send private message
swikruti

New User


Joined: 20 Jun 2005
Posts: 3
Location: bangalore

PostPosted: Sat Oct 06, 2007 7:58 pm    Post subject:
Reply with quote

Kevin,
You are correct and i have already checked the site still i failed to resolve that error.And one thing I have aready checked in my Run jcl where we can put the CALL attachment Facility as Y. But i falied.
My progqarm is basically a called DB2-Cobol program.and while i am trying to insert any record through front end its should insert data to the data base ..instaed of inserting the data it showed the -927 error. Although my code is correct every where and my run jcl also correct still i am getting same error. Could you give me the Sceen shot so that i can resolve that error.


Thanks,
Swikruti
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Sat Oct 06, 2007 9:02 pm    Post subject: Reply to: What is SQLCODE -927 and how to resolve it?
Reply with quote

Quote:
Although my code is correct every where and my run jcl also correct still i am getting same error


I beg to differ,

from
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnmch17/2.1.6.426?ACTION=MATCHES&REQUEST=927&TYPE=FUZZY&SHELF=DSNSHHA7.bks&DT=20061207111438&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

Quote:

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.


If Your code and run jcl were correct You would not get the error...

The message explanation seems very clear to me
You are executing Your program from the WRONG environment

review Your coding and the execution jcl

regards

e.s
Back to top
View user's profile Send private message
swikruti

New User


Joined: 20 Jun 2005
Posts: 3
Location: bangalore

PostPosted: Sat Oct 06, 2007 9:22 pm    Post subject:
Reply with quote

Thanks for the information I think you are right the environment is 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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts How to resolve IMS DB status code FM Priyanka Boga IMS DB/DC 3 Fri Jun 10, 2016 1:54 pm
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts how to Resolve SQL Error Code -924 Rajesh3825 ABENDS & Debugging 2 Thu Dec 10, 2015 2:39 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am


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