IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

What is SQLCODE -927 and how to resolve it?


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic
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
Reply with quote

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

Global Moderator


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

PostPosted: Fri Oct 05, 2007 12:11 am
Reply with quote

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

ibmmainframes.com/viewtopic.php?t=6372
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Sat Oct 06, 2007 9:02 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts Need help to resolve a hard edit COBOL Programming 8
This topic is locked: you cannot edit posts or make replies. Need help to resolve a hard edit COBOL Programming 4
No new posts SQLCODE = -122 while using the scalar... DB2 4
No new posts SQLCODE = -16002 when using XMLEXISTS DB2 1
No new posts Is SQLCODE -811 possible while fetchi... DB2 1
Search our Forums:

Back to Top