Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    26

    Question Unanswered: Unidata Sql In Multivalue Data

    Can unidata sql statement use for select a multivalue data?

    Please help.
    Last edited by hew212; 12-10-03 at 00:23.

  2. #2
    Join Date
    Jan 2004
    Posts
    2

    Re: Unidata Sql In Multivalue Data

    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
    Last edited by mdm; 01-21-04 at 14:18.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •