Column

Size

Value

1

1

SQL level - This value indicates the SQL grammar supported by the driver. See the 'ODBC Programmer's Reference' for more details on the SQL Grammar descriptions. The returned character value can be one of the following:

0 - Minimum grammar supported.

1 - Core grammar supported.

2 - Extended grammar supported.

2

1

Read only - This character value indicates whether the data source is accessed in a read only mode or not. The returned character value can be one of the following:

N - Read only is not used.

Y - Read only is used.

3

1

Accessible tables - This character value indicates whether the data source tables are accessible or not. The character value can be one of the following:

N - Tables are not accessible.

Y - Tables are accessible.

4

1

Add columns - This character value indicates if the ability to add multiple columns in a single ALTER TABLE statement is supported. The character value can be one of the following:

N - This feature is not supported.

Y - This feature is supported.

5

1

Drop columns - This character value indicates if the ability to drop columns is supported. The character value can be one of the following:

N - This feature is not supported.

Y - This feature is supported.

6

1

Correlation name support - This character value indicates if correlation names are supported. The character value can be one of the following:

N - Correlation names are not supported.

A - Correlation names are supported and can be any user-defined name.

D - Correlation names are supported but must differ from names of the tables they represent.

7

1

Column alias support - This character value indicates if the data source supports column aliases. The character value can be one of the following:

N - This feature is not supported.

Y - This feature is supported.

8

1

Procedure support - This character value indicates if the data source supports procedures and the driver supports the ODBC procedure invocation syntax. The character value can be one of the following:

N - This feature is not supported.

Y - This feature is supported.

9

1

Procedures accessible - This character value indicates if the user can execute all procedures thar are returned by SQLProcedures. The character value can be one of the following:

N - There may be procedures returned that the user cannot execute.

Y - The user can execute all procedures returned by SQLProcedures.

10

1

Identifier case - The character value indicates the case sensitivity of the SQL identifiers. The character values can be one of the following:

U - Identifiers in SQL are not case-sensitive and are stored in uppercase in system catalog.

L - Identifiers in SQL are not case-sensitive and are stored in lowercase in system catalog.

S - Identifiers in SQL are case-sensitive and are stored in mixed case in system catalog.

M - Identifiers in SQL are not case-sensitive and are stored in mixed case in system catalog.

11

1

Quoted identifier case - This character value indicates the case sensitivity of quoted identifiers in SQL. The character value can be one of the following:

U - Quoted identifiers in SQL are not case-sensitive and are stored in uppercase in the system catalog.

L - Quoted identifiers in SQL are not case-sensitive and are stored in lowercase in the system catalog.

S - Quoted identifiers in SQL are case-sensitive and are stored in mixed case in the system catalog.

M - Quoted identifiers in SQL are not case-sensitive and are stored in mixed case in the system catalog.

12

1

Quoted Identifier Character - This character value that is used as the starting and ending delimiter of a quoted (delimited) identifier in SQL statements. (Identifiers passed as arguments to ODBC functions do not need to be quoted.) If the data source does not support quoted identifiers, a blank is returned.

13

1

Search character escape - This character value specifies what the driver supports as an escape character that permits the use of the pattern match metacharacters underscore (_) and percent sign (%) as valid characters in search patterns. This escape character applies only for those catalog function arguments that support search strings.

14

1

Outer joins - This character value indicates if the data source supports outer joins or not. The character value can be one of the following:

N - This feature is not supported.

Y - This feature is supported.

15

1

Expressions in Order By clause - This character value indicates if the data source supports expressions in the ORDER BY list. The character value can be one of the following:

N - This feature is not supported.

Y - This feature is supported.

16

1

Order By columns in Select - This character value indicates if the columns in the ORDER BY clause must be in the select list or not. The character value can be one of the following:

N - The columns in the ORDER BY do not have to be in the select list.

Y - The columns in the ORDER BY do have to be in the select list.

17

1

Group By support - This character value specifies the relationship between the columns in the GROUP BY clause and the nonaggregated columns in the select list. The character value can be one of the following:

N - GROUP BY clauses are not supported.

E - The GROUP BY clause must contain all nonaggregated columns in the select list. It cannot contain any other columns.

C - The GROUP BY clause must contain all nonaggregated columns in the select list. It can contain columns that are not in the select list.

R - The columns in the GROUP BY clause and the select list are not related. The meaning of nongrouped, nonaggregated columns in the select list is data source–dependent.