Progress
Open Client
Developer’s Guide


Metadata Methods

The metadata information about the SDOResultSet is exposed through the com.progress.open4gl.SDOResultSetMetaData interface. An object that implements SDOResultSetMetaData is returned using the SDOResultSet.getMetaData() method. The interface, com.progress.open4gl.SDOResultSetMetaData, is an extended subset of the standard JDBC 2 java.sql.ResultSetMetaData interface. Note that SDOResultSetMetaData works with both JDK 1.1.x and JDK 1.2. Therefore, much of the Java 1.2 functionality (standard JDBC ResultSetMetaData interface) is supported even with JDK 1.1.x.

JDBC 2 Metadata Methods

The supported standard JDBC 2 methods include:

SYNTAX
int getColumnCount() 

The number of columns in the SDOResultSet.

SYNTAX
String getColumnName(int columnIndex) 

The name of the column.

SYNTAX
int getColumnType(int columnIndex) 

The SQL type of the column.

SYNTAX
int isNullable(int columnIndex) 

0 if this column is mandatory (does not allow the 4GL unknown value (?)); 1 if it is not mandatory (allows the 4GL unknown value (?)).

SYNTAX
int getColumnDisplaySize(int columnIndex) 

The maximum display size width of this column in characters.

SYNTAX
String getColumnLabel(int columnIndex) 

The 4GL dictionary label for this column.

SYNTAX
String getTableName(int columnIndex) 

The table name for this column. This is especially useful where you want to determine the original table for a column participating in a table join.

SYNTAX
boolean isReadOnly(int columnIndex) 

True if the column is an SDOResultSet read-only column.

SYNTAX
boolean isWritable(int columnIndex) 

False if the column is an SDOResultSet read-only column.

SYNTAX
String getColumnTypeName(int columnIndex) 

The 4GL data type name of the column.

Nonstandard Metadata Methods [Extension]

SDOResultSetMetaData extensions to the standard interface include the following features:

The list of supported nonstandard SDOResultSetMetaData methods follows:

SYNTAX
String getColumnValExp(int column) [Extension] 

The 4GL dictionary validation expression.

SYNTAX
String getColumnValMsg(int column) [Extension] 

The 4GL dictionary validation message.

SYNTAX
String getColumnFormat(int column) [Extension] 

The 4GL dictionary display format.

SYNTAX
String getColumnInitalValue(int column) [Extension] 

The 4GL dictionary initial value as a string.

SYNTAX
int getColumnProType(int column) [Extension] 

The 4GL data type number. The return value corresponds to one of the class constants defined in com.progress.open4gl.Parameter. For more information, see Programming Java Clients."

SYNTAX
String getColumnJavaTypeName(int column) [Extension] 

The Java type name.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095