DICT entries for multivalued fields

[admin]

Okay, its been years, and Ive forgotten.

What is a dictionary entry supposed to look like to reference a specific multivalue in a file? For example, if field number 5 is multivalued and I want a dictionary item to use for listing the 3rd multivalue in that field, what would it look like?

Also, which Universe documentation manual contains all the possible correlative options I can use and what they mean?

Thanks.

Brad Vincent
Data Warehousing with a "health"-y spin
Compuware
c/o The Detroit Medical Center
(313) 966-2176

[admin]

I believe you can create the following:

001: I
002: @RECORD
003:
004:
005: 10L
006: S

Field 3 is empty but could contain a conversion code, and field 4 is empty
but could contain a field output heading.

Im not certain there is a manual that "contains all the possible
correlative options". With I-types you can use most BASIC code (as shown
above), which are much easier than the "Pick-style" correlatives.

hope this helps
Glenn

At 09:38 AM 5/9/01, you wrote:
>Okay, its been years, and Ive forgotten.
>
>What is a dictionary entry supposed to look like to reference a
>specific multivalue in a file? For example, if field number 5 is
>multivalued and I want a dictionary item to use for listing the 3rd
>multivalue in that field,
>what would it look like?
>
>Also, which Universe documentation manual contains all the possible
>correlative options I can use and what they mean?
>
>Thanks.
>
>Brad Vincent
>Data Warehousing with a "health"-y spin
>Compuware
>c/o The Detroit Medical Center
>(313) 966-2176

[admin]

That worked great, Glenn. Thanks!

Brad

> -----Original Message-----
> From: Glenn Herbert [SMTP:glenn.herbert@ascentialsoftware.com]
> Sent: Wednesday, May 09, 2001 9:48 AM
> To: informix-datastage@oliver.com
> Subject: Re: DICT entries for multivalued fields
>
> I believe you can create the following:
>
> 001: I
> 002: @RECORD
> 003:
> 004:
> 005: 10L
> 006: S
>
> Field 3 is empty but could contain a conversion code, and field 4 is
> empty
>
> but could contain a field output heading.
>
> Im not certain there is a manual that "contains all the possible
> correlative options". With I-types you can use most BASIC code (as shown
> above), which are much easier than the "Pick-style" correlatives.
>
> hope this helps
> Glenn
>
> At 09:38 AM 5/9/01, you wrote:
> >Okay, its been years, and Ive forgotten.
> >
> >What is a dictionary entry supposed to look like to reference a
> >specific multivalue in a file? For example, if field number 5 is
> >multivalued and I want a dictionary item to use for listing the 3rd
> >multivalue in that field,
> >what would it look like?
> >
> >Also, which Universe documentation manual contains all the possible
> >correlative options I can use and what they mean?
> >
> >Thanks.
> >
> >Brad Vincent
> >Data Warehousing with a "health"-y spin
> >Compuware
> >c/o The Detroit Medical Center
> >(313) 966-2176