Query from VDATA

When querying data from VDATA, the JDBC driver converts data from the UNICOM Intelligence OLE DB provider to the JAVA result set using the following rules:

Also called a Loop. These represent loops, grids, and levels. The Array object defines a question or set of questions that are to be asked more than once.

For more information, see Query array field in VDATA or Query array field in HDATA.

JAVA result set: Multiple columns.

A Boolean value of either True or False. This is implemented internally using VARIANT_BOOL. However, when a Boolean is converted to a Long or a Double, it will be converted to 1 for True and 0 for False.

JAVA result set: A single column: Boolean

A single or multiple categorical response type. The maximum number of responses available varies between DSCs. A categorical response is implemented in the Provider as a string. The responses are formatted in { } (braces), with each response delimited by a comma. For example, {2,3,8} represents the responses 2, 3, and 8. Depending on how the data was collected, the order of responses in the string can be the order in which they were chosen in response to the question. This can be important for analysis.

JAVA result set: Column.Type is Categorical 129. The type is returned as a getTypeInfo method of DatabaseMetadata. The return value is determined by the connection properties.

See Return category value for more information.

These represent a grid question. A Grid object can be considered a special case of the Array object.

JAVA result set: Multiple columns.

See Query class field in VDATA for more information.

These group categorical and grid questions that share a category list, typically for presentation in a paper questionnaire.

JAVA result set: Multiple columns.

See Query compound field in VDATA for more information.

A 64-bit OLE date. The OLE date type contains both date and time and it is represented using the DATE type.

JAVA result set: A single column: DATE

A 64-bit floating-point number with at least 15 digits of precision.

JAVA result set: A single column: Double

These are used to group questions.

JAVA result set: Multiple columns.

See Query grid field in VDATA or Query grid field in HDATA for more information.

A hierarchical value. A level contains a child record set.

JAVA result set: N/A for VDATA; a single BINARY column for HDATA

A 32-bit signed integer.

JAVA result set: A single column: Integer

JAVA result set: N/A

A character string. The maximum length of a text variable depends on the DSC. The string might or might not support Unicode, depending on how the CDSC has implemented its storage. The Provider implements all strings using Unicode.