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