NAME
SQLcolTypesSelect - execute a select statement, return the column types as a Tcl array

SYNOPSIS
SQLcolTypesSelect [-1d] result_array select_statement

DESCRIPTION

The SQLcolTypesSelect command executes the SQL select statement sql_command and returns the SQL column types in the Tcl array result_array. SQL column types probably vary from implementation to implementation. This function returns the raw SQL types. The return value of SQLcolTypesSelect is the number of columns in result_array. SQL errors are handled by appending the SQL error message to the results and returning TCL_ERROR.

This command is a specialized form of SQLexec(3).

Note that only the column names are retrieved from the database, no row data is retrieved. If only the column names are needed, then SQLcolTypesSelect is much more efficient than SQLselect.

This command uses a private, statically allocates SQL Data Area (SQLDA). Use of this command will not conflict with user defined cursors.

EXAMPLE

             SQLcolTypesSelect header * from vertex2

FILES

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

KEYWORDS
database, select

SEE ALSO
SQLcolTypesCursor(3), SQLcolNamesSelect(3), SQLcolNamesCursor(3), SQLselect(3), SQLselectRows(3)

BUGS
SQL column types are probably implementation dependent.

Note that Ingres 6.4 does not allow interleaved access to two open cursors. Commands like SQLfetch and SQLcolTypesSelect both access two different cursors.