Standard methods in the ProResultSetMetaData class

Java Open Clients

Passing Temp-tables as SQL ResultSet Parameters : Passing a TABLE or TABLE-HANDLE as an OUTPUT parameter : Getting meta data for OUTPUT TABLE and TABLE-HANDLE parameters : 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.

Table 42. ABL to SQL data type mappings
ABL data type	SQL data type
BLOB	BLOB
CHARACTER	LONGVARCHAR
CLOB	CLOB
COM-HANDLE	BIGINT
DATE	DATE
DATETIME DATETIME-TZ	TIMESTAMP
DECIMAL	DECIMAL
INT64	BIGINT
INTEGER	INTEGER
LOGICAL	BIT
RAW	VARBINARY
RECID	BIGINT
ROWID	VARBINARY
WIDGET-HANDLE	BIGINT