RE: sql call stored rpg procedure

["Nathan M. Andelin" <nandel@xxxxxxxxxxxxxxxxxxx>]

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