Hitachi

Hitachi Advanced Database Application Development Guide


16.13 Information types that can be specified for InfoType in SQLGetInfo and SQLGetInfoW

The following table lists and describes the information types that can be specified for InfoType.

Table 16‒18: Information types that can be specified for InfoType

No.

Information type (InfoType)

Description (convention)

Return value

Data type

1

SQL_ACCESSIBLE_PROCEDURES

One of the following values:

Y

SQLProcedures can execute all procedures.

N

There is at least one procedure that SQLProcedures cannot execute.

Returns N.

  • SQLCHAR *

  • SQLWCHAR *

2

SQL_ACCESSIBLE_TABLES

One of the following values:

Y

The SELECT privileges are guaranteed to all tables returned by SQLTables.

N

There is at least one table returned by SQLTables that the application program cannot access.

Returns Y.

  • SQLCHAR *

  • SQLWCHAR *

3

SQL_ACTIVE_ENVIRONMENTS

Maximum number of active environments that the driver supports. If no limit is specified or the limit is unknown, 0 is returned.

Returns 0.

SQLUSMALLINT

4

SQL_AGGREGATE_FUNCTIONS

Support status for aggregation functions.

Returns the following bit strings:

  • SQL_AF_ALL

  • SQL_AF_AVG

  • SQL_AF_COUNT

  • SQL_AF_DISTINCT

  • SQL_AF_MAX

  • SQL_AF_MIN

  • SQL_AF_SUM

SQLUINTEGER

5

SQL_ALTER_DOMAIN

The clauses in the ALTER DOMAIN statement that are supported by the data source.

A return value of 0 means that the ALTER DOMAIN statement is not supported.

Returns 0.

SQLUINTEGER

6

SQL_ALTER_TABLE

The clauses in the ALTER TABLE statement that are supported by the data source.

Returns the following bit string according to the value specified for the SQL_ATTR_ODBC_VERSION environment handle:

For SQL_OV_ODBC2

SQL_AT_ADD_COLUMN

For SQL_OV_ODBC3

SQL_AT_ADD_COLUMN_SINGLE

SQLUINTEGER

7

SQL_ASYNC_MODE

The driver's asynchronous support level.

Returns SQL_AM_NONE.

SQLUINTEGER

8

SQL_BATCH_ROW_COUNT

The driver's behavior on available row counts.

Returns 0.

SQLUINTEGER

9

SQL_BATCH_SUPPORT

The driver's support for batches.

Returns 0.

SQLUINTEGER

10

SQL_BOOKMARK_PERSISTENCE

Processing for which bookmarks are enabled.

Returns 0.

SQLUINTEGER

11

SQL_CATALOG_LOCATION

A value indicating the position of the catalog in a qualified table name.

Returns 0.

SQLUSMALLINT

12

SQL_CATALOG_NAME

One of the following values:

Y

The server supports catalog names.

N

The server does not support catalog names.

Returns N.

  • SQLCHAR *

  • SQLWCHAR *

13

SQL_CATALOG_NAME_SEPARATOR

A string of one or more characters that is defined as a separator. This separator is placed between a catalog name and the element that follows or precedes it. If the data source does not support catalogs, a null character string is returned.

Returns a null character string.

  • SQLCHAR *

  • SQLWCHAR *

14

SQL_CATALOG_TERM

The data source vendor's name as a catalog. If the data source does not support catalogs, a null character string is returned.

Returns a null character string.

  • SQLCHAR *

  • SQLWCHAR *

15

SQL_CATALOG_USAGE

The statements in which catalogs can be used.

If the data source does not support catalogs, 0 is returned.

Returns 0.

SQLUINTEGER

16

SQL_COLLATION_SEQ

