Does anybody have any idea how to get a java.sql.ResultSet back from a Informix stored procedure. I actually was able to get a ResultSet back but can only access it using a column index (e.g. rs.getString(1)) and not using column name (e.g rs.getString("first_name)).
i think theres something wrong with the way i am defining my stored procedure. Any help with an example would really be appreciated.
No, you are doing fine. Column names are not available in Informix stored procedure resultsets. I have first hand experience with the situation you describe. Does this behavior apply to only Informix? I don't know.