RE: sql call stored rpg procedure

[Robert Upshall <rupshall@xxxxxxxxxxx>]

I tried from strsql and it worked.


On Thu, 2004-04-08 at 12:33, Nathan M. Andelin wrote:
> 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
> 
> 
> 
> 
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) 
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>