ProResultSet interface extensions to java.sql.ResultSet

ProResultSet adds the following methods not found in java.sql.ResultSet, where DataType is the name of the data type. These extensions allow your application to access the data in a ResultSet based on the ABL array model (see Access temp-table array fields).

The following method returns the value of the arrayIndex element of the array field identified by fieldNum:

Syntax

Object getObject(int fieldNum, int arrayIndex)

The data type of the object is the default data type of the arrayIndex. The arrayIndex and fieldNum are 1-based.

The following method returns the value of the arrayIndex element of the array field identified by fieldName:

Syntax

Object getObject(String fieldName, int arrayIndex)

The data type of the object is the default data type of the array field. The arrayIndex and fieldName are 1-based.

The following method returns the array field identified by fieldNum:

Syntax

DataType getDataType(int fieldNum, int arrayIndex)

DataType is the name of the data type; for example, String getString(), Integer getInteger(), and so on. The arrayIndex and fieldNum are 1-based.

The following method returns the array field:

Syntax

DataType getDataType(String fieldName, int arrayIndex)

DataType is the name of the data type; for example, String getString(), Integer getInteger(), and so on. The arrayIndex and fieldName are 1-based.

For example, the following is the syntax for methods that return a value for a String and an Integer array element of a temp-table field:

String getString(int fieldNum, int arrayIndex) 
String getString(String fieldName, int arrayIndex)
Integer getInteger(int fieldNum, int arrayIndex)
Integer getInteger(String fieldName, int arrayIndex)

For a complete listing of the methods implemented by the ProResultSet interface, see the documentation in OpenEdge-install-directory/java/doc/.