Db2 Sql Error Sqlcode=-444 Sqlstate=42724
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 http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.messages.sql.doc/doc/msql00444n.html 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 . http://stackoverflow.com/questions/16902330/com-ibm-db2-jcc-c-sqlexception-db2-sql-error-sqlcode-444-sqlstate-42724 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$5.doInCallableStatement(JdbcTemplate.java:906) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:872) at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:904) at org.springframework.jdbc.object.StoredProcedure.execute(StoredProcedure.java:113) at com.cst.test.common.SPCall.execute(SPCall.java:73) at com.cst.test.daoLayer.SPTest.testLogic(SPTest.java:71) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99) at org.junit.internal.runners.TestMethodRunner.
your question and get tips & solutions from a community of 418,478 IT Pros & Developers. It's quick & easy. SQL0444N Reason Code 4 SQLSTATE=42724 P: n/a GarthVader I'm new to DB2 and am trying to execute a parameterized https://bytes.com/topic/db2/answers/449074-sql0444n-reason-code-4-sqlstate-42724-a stored procedure from within a VB 6.0 application. We're using DB2 WSE version 8.2 with fixpack 10 running on a Windows Small Business Server 2003. I created the stored procedure on the DB2 server. When I call the sp from within my VB code, it uses a DSN to connect to the database. The DSN uses the IBM DB2 ODBC Driver. I get the following error message: Error: [IBM][CLI Driver][DB2/NT] SQL0444N Routine "*PATIENTS" (specific name "SQL060124151726030") is implemented db2 sql with code in library or path "...ISITS_PATIENT", function "p_INS_VISITS_PATIENTS" which cannot be accessed. Reason code: "4". SQLSTATE=42724 Security is set up on the database and I have ensured that the proper groups have permissions to execute the stored procedure in question as well as to perform SELECT and INSERT operations on the underlying table. All other stored procedures seem to function correctly when called from the application. It is only with this newly created sp that I receive the db2 sql error error message. All other sp's were created by the previous developers. This is the only sp I have created and I used the Development Center to create it. Does anyone know what might be causing this error? Jan 24 '06 #1 Post Reply Share this Question 1 Reply P: n/a Serge Rielau GarthVader wrote: I'm new to DB2 and am trying to execute a parameterized stored procedure from within a VB 6.0 application. We're using DB2 WSE version 8.2 with fixpack 10 running on a Windows Small Business Server 2003. I created the stored procedure on the DB2 server. When I call the sp from within my VB code, it uses a DSN to connect to the database. The DSN uses the IBM DB2 ODBC Driver. I get the following error message: Error: [IBM][CLI Driver][DB2/NT] SQL0444N Routine "*PATIENTS" (specific name "SQL060124151726030") is implemented with code in library or path "...ISITS_PATIENT", function "p_INS_VISITS_PATIENTS" which cannot be accessed. Reason code: "4". SQLSTATE=42724 Security is set up on the database and I have ensured that the proper groups have permissions to execute the stored procedure in question as well as to perform SELECT and INSERT operations on the underlying table. All other stored procedures seem to function correctly when called from the application. It is only with this newly created sp that I receive the error message. All other sp's were created by the previous developers. T