ODBC_SQLStatistics

4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next

version 2004


ODBC_SQLStatistics (stmtID; catalogName; schemaName; tableName; unique; reserved) Longint

ParameterTypeDescription
stmtIDLongintStatement ID
catalogNameStringCatalog name
schemaNameStringSchema name
tableNameStringTable name
uniqueLongintType of index
reservedLongintIndicates the importance of the CARDINALITY and
PAGES columns
Function resultLongintReturns the result of the MS ODBC API function
SQLStatistics

Description

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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlstatistics.asp.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.


4D - Documentation   Français   English   German   4D ODBC PRO, Command Theme List   4D ODBC PRO, Command Alphabetical List   Back   Previous   Next