NAME
SQLcolTypesCursor - return the column types of the query associated with a cursor

SYNOPSIS
SQLcolTypesCursor cursor result_array [row_indice]

DESCRIPTION

The SQLcolTypesCursor command returns the column types associated with an SQL cursor. The column names are returned as row number row_indice in the Tcl array result_array. The return value of SQLcolTypesSelect is the number of columns in result_array.

If the optional argument row_indice is not present, then the Tcl array will be 1 dimensional, with the first column type stored in result_array(0), the second column type stored in result_array(1) and so on.

SQL column types probably vary from implementation to implementation. This function returns the raw SQL types.

Note that only the column names are retrieved from the database, no row data is retrieved.

Before SQLcolTypesCursor can be called, one must call SQLdescribeCursor. SQLcolTypesCursor merely retrieves data that was stored during SQLdescribeCursor cursor call.

Note that the SQLcolTypesCursor command uses user defined, dynamically allocated cursors, whereas the SQLcolTypesSelect command uses a private statically allocated cursor.

OPTIONS

row_indice
    If the optional argument row_indice is present then the tcl result_array will have the first column type in result_array(row_indice,0). row_indice need not be a number, but it usually is an integer greater than or equal to zero.

FILES

~ingres/ingres/files/eqsqlda.h
    Type codes for Ingres 6.4.

KEYWORDS
database, cursor

SEE ALSO
SQLcolTypesSelect(3)

BUGS
SQL column types are probably implementation dependent.

It would be nice to have a SQLcolLengthCursor command.