Db2 Sql Error Code 313
Contents |
360 games PC games db2 sql error code 803 Windows games Windows phone games Entertainment All Entertainment db2 sql error code 811 Movies & TV Music Business & Education Business Students & educators db2 sql error code 204 Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.messages.sql.doc/doc/msql00313n.html Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/819528 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Events Forums DB2-LDB2-L ArchivesNA ConferenceEMEA Conference Resources BlogsIDUG eBulletinIDUG NewsroomCommunitiesRegional User Groups Articles&Content IDUG Content ArticlesTech ChannelBeginner's BlogDB2 Hot Topics BlogContent LibraryIDUG YouTubePast Conference ContentCodeplace Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional User GroupBecome http://www.idug.org/p/fo/et/thread=6724 an IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community SQL code -313 Carlton http://stackoverflow.com/questions/31205757/sqlexception-while-invoking-mobilefirst-sqladapter Enuda SQL code -313 April 2, 2001 06:00 PM Hi everyone, I'm trying to test a SQL and gets the error shown following this text. What is it trying to tell me? My SQL looks something like this: SQL: Select column1......column18 FROM C_HDR_TB H LEFT db2 sql OUTER JOIN C_HDR_PYR_TB P ON H.C_TCN_NUM = P.C_TCN_NUM , C_HDR_TB H1 LEFT OUTER JOIN C_HDR_WARRANT_TB W ON H1.C_HDR_RA_NUM = W.C_HDR_RA_NUM WHERE H.C_TCN_NUM = ? AND H.C_TCN_NUM = P.C_TCN_NUM AND P.C_SEQ_NUM = ? AND P.C_SEQ_NUM = :WK-010-NUM-1 ERROR: DSNT408I SQLCODE = -313, ERROR: THE NUMBER OF HOST VARIABLES SPECIFIED IS db2 sql error NOTEQUAL TO THE NUMBER OF PARAMETER MARKERS DSNT418I SQLSTATE = 07001 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXRIVB SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -100 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFF9C' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION ---------+---------+---------+---------+---------+---------+---------+------ Get your FREE download of MSN Explorer at http://explorer.msn.com Terry Purcell Re: SQL code -313 April 2, 2001 06:54 PM (in response to Carlton Enuda) Carlton, Since the error message suggests that the EXECUTE are OPEN have an incorrect number of parameter markers, and you haven't mentioned these, then I'll tell what looks wrong with the SQL you have supplied. Between the first ON clause and the next LEFT OUTER JOIN is a comma and table name which should not be there. So the FROM and ON clauses should be: FROM C_HDR_TB H LEFT OUTER JOIN C_HDR_PYR_TB P ON H.C_TCN_NUM = P.C_TCN_NUM LEFT OUTER JOIN C_HDR_WARRANT_TB W ON H1.C_HDR_RA_NUM = W.C_HDR_RA_NUM Regards Terry Purcell Yevich Lawson & Assoc www.ylassoc.com -----Original Message----- From: DB
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQLException while invoking MobileFirst SQLAdapter up vote 0 down vote favorite I am getting this error: FWLSE0101E: Caused by: [project ***]com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-313, SQLSTATE=07004, SQLERRMC=null, DRIVER=3.66.46 java.lang.RuntimeException: DB2 SQL Error: SQLCODE=-313, SQLSTATE=07004, SQLERRMC=null, DRIVER=3.66.46. Performed query: update account set regTstamp = (current timestamp) where accountId = ? while invoking the SQLAdapter. Here is the invoke procedure: var AcceptTocInvokeData = { adapter : 'DataAdapter', procedure : 'updateAcceptTocDate', params: [accountId] }; WL.Client.invokeProcedure(AcceptTocInvokeData, { onSuccess: function(resp) { deferred.resolve(resp); }, onFailure: function(resp) { deferred.reject(resp); } }); and the SQLAdapter code: var prepStmt = WL.Server.createSQLStatement("update account set regTstamp = (current timestamp) where accountId = ?"); function updateAcceptTocDate(accountId) { return WL.Server.invokeSQLStatement({ preparedStatement: prepStmt, parameters: [accountId] }); } If I call the adapter from MobileFirst Studio (Run as...), it works perfectly. Does anybody know what is going on? db2 sqlexception ibm-mobilefirst mobilefirst-adapters share|improve this question edited Jul 3 '15 at 11:45 Idan Adar 36.7k52053 asked Jul 3 '15 at 11:27 Hugo