Db2 Error 42724
here for a quick overview of the sqlstate 42724 reason code 4 site Help Center Detailed answers to any questions you db2 sql error sqlcode=-4304 sqlstate=42724 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 com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -444, SQLSTATE: 42724 up vote 0 down vote favorite need urgent help on below issue . I'm getting below error when calling stored procedure XXXX written in Mainframe DB2 . In this stored procedure, we have 'GRAPHIC' & 'LONGGRAPHIC' parameter for which I'm passing "java.sql.CHAR" & "java.sql.VARCHAR" type parameter. thanks in advance for any help / suggestion . INFO: SQLErrorCodes loaded: [DB2, Derby, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase] Exception while executing Test Case org.springframework.jdbc.BadSqlGrammarException: CallableStatementCallback; bad SQL grammar [{call SYSPROC.XXXX(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}]; nested exception is com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -444, SQLSTATE: 42724, SQLERRMC: XXXX Caused by: com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -444, SQLSTATE: 42724, SQLERRMC: XXXX at com.ibm.db2.jcc.c.tf.d(tf.java:1396) at com.ibm.db2.jcc.b.jb.l(jb.java:367) at com.ibm.db2.jcc.b.jb.e(jb.java:92) at com.ibm.db2.jcc.b.w.e(w.java:72) at com.ibm.db2.jcc.b.cc.h(cc.java:203) at com.ibm.db2.jcc.c.tf.q(tf.java:1363) at com.ibm.db2.jcc.c.uf.d(uf.java:2388) at com.ibm.db2.jcc.c.vf.Z(vf.java:159) at com.ibm.db2.jcc.c.vf.execute(vf.java:142) at org.springframework.jdbc.core.JdbcTemplate$
42724 If this is your first visit, be sure to check out 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 http://www.dbforums.com/showthread.php?1022737-problem-calling-stored-procedure-DB2-SQL-error-SQLCODE-444-SQLSTATE-42724 viewing messages, select the forum that you want to visit from the selection below. Results 1 to 1 of 1 Thread: problem calling stored procedure, DB2 SQL error: SQLCODE: -444, SQLSTATE: 42724 Tweet Thread Tools Show https://groups.google.com/d/topic/comp.databases.ibm-db2/4i7_LgAbobo Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-16-04,11:38 #1 unmesh View Profile View Forum Posts Registered User Join Date Sep 2004 db2 error Posts 15 Unanswered: problem calling stored procedure, DB2 SQL error: SQLCODE: -444, SQLSTATE: 42724 We have DB2 UDB v8.2 on RedHat Linux and are having problem calling a stored procedure from Java client. The name of the stored procedure is GROWTH_CHARTS which has three varchar "in" parameters and it returns an open cursor. PROCEDURE GROWTH_CHARTS ( IN v_GUID VARCHAR(19), IN v_temp VARCHAR(7), IN v_ENC VARCHAR(19)) When we execute the stored procedure from db2 error 42724 the db2 command prompt it works fine. db2 => call nwdb2.GROWTH_CHARTS('a', 'b', 'c') Return Status = 0 When the GROWTH_CHARTS is called from a Java client we get the follwoing error - "com.ibm.db2.jcc.c.SqlException: java.sql.CallableStatement.executeQuery() was called but no result set was returned. Use java.sql.CallableStatement.executeUpdate() for non-queries." When an isolated test case with the same SQL is run, it gives an error complaining it couldn't find a file: DB2 SQL error: SQLCODE: -444, SQLSTATE: 42724, SQLERRMC: GROWTH_CHARTS;SQL040916092620920;\GROWTH_CHARTS;GR OWTH_CHARTS;4. Any help will be appreciated. Thanks! Reply With Quote Quick Navigation DB2 Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal Reports Delphi, C etc JAVA Perl and the DBI PHP ANSI SQL Unix Shell Scripts Visual Basic PC based Database Applications Brilliant Database Corel Paradox FileMaker Microsoft Access Microsoft Excel Other PC Databases General New Members & Introductions Applications & Tools Database Concepts & Design Chit Chat Marketplace Job Opportunities Suggestions & Feedback Links to other iNet owned sites web development forum Web Hosting Talk « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies
from GoogleSign inHidden fieldsSearch for groups or messages