This parameter specifies how many result rows are sent (pre-fetched) to the client driver in response to the SQLExecute call with a SELECT statement. The result rows are subsequently returned to the application with the first SQLFetch calls issued by the application. The value 2 allows for prefetching of single-row results. If your SELECT statements usually return larger number of rows, setting this to an appropriate value can improve performance significantly.

See also the RowsPerMessage parameter.

decided by the server

If set to yes, the Windows runtime error dialog is not shown. This parameter is relevant to the Windows platform only.

no

Defines the binding method for character data.

The options are:

The convention for <locale name> depends on the operating system. For example, in Linux environments, the locale name for the code page GB18030 in Chinese/China is zh_CN.gb18030. In Windows environments, the locale name for Latin1 code page in Finnish/Finland is fin_fin.1252.

The value raw can be used when you want your database to use the binding used in the 6.3 or earlier versions of solidDB^®.

locale

This parameter switches ODBC handle validation on or off.

See also section ODBC handle validation in solidDB^® Programmer Guide for more information about the SQL_ATTR_HANDLE_VALIDATION ODBC attribute.

no

Specifies the number of rows returned from the server in one network message when an SQLFetch call is executed (and there are no pre-fetched rows).

See also the ExecRowsPerMessage parameter.

decided by the server

Statement cache is an internal memory storing a few previously prepared SQL statements. With this parameter, you can set the number of cached statements per session.

6

This parameter defines whether passwords are encrypted using DES encryption. If set to no, passwords are not encrypted.

yes