sqlgetinfo-text-file-driver.md

title	SQLGetInfo (Text File Driver) | Microsoft Docs
ms.custom
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	connectivity
ms.reviewer
ms.technology	connectivity
ms.topic	conceptual
helpviewer_keywords	SQLGetInfo function [ODBC], Text File Driver text file driver [ODBC], SQLGetInfo
ms.assetid	6b7a630e-47f8-4ee1-b2a7-476bc1d0b0d4
author	David-Engel
ms.author	v-daenge

SQLGetInfo (Text File Driver)

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