RE: sql call stored rpg procedure

Robert,

It's been helpful to me to try calls using interactive SQL first (STRSQL
Command), which checks statement syntax, and offers more descriptive error
messages.  Then insert statements into programs.

HTH,

Nathan.

------------------------------

message: 2
date: Thu, 08 Apr 2004 11:25:44 -0500
from: Robert Upshall <rupshall@xxxxxxxxxxx>
subject: sql call stored rpg procedure

Hi,

I am using the JTOpen JDBC driver to connect to our iSeries.  I am
attempting to create a sql CallableStatement to call a rpg program.

On this line:

   sqlCall = con.prepareCall("CALL JLIB.TEST(?,?)");

I get this exception:

Exception in thread "main" java.sql.SQLException: [SQL0204] TEST in JLIB
type *N not found.
        at com.ibm.as400.access.JDError.throwSQLException(JDError.java:594)
        at com.ibm.as400.access.JDError.throwSQLException(JDError.java:565)
        at
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.jav
a:1331)
        at
com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStat
ement.java:182)
        at
com.ibm.as400.access.AS400JDBCCallableStatement.<init>(AS400JDBCCallableStat
ement.java:107)
        at
com.ibm.as400.access.AS400JDBCConnection.prepareCall(AS400JDBCConnection.jav
a:1582)
        at
com.ibm.as400.access.AS400JDBCConnection.prepareCall(AS400JDBCConnection.jav
a:1483)
        at com.psasoft.test.StaticSqlCall.main(StaticSqlCall.java:24)



Can anybody offer any support?

Robert