Complex Flat File

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
199542
Participant
Posts: 41
Joined: Sat Dec 29, 2007 2:42 am

Complex Flat File

Post by 199542 »

Hi ,
I am using complex Flat file for reading multiple records types within a same file .

The file is as follows

GHIJKLABCD20070918ZX
MNOPQREFGHI20070917JAHALHALJJKAHKHAKHA
------------------------------

Inabove file , the fields are as follows
1 2 3 4
GHIJKL ABCD 20070918 ZX ----- ( FIRST LINE WITH 4 FIELDS NO

SEPARATOR )
1 2 3 4 5 6
MNOPQR EFGH 20070917 JAHAL HALJJKAH KHAKHA ---- ( 2ND LINE WITH 6 fields with no separator )

Like that there are many records with different metadata.For reading this file I am using CFF parallel job .
I gave recordid constraint as GHIJKL for first record and
MNOPQ for second record.
I gave metadata for each record properly.I am directing each record to a sequential file .But in the o/p I am able to view data for only 1st recordid.Can anyone suggest the exact procedure ?

Can I direct all the records in the file with same recordid ( like MNOPQR ) to one sequential file using CFF ?
Last edited by 199542 on Thu Feb 14, 2008 2:17 am, edited 1 time in total.
gikjpjj
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Why do you believe asking the same question in a different thread will get a different answer?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply