C++ SDK data types
The OpenText™ Analytics Database SDK has typedefs and classes for representing the database data types within your UDx code. Using these typedefs ensures data type compatibility between the data your UDx processes and generates and the database. The following table describes some of the typedefs available. Consult the C++ SDK Documentation for a complete list, as well as lists of helper functions to convert and manipulate these data types.
For information about SDK support for complex data types, see Complex Types as Arguments and Return Values.
| Type Definition | Description |
|---|---|
| Interval | An OpenText™ Analytics Database interval |
| IntervalYM | An OpenText™ Analytics Database year-to-month interval. |
| Timestamp | An OpenText™ Analytics Database timestamp |
| vint | A standard OpenText™ Analytics Database 64-bit integer |
| vbool | A Boolean value in OpenText™ Analytics Database |
| vbool_null | A null value for a Boolean data types |
| vfloat | An OpenText™ Analytics Database floating point value |
| VString |
String data types (such as varchar and char) Note: Do not use a VString object to hold an intermediate result. Use a std::string or char[] instead. |
| VNumeric | Fixed-point data types from OpenText™ Analytics Database |
| VUuid | An OpenText™ Analytics Database universally unique identifier |
Notes
-
When making some SDK API calls (such as
VerticaType::getNumericLength()) on objects, make sure they have the correct data type. To minimize overhead and improve performance, most of the APIs do not check the data types of the objects on which they are called. Calling a function on an incorrect data type can result in an error. -
You cannot create instances of VString or VNumeric yourself. You can manipulate the values of existing objects of these classes that the database passes to your UDx, and extract values from them. However, only the database can instantiate these classes.