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