How do you represent a hierarchy in unrelated records?

[kiddpete]

I have a FIX file which consists of several record types. The 'parent' information consists of several fields that the records have in common. Other than this parent info, the records are unrelated and have different formats. They can be distinguished by a RECTYPE field.

Can this file structure be represented in FOCUS? I would like to extract data from two or more record types, and sort the results based on the common parent information without using an intermediate file such as HOLD.

 

[jimster06]

See p 5-26 in Describing Data with WebFOCUS Language (5.2) for a discussion of RECTYPE.

HTH

 

[kiddpete]

Jimster,

Thanks for the suggestion, but I'm quite familiar with RECTYPE. That's why I mentioned it in my question. Perhaps you see how RECTYPE solves this problem, but right now I don't. RECTYPE allows you to describe either hierarchical or parallel segments in a file structure, and, in my example, allows a description of parallel segments. I'm trying to figure out if there is a way to recognize a set of common 'parent' fields which exist within the parallel segments.

 

[focwizard]

Then what you want is MAPFIELD/MAPVALUE. It's in the same manual, starting on page 5-44.