Returns the designated column’s SQL type for a JSP Web target.
PSCursorClass objects
cursorobject.GetColumnType ( int iCol )
Argument |
Description |
|---|---|
cursorobject |
A variable that contains a reference to an instance of PSCursorClass |
iCol |
Number of the column for which you want to obtain the SQL type |
int
Returns a static member variable in java.sql.Types. For a list of SQL types, see the Sun Microsystems Web site.
Use this method in conjunction with GetColumn<DataType> methods to obtain values in a cursor. In JSP targets you cannot use GetValue to obtain column values in a cursor.
The following example retrieves the type of the fifth column in the mycursor object:
column_type = mycursor.GetColumnType(5);
