JDBC Driver > UNICOM Intelligence JDBC Driver specification > Query from HDATA
 
Query from HDATA
When you query data from HDATA, the UNICOM Intelligence JDBC Driver converts data from the UNICOM Intelligence OLE DB Provider to the JAVA result set using the following rules:
Array
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.
JAVA result set: Multiple columns.
See Query array field in VDATA or Query array field in HDATA for more information.
Boolean
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
Categorical
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 within curly 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.
Class
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.
Compound
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.
Date
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
Double
A 64-bit floating-point number with at least 15 digits of precision.
JAVA result set: A single column: Double
Grid
These are used to group questions.
JAVA result set: Multiple columns.
See Query grid field in VDATA for more information.
Level
A hierarchical value. A level contains a child recordset.
JAVA result set: N/A for VDATA; a single BINARY column for HDATA
Long
A 32-bit signed integer.
JAVA result set: A single column: Integer
Object
Not implemented.
JAVA result set: N/A
Text
A character string. The maximum length of a text variable is dependent on the DSC. The string may or may not support Unicode, depending on how the CDSC has implemented its storage. The Provider implements all strings using Unicode.
JAVA result set: A single column: String
See also
Query array field in HDATA
SQL syntax
Database metadata
UNICOM Intelligence data types
Query from VDATA
Query grid field in HDATA
Return category value
Return level field
UNICOM Intelligence JDBC Driver specification