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