The name of the collation sequence (default collation for the server's default character set). If the name is unknown, a null character string is returned.

Returns a null character string.

  • SQLCHAR *

  • SQLWCHAR *

17

SQL_COLUMN_ALIAS

One of the following values:

Y

The data source supports column aliases.

N

The data source does not support column aliases.

Returns Y.

  • SQLCHAR *

  • SQLWCHAR *

18

SQL_CONCAT_NULL_BEHAVIOR

How the data source concatenates NULL-valued character string data type columns with non-NULL-valued character string data type columns.

Returns SQL_CB_NULL.

SQLUSMALLINT

19

SQL_CONVERT_BIGINT

Conversions by the CONVERT scalar function that are supported by the data source.

Returns the following bit strings:

  • SQL_CVT_BIGINT

  • SQL_CVT_CHAR

  • SQL_CVT_DATE

  • SQL_CVT_DECIMAL

  • SQL_CVT_DOUBLE

  • SQL_CVT_INTEGER

  • SQL_CVT_TIMESTAMP

  • SQL_CVT_VARCHAR

SQLUINTEGER

20

SQL_CONVERT_BINARY

Returns the following bit strings:

  • SQL_CVT_BINARY

  • SQL_CVT_CHAR

  • SQL_CVT_VARBINARY

  • SQL_CVT_VARCHAR

SQLUINTEGER

21

SQL_CONVERT_BIT

Returns 0.

SQLUINTEGER

22

SQL_CONVERT_CHAR

Returns the following bit strings:

  • SQL_CVT_BIGINT

  • SQL_CVT_BINARY

  • SQL_CVT_CHAR

  • SQL_CVT_DATE

  • SQL_CVT_DECIMAL

  • SQL_CVT_DOUBLE

  • SQL_CVT_INTEGER

  • SQL_CVT_TIME

  • SQL_CVT_TIMESTAMP

  • SQL_CVT_VARBINARY

  • SQL_CVT_VARCHAR

SQLUINTEGER

23

SQL_CONVERT_DATE

Returns the following bit strings:

  • SQL_CVT_BIGINT

  • SQL_CVT_CHAR

  • SQL_CVT_DATE

  • SQL_CVT_INTEGER

  • SQL_CVT_TIMESTAMP

  • SQL_CVT_VARCHAR

SQLUINTEGER

24

SQL_CONVERT_DECIMAL

Returns the following bit strings:

  • SQL_CVT_BIGINT

  • SQL_CVT_CHAR

  • SQL_CVT_DECIMAL

  • SQL_CVT_DOUBLE

  • SQL_CVT_INTEGER

  • SQL_CVT_VARCHAR

SQLUINTEGER

25

SQL_CONVERT_DOUBLE

Returns the following bit strings:

  • SQL_CVT_BIGINT

  • SQL_CVT_CHAR

  • SQL_CVT_DECIMAL

  • SQL_CVT_DOUBLE

  • SQL_CVT_INTEGER

  • SQL_CVT_VARCHAR

SQLUINTEGER

26

SQL_CONVERT_FLOAT

Returns 0.

SQLUINTEGER

27

SQL_CONVERT_INTEGER

Returns the following bit strings:

  • SQL_CVT_BIGINT

  • SQL_CVT_CHAR

  • SQL_CVT_DATE

  • SQL_CVT_DECIMAL

  • SQL_CVT_DOUBLE

  • SQL_CVT_INTEGER

  • SQL_CVT_TIMESTAMP

  • SQL_CVT_VARCHAR

SQLUINTEGER

28

SQL_CONVERT_INTERVAL_YEAR_MONTH

Returns 0.

SQLUINTEGER

29

SQL_CONVERT_INTERVAL_DAY_TIME

Returns 0.

SQLUINTEGER

30

SQL_CONVERT_LONGVARBINARY

Returns 0.

SQLUINTEGER

31

SQL_CONVERT_LONGVARCHAR

Returns 0.

SQLUINTEGER

32

SQL_CONVERT_NUMERIC

Returns 0.

SQLUINTEGER

33

SQL_CONVERT_REAL

Returns 0.

SQLUINTEGER

34

SQL_CONVERT_SMALLINT

Returns 0.

SQLUINTEGER

35

SQL_CONVERT_TIME

Returns the following bit strings:

  • SQL_CVT_CHAR

  • SQL_CVT_TIME

  • SQL_CVT_VARCHAR

SQLUINTEGER

36

SQL_CONVERT_TIMESTAMP

Returns the following bit strings:

  • SQL_CVT_BIGINT

  • SQL_CVT_CHAR

  • SQL_CVT_DATE

  • SQL_CVT_INTEGER

  • SQL_CVT_TIMESTAMP

  • SQL_CVT_VARCHAR

SQLUINTEGER

37

SQL_CONVERT_TINYINT

Returns 0.

SQLUINTEGER

38

SQL_CONVERT_VARBINARY

Returns the following bit strings:

  • SQL_CVT_BINARY

  • SQL_CVT_CHAR

  • SQL_CVT_VARBINARY

  • SQL_CVT_VARCHAR

SQLUINTEGER

39

SQL_CONVERT_VARCHAR

Returns the following bit strings:

  • SQL_CVT_BIGINT

  • SQL_CVT_BINARY

  • SQL_CVT_CHAR

  • SQL_CVT_DATE

  • SQL_CVT_DECIMAL

  • SQL_CVT_DOUBLE

  • SQL_CVT_INTEGER

  • SQL_CVT_TIME

  • SQL_CVT_TIMESTAMP

  • SQL_CVT_VARBINARY

  • SQL_CVT_VARCHAR

SQLUINTEGER

40

SQL_CONVERT_FUNCTIONS

The scalar conversion functions that are supported by the driver and associated data source.

Returns the following bit strings:

  • SQL_FN_CVT_CAST

  • SQL_FN_CVT_CONVERT

SQLUINTEGER

41

SQL_CORRELATION_NAME

Whether table correlation names are supported.

Returns SQL_CN_ANY.

SQLUSMALLINT

42

SQL_CREATE_ASSERTION

The clauses in the CREATE ASSERTION statement that are supported by the data source.

A return value of 0 means that the CREATE ASSERTION statement is not supported.

Returns 0.

SQLUINTEGER

43

SQL_CREATE_CHARACTER_SET

The clauses in the CREATE CHARACTER SET statement that are supported by the data source.

A return value of 0 means that the CREATE CHARACTER SET statement is not supported.

Returns 0.

SQLUINTEGER

44

SQL_CREATE_COLLATION

The clauses in the CREATE COLLATION statement that are supported by the data source.

A return value of 0 means that the CREATE COLLATION statement is not supported.

Returns 0.

SQLUINTEGER

45

SQL_CREATE_DOMAIN

The clauses in the CREATE DOMAIN statement that are supported by the data source.

A return value of 0 means that the CREATE DOMAIN statement is not supported.

Returns 0.

SQLUINTEGER

46

SQL_CREATE_SCHEMA

The clauses in the CREATE SCHEMA statement that are supported by the data source.

A return value of 0 means that the CREATE SCHEMA statement is not supported.

Returns SQL_CS_CREATE_SCHEMA.

SQLUINTEGER

47

SQL_CREATE_TABLE

The clauses in the CREATE TABLE statement that are supported by the data source.

A return value of 0 means that the CREATE TABLE statement is not supported.

Returns the following bit strings:

  • SQL_CT_CREATE_TABLE

  • SQL_CT_TABLE_CONSTRAINT

  • SQL_CT_CONSTRAINT_NAME_DEFINITION

  • SQL_CT_COLUMN_DEFAULT

SQLUINTEGER

48

SQL_CREATE_TRANSLATION

The clauses in the CREATE TRANSLATION statement that are supported by the data source.

A return value of 0 means that the CREATE TRANSLATION statement is not supported.

Returns 0.

SQLUINTEGER

49

SQL_CREATE_VIEW

The clauses in the CREATE VIEW statement that are supported by the data source.

A return value of 0 means that the CREATE VIEW statement is not supported.

Returns SQL_CV_CREATE_VIEW.

SQLUINTEGER

50

SQL_CURSOR_COMMIT_BEHAVIOR

The effects of COMMIT processing on cursors and prepared statements in the data source.

Returns SQL_CB_CLOSE.

SQLUSMALLINT

51

SQL_CURSOR_ROLLBACK_BEHAVIOR

The effects of ROLLBACK processing on cursors and prepared statements in the data source.

Returns SQL_CB_CLOSE.

SQLUSMALLINT

52

SQL_CURSOR_SENSITIVITY

Support for cursor sensitivity.

Returns SQL_UNSPECIFIED.

SQLUINTEGER

53

SQL_DATA_SOURCE_NAME

The data source name character string that is used during connection.

Returns an empty string or the data source name that was used during connection.

  • SQLCHAR *

  • SQLWCHAR *

54

SQL_DATA_SOURCE_READ_ONLY

One of the following values:

Y

The data source's mode is READ ONLY.

N

The data source's mode is not READ ONLY.

Returns N.

  • SQLCHAR *

  • SQLWCHAR *

55

SQL_DATABASE_NAME

A character string with the name of the database in use, if the data source defines a named object called "database".

Returns a null character string.

  • SQLCHAR *

  • SQLWCHAR *

56

SQL_DATETIME_LITERALS

The SQL-92 datetime literals that are supported by the data source.

Returns the following bit strings:

  • SQL_DL_SQL92_DATE

  • SQL_DL_SQL92_TIME

  • SQL_DL_SQL92_TIMESTAMP

SQLUINTEGER

57

SQL_DBMS_NAME

A character string that indicates the name of the DBMS product accessed by the driver.

Returns "Hitachi Advanced Data Binder".

  • SQLCHAR *

  • SQLWCHAR *

58

SQL_DBMS_VER

A character string that indicates the version of the DBMS product accessed by the driver.

The version is displayed in the format ##.##.####.

Returns the DBMS product version.

  • SQLCHAR *

  • SQLWCHAR *

59

SQL_DDL_INDEX

Support for creation and dropping of indexes.

Returns the following bit strings:

  • SQL_DI_CREATE_INDEX

  • SQL_DI_DROP_INDEX

SQLUINTEGER

60

SQL_DEFAULT_TXN_ISOLATION

The default transaction isolation level supported by the driver or data source.

Returns SQL_TXN_READ_COMMITTED.

SQLUINTEGER

61

SQL_DESCRIBE_PARAMETER

One of the following values:

Y

Parameters can be described.

N

Parameters cannot be described.

Returns Y.

  • SQLCHAR *

  • SQLWCHAR *

62

SQL_DM_VER

A character string for the version of the driver manager. The version is represented in the format ##.##.####.####. This information type is implemented by the driver manager.

Returns the value that is set by the driver manager.

  • SQLCHAR *

  • SQLWCHAR *

63

SQL_DRIVER_HDBC

The driver's connection handle, which can be determined by InfoType. This information type is implemented by the driver manager.

Returns the value that is set by the driver manager.

SQLUINTEGER

64

SQL_DRIVER_HDESC

The driver's descriptor handle that is determined by the descriptor handle of the driver manager. This information must be set in *InfoValuePtr and passed by the application. This information type is implemented by the driver manager.

Returns the value that is set by the driver manager.

SQLUINTEGER

65

SQL_DRIVER_HENV

The driver's environment handle, which can be determined by InfoType. This information type is implemented by the driver manager.

Returns the value that is set by the driver manager.

SQLUINTEGER

66

SQL_DRIVER_HLIB

The hinst that is returned from the load library to the driver manager when the driver DLL or its equivalent is loaded. This information type is implemented by the driver manager.

Returns the value that is set by the driver manager.

SQLUINTEGER

67

SQL_DRIVER_HSTMT

The driver's statement handle that is determined by the driver manager's statement handle. This information must be set in *InfoValuePtr and passed by the application. This information type is implemented by the driver manager.

Returns the value that is set by the driver manager.

SQLUINTEGER

68

SQL_DRIVER_NAME

A character string that indicates the driver's file name used to access the data source.

Returns the driver's file name.

  • SQLCHAR *

  • SQLWCHAR *

69

SQL_DRIVER_ODBC_VER

A character string that indicates the ODBC version supported by the driver. The version is represented in the format ##.##.

Returns the ODBC version supported by the driver.

  • SQLCHAR *

  • SQLWCHAR *

70

SQL_DRIVER_VER

A character string that indicates the driver's version. Normally the driver returns this value. The minimum value for the version is represented in the format ##.##.####.

Returns the driver's version.

  • SQLCHAR *

  • SQLWCHAR *

71

SQL_DROP_ASSERTION

The clauses in the DROP ASSERTION statement (defined in SQL-92) that are supported by the data source.

Returns 0.

SQLUINTEGER

72

SQL_DROP_CHARACTER_SET

The clauses in the DROP CHARACTER SET statement (defined in SQL-92) that are supported by the data source.

Returns 0.

SQLUINTEGER

73

SQL_DROP_COLLATION

The clauses in the DROP COLLATION statement (defined in SQL-92) that are supported by the data source.

Returns 0.

SQLUINTEGER

74

SQL_DROP_DOMAIN

The clauses in the DROP DOMAIN statement (defined in SQL-92) that are supported by the data source.

Returns 0.

SQLUINTEGER

75

SQL_DROP_SCHEMA

The clauses in the DROP SCHEMA statement (defined in SQL-92) that are supported by the data source.

Returns the following bit strings:

  • SQL_DS_DROP_SCHEMA

  • SQL_DS_CASCADE

  • SQL_DS_RESTRICT

SQLUINTEGER

76

SQL_DROP_TABLE

The clauses in the DROP TABLE statement (defined in SQL-92) that are supported by the data source.

Returns the following bit strings:

  • SQL_DT_DROP_TABLE

  • SQL_DT_CASCADE

  • SQL_DT_RESTRICT

SQLUINTEGER

77

SQL_DROP_TRANSLATION

The clauses in the DROP TRANSLATION statement that are supported by the data source.

Returns 0.

SQLUINTEGER

78

SQL_DROP_VIEW

The clauses in the DROP VIEW statement that are supported by the data source.

Returns SQL_DV_DROP_VIEW.

SQLUINTEGER

79

SQL_DYNAMIC_CURSOR_ATTRIBUTES1

Attributes of a dynamic cursor that is supported by the driver. This bitmask contains the first subset of attributes.

Returns 0.

SQLUINTEGER

80

SQL_DYNAMIC_CURSOR_ATTRIBUTES2

Attributes of a dynamic cursor that is supported by the driver. This bitmask contains the second subset of attributes.

Returns 0.

SQLUINTEGER

81

SQL_EXPRESSIONS_IN_ORDERBY

One of the following values:

Y

The data source supports expressions in the ORDER BY list.

N

The data source does not support expressions in the ORDER BY list.

Returns Y.

  • SQLCHAR *

  • SQLWCHAR *

82

SQL_FILE_USAGE

How the single-tier driver directly handles files in a data source.

Returns SQL_FILE_NOT_SUPPORTED.

SQLUSMALLINT

83

SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1

Attributes of a forward-only cursor that is supported by the driver.

This bitmask contains the first subset of attributes.

Returns 0.

SQLUINTEGER

84

SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2

Attributes of a forward-only cursor that is supported by the driver. This bitmask contains the second subset of attributes.

Returns 0.

SQLUINTEGER

85

SQL_GETDATA_EXTENSIONS

Extensions to SQLGetData.

Returns the following values:

  • SQL_GD_ANY_COLUMN

  • SQL_GD_ANY_ORDER

SQLUINTEGER

86

SQL_GROUP_BY

The relationship between the columns in the GROUP BY clause and the columns in the selection list to which a set function has not been applied.

Returns SQL_GB_GROUP_BY_CONTAINS_SELECT.

SQLUSMALLINT

87

SQL_IDENTIFIER_CASE

Information about identifiers in SQL statements.

Returns SQL_IC_UPPER.

SQLUSMALLINT

88

SQL_IDENTIFIER_QUOTE_CHAR

The character string that is used as the starting and ending delimiter of a quoted identifier in SQL statements. If the data source does not support quoted identifiers, a blank is returned.

Returns a double quotation mark (").

  • SQLCHAR *

  • SQLWCHAR *

89

SQL_INDEX_KEYWORDS

Keywords in the CREATE INDEX statement that are supported by the driver.

Returns the following bit strings:

  • SQL_IK_ASC

  • SQL_IK_DESC

SQLUINTEGER

90

SQL_INFO_SCHEMA_VIEWS

The views in INFORMATION_SCHEMA that are supported by the driver.

Returns 0.

SQLUINTEGER

91

SQL_INSERT_STATEMENT

Support for INSERT statements.

Returns the following bit strings:

  • SQL_IS_INSERT_LITERALS

  • SQL_IS_INSERT_SEARCHED

SQLUINTEGER

92

SQL_INTEGRITY

One of the following values:

Y

The data source supports IEF.

N

The data source does not support IEF.

Returns N.

  • SQLCHAR *

  • SQLWCHAR *

93

SQL_KEYSET_CURSOR_ATTRIBUTES1

Attributes of a keyset cursor that is supported by the driver. This bitmask contains the first subset of attributes.

Returns 0.

SQLUINTEGER

94

SQL_KEYSET_CURSOR_ATTRIBUTES2

Attributes of a keyset cursor that is supported by the driver. This bitmask contains the second subset of attributes.

Returns 0.

SQLUINTEGER

95

SQL_KEYWORDS

A character string that contains a comma-separated list of all keywords specific to the data source. This list does not contain keywords specific to ODBC or keywords used by both the data source and ODBC. This list represents all the reserved keywords.

Returns HADB's reserved words without the ODBC-specific keywords.

  • SQLCHAR *

  • SQLWCHAR *

96

SQL_LIKE_ESCAPE_CLAUSE

One of the following values:

Y

The following conditions are both satisfied:

  • The data source supports an escape character for the percent sign (%) and underscore (_) in a LIKE predicate.

  • The driver supports the ODBC syntax for defining a LIKE predicate escape character.

N

Other.

Returns Y.

  • SQLCHAR *

  • SQLWCHAR *

97

SQL_MAX_ASYNC_CONCURRENT_STATEMENTS

Maximum number of active concurrent statements in asynchronous mode that the driver can support on a specified connection. If there is no specific limit or the limit is unknown, 0 is returned.

Returns 0.

SQLUINTEGER

98

SQL_MAX_BINARY_LITERAL_LEN

Maximum length of a binary literal in an SQL statement. If there is no maximum length or the length is unknown, 0 is returned.

Returns 64000.

SQLUINTEGER

99

SQL_MAX_CATALOG_NAME_LEN

Maximum length of a catalog name. If there is no maximum length or the length is unknown, 0 is returned.

Returns 0.

SQLUSMALLINT

100

SQL_MAX_CHAR_LITERAL_LEN

Maximum length of a character literal in an SQL statement. If there is no maximum length or the length is unknown, 0 is returned.

Returns 32000.

SQLUINTEGER

101

SQL_MAX_COLUMN_NAME_LEN

Maximum length of a column name in the data source. If there is no maximum length or the length is unknown, 0 is returned.

Returns 100.

SQLUSMALLINT

102

SQL_MAX_COLUMNS_IN_GROUP_BY

Maximum number of grouping columns permitted in a GROUP BY clause. If there is no specified limit or the limit is unknown, 0 is returned.

Returns 64.

SQLUSMALLINT

103

SQL_MAX_COLUMNS_IN_INDEX

Maximum number of columns permitted in an index. If there is no specified limit or the limit is unknown, 0 is returned.

Returns 16.

SQLUSMALLINT

104

SQL_MAX_COLUMNS_IN_ORDER_BY

Maximum number of columns permitted in an ORDER BY clause. If there is no specified limit or the limit is unknown, 0 is returned.

Returns 16.

SQLUSMALLINT

105

SQL_MAX_COLUMNS_IN_SELECT

Maximum number of columns permitted in a selection list. If there is no specified limit or the limit is unknown, 0 is returned.

Returns 1000.

SQLUSMALLINT

106

SQL_MAX_COLUMNS_IN_TABLE

Maximum number of columns permitted in a table. If there is no specified limit or the limit is unknown, 0 is returned.

Returns 1000.

SQLUSMALLINT

107

SQL_MAX_CONCURRENT_ACTIVITIES

Maximum number of active statements that the driver supports for a connection. If there is no specified limit or the limit is unknown, 0 is returned.

Returns 0.

SQLUSMALLINT

108

SQL_MAX_CURSOR_NAME_LEN

Maximum length of a cursor name in the data source. If there is no maximum length or the length is unknown, 0 is returned.

Returns 0.

SQLUSMALLINT

109

SQL_MAX_DRIVER_CONNECTIONS

Maximum number of active connections that the driver supports for an environment. If there is no specified limit or the limit is unknown, 0 is returned.

Returns 0.

SQLUSMALLINT

110

SQL_MAX_IDENTIFIER_LEN

Maximum length of a character string that the data source supports for user-defined names.

Returns 100.

SQLUSMALLINT

111

SQL_MAX_INDEX_SIZE

Maximum length (in bytes) permitted for the combined fields of an index. If there is no specified limit or the limit is unknown, 0 is returned.

Returns 4036.

SQLUINTEGER

112

SQL_MAX_PROCEDURE_NAME_LEN

Maximum length of a procedure name in the data source. If there is no maximum length or the length is unknown, 0 is returned.

Returns 0.

SQLUSMALLINT

113

SQL_MAX_ROW_SIZE

Maximum length of a row permitted in a table. If there is no specified limit or the limit is unknown, 0 is returned.

Returns 0.

SQLUINTEGER

114

SQL_MAX_ROW_SIZE_INCLUDES_LONG

One of the following values:

Y

The maximum row size returned for the SQL_MAX_ROW_SIZE information type includes the length of all columns of the SQL_LONGVARCHAR and SQL_LONGVARBINARY types.

N

Other

Returns N.

  • SQLCHAR *

  • SQLWCHAR *

115

SQL_MAX_SCHEMA_NAME_LEN

Maximum length of a schema name in the data source. If there is no maximum length or the length is unknown, 0 is returned.

Returns 100.

SQLUSMALLINT

116

SQL_MAX_STATEMENT_LEN

Maximum length (in characters) of an SQL statement. If there is no maximum length or the length is unknown, 0 is returned.

Returns 16000000.

SQLUINTEGER

117

SQL_MAX_TABLE_NAME_LEN

Maximum length of a data source table name. If there is no maximum length or the length is unknown, 0 is returned.

Returns 100.

SQLUSMALLINT

118

SQL_MAX_TABLES_IN_SELECT

Maximum number of tables permitted in the FROM clause of a SELECT statement. If there is no specified limit or the limit is unknown, 0 is returned.

Returns 64.

SQLUSMALLINT

119

SQL_MAX_USER_NAME_LEN

Maximum length of a user name in the data source. If there is no maximum length or the length is unknown, 0 is returned.

Returns 100.

SQLUSMALLINT

120

SQL_MULT_RESULT_SETS

One of the following values:

Y

The data source supports multiple result sets.

N

The data source does not support multiple result sets.

Returns N.

  • SQLCHAR *

  • SQLWCHAR *

121

SQL_MULTIPLE_ACTIVE_TXN

One of the following values:

Y

The driver supports concurrent execution of multiple active transactions.

N

The driver supports execution of only one active transaction at a time.

Returns Y.

  • SQLCHAR *

  • SQLWCHAR *

122

SQL_NEED_LONG_DATA_LEN

One of the following values:

Y

The data source needs the length of a long data value before that value is sent.

N

The data source does not need the length of a long data value before that value is sent.

Returns Y.

  • SQLCHAR *

  • SQLWCHAR *

123

SQL_NON_NULLABLE_COLUMNS

Whether NOT NULL columns in the data source are supported.

Returns SQL_NNC_NON_NULL.

SQLUSMALLINT

124

SQL_NULL_COLLATION

Where NULL is sorted in a result set.

Returns SQL_NC_HIGH.

SQLUSMALLINT

125

SQL_NUMERIC_FUNCTIONS

The numeric functions supported by the driver and data source.

Returns the following bit strings:

  • SQL_FN_NUM_ABS

  • SQL_FN_NUM_ACOS

  • SQL_FN_NUM_ASIN

  • SQL_FN_NUM_ATAN

  • SQL_FN_NUM_ATAN2

  • SQL_FN_NUM_CEILING

  • SQL_FN_NUM_COS

  • SQL_FN_NUM_DEGREES

  • SQL_FN_NUM_EXP

  • SQL_FN_NUM_FLOOR

  • SQL_FN_NUM_LOG

  • SQL_FN_NUM_MOD

  • SQL_FN_NUM_PI

  • SQL_FN_NUM_POWER

  • SQL_FN_NUM_RADIANS

  • SQL_FN_NUM_RAND

  • SQL_FN_NUM_ROUND

  • SQL_FN_NUM_SIGN

  • SQL_FN_NUM_SIN

  • SQL_FN_NUM_SQRT

  • SQL_FN_NUM_TAN

  • SQL_FN_NUM_TRUNCATE

SQLUINTEGER

126

SQL_ODBC_INTERFACE_CONFORMANCE

Level of the ODBC 3.x interface that the driver complies with.

Returns SQL_OIC_CORE.

SQLUINTEGER

127

SQL_ODBC_VER

A character string containing the version of ODBC with which the driver manager conforms. The version is represented in the format ##.##.0000. This information type is implemented by the driver manager.

Returns the value that is set by the driver manager.

  • SQLCHAR *

  • SQLWCHAR *

128

SQL_OJ_CAPABILITIES

The types of outer joins supported by the driver and data source.

Returns the following bit strings:

  • SQL_OJ_ALL_COMPARISON_OPS

  • SQL_OJ_FULL

  • SQL_OJ_INNER

  • SQL_OJ_LEFT

  • SQL_OJ_NESTED

  • SQL_OJ_RIGHT

SQLUINTEGER

129

SQL_ORDER_BY_COLUMNS_IN_SELECT

One of the following values:

Y

The columns in the ORDER BY clause are in the selection list.

N

The columns in the ORDER BY clause are not in the selection list.

Returns N.

  • SQLCHAR *

  • SQLWCHAR *

130

SQL_PARAM_ARRAY_ROW_COUNTS

The driver's properties regarding the availability of row counts in a parameterized execution.

Returns 0.

SQLUINTEGER

131

SQL_PARAM_ARRAY_SELECTS

The driver's properties regarding the availability of result sets in a parameterized execution.

Returns SQL_PAS_NO_SELECT.

SQLUINTEGER

132

SQL_PROCEDURE_TERM

A character string containing the data source vendor's name for a procedure.

Returns a null character string.

  • SQLCHAR *

  • SQLWCHAR *

133

SQL_PROCEDURES

One of the following values:

Y

The following conditions are both satisfied:

The data source supports procedures.

The driver supports the ODBC procedure invocation syntax.

N

Other.

Returns N.

  • SQLCHAR *

  • SQLWCHAR *

134

SQL_QUOTED_IDENTIFIER_CASE

Information about quoted identifiers in SQL statements.

Returns SQL_IC_SENSITIVE.

SQLUSMALLINT

135

SQL_ROW_UPDATES

One of the following values:

Y

A keyset or mixed cursor retains row versions or values for all fetched rows and can detect any updates made to a row by any application program since the row was last fetched.

N

Other.

Returns N.

  • SQLCHAR *

  • SQLWCHAR *

136

SQL_SCHEMA_TERM

A character string containing the data source vendor's name for a schema.

Returns "schema".

  • SQLCHAR *

  • SQLWCHAR *

137

SQL_SCHEMA_USAGE

The statements in which schemas can be used.

Returns the following bit strings:

  • SQL_SU_DML_STATEMENTS

  • SQL_SU_INDEX_DEFINITION

  • SQL_SU_TABLE_DEFINITION

  • SQL_SU_PRIVILEGE_DEFINITION

SQLUINTEGER

138

SQL_SCROLL_OPTIONS

Scroll options supported for scrollable cursors.

Returns SQL_SO_FORWARD_ONLY.

SQLUINTEGER

139

SQL_SEARCH_PATTERN_ESCAPE

A character string indicating that the driver supports an escape character that uses the pattern search metacharacters underscore (_) and percent sign (%) as valid characters in search patterns.

This indicates an escape character that handles metacharacters underscore (_) and percent sign (%) for pattern search as valid search characters.

This escape character applies only to the arguments of catalog functions that support search character strings. If a null character string is specified, the driver cannot handle underscore (_) and percent sign (%) as a part of search pattern character strings.

Returns "\".

  • SQLCHAR *

  • SQLWCHAR *

140

SQL_SERVER_NAME

A character string containing the actual data source-specific server name.

Returns "Hitachi Advanced Data Binder".

  • SQLCHAR *

  • SQLWCHAR *

141

SQL_SPECIAL_CHARACTERS

A character string that contains all special characters that can be used in an identifier name (such as a table name, column name, or index name) in the data source.

Returns a null character string.

  • SQLCHAR *

  • SQLWCHAR *

142

SQL_SQL_CONFORMANCE

The level of SQL-92 supported by the driver.

Returns SQL_SC_SQL92_ENTRY.

SQLUINTEGER

143

SQL_SQL92_DATETIME_FUNCTIONS

The datetime scalar functions that are supported by the driver and the associated data source.

Returns the following bit strings:

  • SQL_SDF_CURRENT_DATE

  • SQL_SDF_CURRENT_TIME

  • SQL_SDF_CURRENT_TIMESTAMP

SQLUINTEGER

144

SQL_SQL92_FOREIGN_KEY_DELETE_RULE

The rules supported for a foreign key in a DELETE statement.

Returns 0.

SQLUINTEGER

145

SQL_SQL92_FOREIGN_KEY_UPDATE_RULE

The rules supported for a foreign key in an UPDATE statement.

Returns 0.

SQLUINTEGER

146

SQL_SQL92_GRANT

The clauses supported in a GRANT statement.

Returns the following bit strings:

  • SQL_SG_DELETE_TABLE

  • SQL_SG_INSERT_TABLE

  • SQL_SG_REFERENCES_TABLE

  • SQL_SG_SELECT_TABLE

  • SQL_SG_UPDATE_TABLE

SQLUINTEGER

147

SQL_SQL92_NUMERIC_VALUE_FUNCTIONS

The numeric scalar functions supported by the driver and associated data source.

Returns the following bit string:

  • SQL_SNVF_EXTRACT

SQLUINTEGER

148

SQL_SQL92_PREDICATES

The predicates supported in a SELECT statement.

Returns the following bit strings:

  • SQL_SP_BETWEEN

  • SQL_SP_COMPARISON

  • SQL_SP_EXISTS

  • SQL_SP_IN

  • SQL_SP_ISNOTNULL

  • SQL_SP_ISNULL

  • SQL_SP_LIKE

  • SQL_SP_QUANTIFIED_COMPARISON

SQLUINTEGER

149

SQL_SQL92_RELATIONAL_JOIN_OPERATORS

The relational join operators supported in a SELECT statement.

Returns the following bit strings:

  • SQL_SRJO_CROSS_JOIN

  • SQL_SRJO_FULL_OUTER_JOIN

  • SQL_SRJO_INNER_JOIN

  • SQL_SRJO_LEFT_OUTER_JOIN

  • SQL_SRJO_RIGHT_OUTER_JOIN

SQLUINTEGER

150

SQL_SQL92_REVOKE

The clauses supported in a REVOKE statement that is supported by the data source.

Returns the following bit strings:

  • SQL_SR_CASCADE

  • SQL_SR_DELETE_TABLE

  • SQL_SR_INSERT_TABLE

  • SQL_SR_REFERENCES_TABLE

  • SQL_SR_RESTRICT

  • SQL_SR_SELECT_TABLE

  • SQL_SR_UPDATE_TABLE

SQLUINTEGER

151

SQL_SQL92_ROW_VALUE_CONSTRUCTOR

The row value constructor expressions supported in a SELECT statement.

Returns 0.

SQLUINTEGER

152

SQL_SQL92_STRING_FUNCTIONS

The string scalar functions supported by the driver and associated data source.

Returns the following bit strings:

  • SQL_SSF_CONVERT

  • SQL_SSF_LOWER

  • SQL_SSF_SUBSTRING

  • SQL_SSF_TRIM_BOTH

  • SQL_SSF_TRIM_LEADING

  • SQL_SSF_TRIM_TRAILING

  • SQL_SSF_UPPER

SQLUINTEGER

153

SQL_SQL92_VALUE_EXPRESSIONS

Supported value expressions.

Returns the following bit strings:

  • SQL_SVE_CASE

  • SQL_SVE_CAST

  • SQL_SVE_COALESCE

  • SQL_SVE_NULLIF

SQLUINTEGER

154

SQL_STANDARD_CLI_CONFORMANCE

The CLI standard with which the driver conforms.

Returns SQL_SCC_ISO92_CLI.

SQLUINTEGER

155

SQL_STATIC_CURSOR_ATTRIBUTES1

Attributes of a static cursor that is supported by the driver. This bitmask contains the first subset of attributes.

Returns 0.

SQLUINTEGER

156

SQL_STATIC_CURSOR_ATTRIBUTES2

Attributes of a static cursor that is supported by the driver. This bitmask contains the second subset of attributes.

Returns 0.

SQLUINTEGER

157

SQL_STRING_FUNCTIONS

The string scalar functions supported by the data source.

Returns the following bit strings:

  • SQL_FN_STR_ASCII

  • SQL_FN_STR_CONCAT

  • SQL_FN_STR_LCASE

  • SQL_FN_STR_LEFT

  • SQL_FN_STR_LENGTH

  • SQL_FN_STR_LTRIM

  • SQL_FN_STR_REPLACE

  • SQL_FN_STR_RIGHT

  • SQL_FN_STR_RTRIM

  • SQL_FN_STR_SUBSTRING

  • SQL_FN_STR_UCASE

SQLUINTEGER

158

SQL_SUBQUERIES

The predicates that support subqueries.

Returns the following bit strings:

  • SQL_SQ_COMPARISON

  • SQL_SQ_CORRELATED_SUBQUERIES

  • SQL_SQ_EXISTS

  • SQL_SQ_IN

  • SQL_SQ_QUANTIFIED

SQLUINTEGER

159

SQL_SYSTEM_FUNCTIONS

The system scalar functions supported by the driver and associated data source.

Returns 0.

SQLUINTEGER

160

SQL_TABLE_TERM

A character string containing the data source vendor's name for a table.

Returns "table".

  • SQLCHAR *

  • SQLWCHAR *

161

SQL_TIMEDATE_ADD_INTERVALS

The time stamp interval supported by the driver and associated data source for the TIMESTAMPADD scalar function.

Returns 0.

SQLUINTEGER

162

SQL_TIMEDATE_DIFF_INTERVALS

The time stamp interval supported by the driver and associated data source for the TIMESTAMPDIFF scalar function.

Returns 0.

SQLUINTEGER

163

SQL_TIMEDATE_FUNCTIONS

The date and time scalar functions supported by the driver and associated data source.

Returns the following bit strings:

  • SQL_FN_TD_CURRENT_DATE

  • SQL_FN_TD_CURRENT_TIME

  • SQL_FN_TD_CURRENT_TIMESTAMP

  • SQL_FN_TD_DAYOFWEEK

  • SQL_FN_TD_DAYOFYEAR

  • SQL_FN_TD_EXTRACT

SQLUINTEGER

164

SQL_TXN_CAPABLE

The transactions supported by the driver or data source.

Returns SQL_TC_DDL_COMMIT.

SQLUSMALLINT

165

SQL_TXN_ISOLATION_OPTION

The transaction isolation levels available from the driver or data source.

Returns the following bit strings:

  • SQL_TXN_READ_COMMITTED

  • SQL_TXN_REPEATABLE_READ

SQLUINTEGER

166

SQL_UNION

Support for the UNION clause.

Returns the following bit strings:

  • SQL_U_UNION

  • SQL_U_UNION_ALL

SQLUINTEGER

167

SQL_USER_NAME

A character string containing the name that is used in a specific database.

This might be different from the login name.

Returns the user name that was used for connection.

  • SQLCHAR *

  • SQLWCHAR *

168

SQL_XOPEN_CLI_YEAR

A character string that indicates the year of publication of the X/Open specification with which the version of the ODBC driver manager fully compiles.

Returns the value that is set by the driver manager.

  • SQLCHAR *

  • SQLWCHAR *

169

SQL_ODBC_API_CONFORMANCE

Value of SQLSMALLINT that indicates the ODBC conformance level.

Returns SQL_OAC_LEVEL1.

SQLUSMALLINT

170

SQL_FETCH_DIRECTION

The supported fetch direction options.

Returns SQL_FD_FETCH_NEXT.

SQLUINTEGER

171

SQL_LOCK_TYPES

The lock types that can be specified in the fLock argument of SQLSetPos.

Returns 0.

SQLUINTEGER

172

SQL_ODBC_SAG_CLI_CONFORMANCE

The compliance level to functions of the SAG specification.

Returns SQL_OSCC_COMPLIANT.

SQLUSMALLINT

173

SQL_ODBC_SQL_CONFORMANCE

The SQL grammar supported by the driver.

Returns SQL_OSC_CORE.

SQLUSMALLINT

174

SQL_OUTER_JOINS

Support status for outer joins of data sources.

Returns F.

  • SQLCHAR *

  • SQLWCHAR *

175

SQL_POS_OPERATIONS

The operations supported by SQLSetPos.

Returns 0.

SQLUINTEGER

176

SQL_POSITIONED_STATEMENTS

The positioned SQL statements supported by the data source.

Returns 0.

SQLUINTEGER

177

SQL_SCROLL_CONCURRENCY

The concurrency control options supported for scrollable cursors.

Returns SQL_SCCO_READ_ONLY.

SQLUINTEGER

178

SQL_STATIC_SENSITIVITY

Whether an application can detect changes made to a static or keyset-driven cursor through the following:

  • SQLSetPos function

  • Positioned update or delete statements

Returns 0.

SQLUINTEGER