SQLGetInfo (Text File Driver)

  • Article

Note

This topic provides Text File Driver-specific information. For general information about this function, see the appropriate topic under ODBC API Reference.

SQLGetInfo supports the SQL_FILE_USAGE information type. The returned value is a 16-bit integer that indicates how the driver directly treats files in a data source:

  • SQL_FILE_NOT_SUPPORTED - The driver is not a single-tier driver.

  • SQL_FILE_TABLE - A single-tier driver treats files in a data source as tables.

  • SQL_FILE_QUALIFIER - A single-tier driver treats files in a data source as a qualifier.

The ODBC driver returns SQL_FILE_TABLE for the Textdriver, because each file is a table.

SQL_DBMS_VER

ISAM Version Format of version numbers
Text 1.0 01.00.0000

SQL_CATALOG_USAGE

SQL_QU_DML_STATEMENTS | SQL_QU_TABLE_DEFINITION

SQL_TIMEDATE_FUNCTIONS

SQL_FN_TD_CURDATE | SQL_FN_TD_CURTIME | SQL_FN_TD_DAYOFMONTH | SQL_FN_TD_DAYOFWEEK | SQL_FN_TD_DAYOFYEAR | SQL_FN_TD_HOUR | SQL_FN_TD_MINUTE | SQL_FN_TD_MONTH | SQL_FN_TD_NOW | SQL_FN_TD_SECOND | SQL_FN_TD_WEEK | SQL_FN_TD_YEAR