Standard methods in the ProResultSetMetaData class

The ProResultSetMetaData class has the following standard public methods, which allow you to view the elements of ABL array fields as individual columns, using the flat model:

The following methods are part of the standard java.sql.ResultSetMetaData interface and are useful if the client wants to write standard code that could access any JDBC ResultSet:

int getColumnCount() throws ProSQLException

String getColumnName(int columnNum) throws ProSQLException

int getColumnType(int columnNum) throws ProSQLException

The getColumnType() method returns an int constant for the standard SQL types as shown in the following table. The SQL data type column in the table shows the type names as specified by the java.sql.Types class. For example:

String getColumnTypeName(int columnNum) throws ProSQLException

The getColumnTypeName() method returns the corresponding ABL data type names shown in the following table under ABL data type.