Db2 Sql Error Sqlcode=-313
Contents |
360 games PC games com ibm db2 jcc c sqlexception db2 sql error sqlcode 313 Windows games Windows phone games Entertainment All Entertainment db2 sql error sqlcode list Movies & TV Music Business & Education Business Students & educators db2 sql error sqlcode 305 Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n313.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 http://www.idug.org/p/fo/et/thread=6724 Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional User GroupBecome an IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community SQL code -313 Carlton Enuda SQL code https://developer.jboss.org/thread/143755 -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 db2 sql it trying to tell me? My SQL looks something like this: SQL: Select column1......column18 FROM C_HDR_TB H LEFT 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 = ? db2 sql error 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 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 clau
not work correctly without it enabled. Please turn JavaScript back on and reload this page. All Places > JBoss ESB > Discussions Please enter a title. You can not post a blank message. Please type your message and try again. 8 Replies Latest reply on May 27, 2008 8:03 PM by Len DiMaggio ESB and DB2 - DB config change needed to handle quartz? Len DiMaggio May 15, 2008 4:47 PM I'm wondering if someone has already seen and worked thru this problem.I'm trying to use DB2 as the message store DB for ESB. I believe that I have various datasource and persistence XML files correct. (I'm intentionally only looking at the JBM Db right now - not jBPM.)The server starts up cleanly, but soom goes into a very tight loop with this SQLexception:16:32:07,607 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-808016:32:07,767 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-800916:32:07,783 INFO [Server] JBoss (MX MicroKernel) [4.2.2.GA (build: SVNTag=JBoss_4_2_2_GA date=200710221139)] Started in 3m:47s:138ms16:32:25,278 WARN [JDBCSupport] SQLException caught, SQLState 07001 code:-313- assuming deadlock detected, try:1com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -313, SQLSTATE: 07001, SQLERRMC: null at com.ibm.db2.jcc.b.hh.b(hh.java:1369) at com.ibm.db2.jcc.b.hh.c(hh.java:1356) at com.ibm.db2.jcc.c.db.k(db.java:352) at com.ibm.db2.jcc.c.db.a(db.java:60) at com.ibm.db2.jcc.c.t.a(t.java:52) at com.ibm.db2.jcc.c.tb.b(tb.java:202) at com.ibm.db2.jcc.b.ih.ab(ih.java:1898) at com.ibm.db2.jcc.b.ih.d(ih.java:2467) at com.ibm.db2.jcc.b.ih.W(ih.java:525) at com.ibm.db2.jcc.b.ih.executeUpdate(ih.java:508)Files created/modified:1) New: server/default/deploy/db2-ds.xml2) Modify: server/default/deploy/jbossesb.sar/juddi-ds.xml3) Modify: server/default/deploy/jbossesb.sar/esb