Re: sql call stored rpg procedure

["Ruth, Brice" <bruth@xxxxxxxxxxx>]

Ditto on this, except that I use Ops Nav, from Client Access - which 
provides much the same error information in its log as STRSQL

Brice

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.
>
>