Db2 Sql Error 927
Contents |
the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the how to resolve sqlcode 927 forum that you want to visit from the selection below. Results 1 to 6
Sqlcode 92p
of 6 Thread: -927 sqlcode in db2 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced
Sqlstate 51006
Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-12-11,13:54 #1 thamin View Profile View Forum Posts Registered User Join Date Jul 2011 Posts 13 Unanswered: -927 sqlcode in db2 Hello https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n927.html I am running db2 cobol program and its giving me a sql code of 0927 while executing query exec sql set ws-date - current_date end anybody have idea on how to resolve this? Thanks... Reply With Quote 09-12-11,16:17 #2 Stealth_DBA View Profile View Forum Posts Registered User Join Date May 2009 Posts 508 Provided Answers: 1 It depends on what you are trying to do. Reply With Quote 09-12-11,16:37 http://www.dbforums.com/showthread.php?1669942-927-sqlcode-in-db2 #3 Peter.Vanroose View Profile View Forum Posts Visit Homepage Registered User Join Date Sep 2004 Location Belgium Posts 1,126 Originally Posted by thamin I am running db2 cobol program and it's giving me a sql code of 0927 while executing query exec sql set ws-date - current_date end An SQLCODE -927 indicates that you run your program directly instead of using the DB2 RUN command (actually: DSN subcommand). Programs containing EXEC SQL should be run under supervision of DB2, not independently. Have a look at the DB2 Command Reference Guide (SC18-9844) for the syntax of the DSN RUN subcommand. (It's on page 377.) --_Peter Vanroose, __IBM Certified Database Administrator, DB2 9 for z/OS __IBM Certified Application Developer __ABIS Training and Consulting __http://www.abis.be/ Reply With Quote 09-12-11,17:00 #4 ARWinner View Profile View Forum Posts Registered User Join Date Jan 2003 Posts 4,286 Provided Answers: 5 Shouldn't that minus sign be an equal sign? Andy Reply With Quote 09-12-11,17:37 #5 Peter.Vanroose View Profile View Forum Posts Visit Homepage Registered User Join Date Sep 2004 Location Belgium Posts 1,126 Originally Posted by ARWinner Shouldn't that minus sign be an equal sign? Not just that: there is a colon ( : ) missing in front of the variable name: Code
Determination View previous topic :: View next topic Author Message sindujaBeginnerJoined: 20 Jun 2005Posts: 29Topics: 14 Posted: Wed Feb 18, 2009 6:34 am Post subject: -927 error http://www.mvsforums.com/helpboards/viewtopic.php?t=10570&sid=3936201a574bd46777a690ce48d25d54 while calling DB2 subroutine from IMSDB2 module. Hi , At the time of execution of the SQL in the sub-module , I am getting an error code -927 . DSNT408I SQLCODE = -927, ERROR: THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND DSNT418I SQLSTATE = 51006 SQLSTATE RETURN CODE DSNT415I SQLERRP db2 sql = DSNELI SQL PROCEDURE DETECTING ERROR I use CHANGE MAN to perform the compile of both the modules . Please let me know if this has anything to do with any compile options. Thanks, Sinduja Back to top Nic CloustonAdvancedJoined: 01 Feb 2007Posts: 972Topics: 6Location: At Home Posted: Wed Feb 18, 2009 3:02 pm Post subject: How did you try to execute the program? PGM=ABC db2 sql error or under TSO (IKJEFT01)??? The latter is how you do it._________________Utility and Program control cards are NOt, repeat NOT, JCL. Back to top Anuj DhawanIntermediateJoined: 19 Jul 2007Posts: 298Topics: 7Location: Mumbai,India Posted: Wed Sep 30, 2009 1:55 am Post subject: Is this resolved? Just in case if you still log in here... 1. Make sure you use the correct DB2 attachment stub. 2. Make sure you include the linkage control card in your development package (changeman package)._________________Regards, Anuj Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First MVSFORUMS.com Forum Index -> Problem Determination All times are GMT - 5 Hours Page 1 of 1 Jump to:Select a forumAnnouncements----------------MVSFORUMS - AnnouncementsHelp Boards----------------Application ProgrammingDatabaseUtilitiesJob Control Language(JCL)CICS and MiddlewareIMSTSO and ISPFData ManagementProblem DeterminationMainframe ChallengeAbout MvsforumsOther Technical TopicsRelated Non-Technical TopicsInterview Q & AGeneral----------------Tools and DownloadsIT NewsTechnical FAQ (Tips)----------------Programming LanguagesDB2/IMSJCL/SORTTSO and ISPF You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forum MVSFORUMS Powered by phpBB © 2001, 2005 phpBB Group