Hitachi

Hitachi Advanced Database Application Development Guide


16.15 Attributes that can be specified in SQLSetEnvAttr and SQLGetEnvAttr

The following table lists and describes the attributes that can be specified in SQLSetEnvAttr and SQLGetEnvAttr.

Table 16‒20: Attributes that can be specified in SQLSetEnvAttr and SQLGetEnvAttr

No.

Attribute

Description (convention)

Support status

Data type

1

SQL_ATTR_CONNECTION_POOLING

Connection pool settings at an environment level.

This attribute is not supported.

--

2

SQL_ATTR_CP_MATCH

How to select a connection from a connection pool.

This attribute is not supported.

--

3

SQL_ATTR_ODBC_VERSION

The ODBC version that the driver complies with.

SQL_OV_ODBC3

The driver manager and driver have ODBC 3.0 behaviors as follows:

  • The driver returns ODBC 3.0 codes for date, time, and time stamp and assumes ODBC 3.0 codes.

  • When SQLGetDiagField or SQLGetDiagRec is called, the driver returns ODBC 3.0 SQLSTATE code.

SQL_OV_ODBC2

The driver manager and driver have ODBC 2.x behaviors as follows:

  • The driver returns ODBC 2.x codes for dates, times, and time stamps, and assumes ODBC 2.x codes.

  • When SQLGetDiagField or SQLGetDiagRec is called, the driver returns ODBC 2.x SQLSTATE codes.

An application must set this environment attribute before calling a function that specifies an argument of type SQLHENV.

Supports the following value:

  • SQL_OV_ODBC3

  • SQL_OV_ODBC2

SQLUINTEGER

4

SQL_ATTR_OUTPUT_NTS

How the driver returns character string data.

SQL_TRUE

The driver returns null terminating character string data.

Supports the following value:

  • SQL_TRUE

SQLUINTEGER

Legend:

--: Not applicable.