× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hello:
I am new in the forum. I have a problem with PreparedStatement for calling a 
RPG Program.
I have an array of AS/400 Object and then set a java.sql.Connection.
I use JtOpen 4.5 and my AS/400 have OS/400 V5R1M0.
the code is

 String c = pMyLibrary + "." + pMyProgram;

        AS400JDBCDataSource x = new AS400JDBCDataSource(y);
// y is Object AS/400 
        Connection cn = x.getConnection();
        PreparedStatement ps = cn.prepareStatement("CALL " + c + "(?)");
// the RPG Program return a ResultSet
        ps.setString(1, pData);
// pData is a String
        ResultSet rs = ps.executeQuery();
        while (rs.next()) {
          sRpta = rs.getString(1) + "|";
        }

the message is

{SQL0204] pMyProgram in pMyLibrary Type *N not found

What is the problem?????

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.