Hello, I wanted to call a Stored Procedure which is calling an RPG program thats returning one result set from JAVA. I am trying to alter an application that is already written in java accessing iseries RPG (business logic ). Currently this program uses PCML to call RPG, which I want to replace it by calling Stored procedure. I have pasted the half written code below. Can anybody please help on how to do that. Basically i want to get the result set from RPG in Java Thanks Connection con = null; CallableStatement sqlCall; sqlCall = con.prepareCall("CALL RSRINIVA.TESTPROC(?,?)"); //sqlCall.set sqlCall.execute(); ResultSet rs = sqlCall.getResultSet(); while(rs.next())
Code
Code
Comment