JDBC Driver > UNICOM Intelligence JDBC Driver specification > Query from VDATA > Query compound field in VDATA
 
Query compound field in VDATA
A compound field is a class that includes multiple grid fields. All grids share a same set of categorical elements that are stored in the compound field. You cannot query a compound field such as SELECT plans FROM VDATA. Compound fields are not columns in VDATA.
You can use compoundName.gridName[{elementName}].gridSubFieldName to obtain a sub field’s value.
Summary
VDATA is a flat view; all columns can be obtained via the getColumns method. The negative aspects of using VDATA are:
Bound array fields and grid fields are presented in expanded mode.
You cannot query unbound array data.
See also
Query from VDATA
Query array field in VDATA
Query class field in VDATA
Query grid field in VDATA