ODBC_SQLStatistics

Home

4D v16

ODBC_SQLStatistics


ODBC_SQLStatistics ( stmtID ; catalogName ; schemaName ; tableName ; unique ; reserved ) -> Funktionsergebnis

Parameter	Typ	Beschreibung
stmtID	Lange Ganzzahl	Statement ID
catalogName	String	Catalog name
schemaName	String	Schema name
tableName	String	Table name
unique	Lange Ganzzahl	Type of index
reserved	Lange Ganzzahl	Indicates the importance of the CARDINALITY and PAGES columns
Funktionsergebnis	Lange Ganzzahl	Returns the result of the MS ODBC API function SQLStatistics

The ODBC_SQLStatistics command retrieves a list of statistics about a single table and the indexes associated with the table.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

catalogName is the catalog name.

schemaName is the schema name.

tableName is the table name.

unique indicates the type of index and can have one of the following values: SQL_INDEX_UNIQUE or SQL_INDEX_ALL.

reserved indicates the importance of the CARDINALITY and PAGES columns.

For more information, please see the SQLStatistics function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms711022(VS.85).aspx.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.