ODBC Header File Specific to Vertica

The Vertica ODBC driver provides a C header file named verticaodbc.h that defines several useful constants that you can use in your applications. These constants let you access and alter settings specific to Vertica.

This file's location depends on your client operating system:

  • /opt/vertica/include on Linux and UNIX systems.
  • C:\Program Files (x86)\Vertica\ODBC\include on Windows systems.

The constants defined in this file are listed below.

Parameter Description Associated Function 
SQL_ATTR_VERTICA_RESULT_BUFFER_SIZE

Sets the size of the buffer used when retrieving results from the server. 

SQLSetConnectAttr() SQLGetConnectAttr()

SQL_ATTR_VERTICA_DIRECT_BATCH_INSERT

Determines whether a batch is inserted directly into the ROS (1) or using ClosedAUTO mode (0). By default batches are inserted using AUTO.

When you load data using AUTO mode, Vertica inserts the data first into the WOS. If the WOS is full, Vertica inserts the data directly into ROS. For details about load options, see Choosing a Load Method. 

SQLSetConnectAttr() SQLSetStmtAttr()
SQLGetConnectAttr()
SQLGetStmtAttr()

SQL_ATTR_VERTICA_LOCALE

Changes the locale from en_US@collation=binary to the ICU locale specified. See Setting the Locale for ODBC Sessions for an example of using this parameter.

 
SQLSetConnectAttr() SQLGetConnectAttr()