JDBC Driver > UNICOM Intelligence JDBC Driver specification > Query from HDATA > Query array field in HDATA
 
Query array field in HDATA
In HDATA, array fields are considered level. Querying a level field is same as querying all sub-fields of the level field. See Return level field for more information.
You can query array object sub-fields from the array table. Refer to the example below for more information.
Array objects contain the specialty field LevelID, which is a sequential number in the current level.
Example
Using data from the UNICOM Intelligence Developer Library household.mdd example:
SELECT
^.housetype
, ^.address
, levelid
, age
, person
FROM HDATA.person
The result data is:
^.housetype
^.address
levelid
age
person
{59}
15B Park Avenue, Harrogate, HG1 4TY
1
25
1
{61}
46 Freedom Lane, Brighton, BN2 3YT
1
45
2
{61}
46 Freedom Lane, Brighton, BN2 3YT
2
43
3
{61}
46 Freedom Lane, Brighton, BN2 3YT
3
15
4
{61}
46 Freedom Lane, Brighton, BN2 3YT
4
12
5
{60}
The Meadows, Clifton Heights, BS34 3EG
1
72
6
{60}
The Meadows, Clifton Heights, BS34 3EG
2
81
7
{62}
23 Steep Hill, Norfold, CB64 5TY
1
32
8
{62}
23 Steep Hill, Norfold, CB64 5TY
2
9
9
{62}
23 Steep Hill, Norfold, CB64 5TY
3
2
10
{61}
 
1
29
11
{61}
 
2
31
12
...
...
...
...
...
See also
Query from HDATA