[hew212]

Can unidata sql statement use for select a multivalue data?

Please help.

[mdm]

Originally posted by hew212
Can unidata sql statement use for select a multivalue data?

Please help.

You need to include an UNNEST statement using the association name for the set of multi values included in your sql statement. This assumes that the dictionary has been correctly set up with the association.

e.g. UNNEST LINE_PH

Dictionary would include the following record for LINE_PH:

1: PH
2: LINE_NO AMOUNT_EX_VAT VAT

and records for LINE_NO, AMOUNT_EX_VAT and VAT:

1: D
.
.
6: MV
7: LINE_PH