how to read a sequential file with out delimiters.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vikramkola
Premium Member
Premium Member
Posts: 15
Joined: Sun Feb 22, 2009 3:31 pm

how to read a sequential file with out delimiters.

Post by vikramkola »

how to read a sequential file with out delimiters.

:(
vikram
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That's not a problem. Do you mean field delimiters or record delimiters?

If the sequential file has no record delimiter it contains at most one line, so that's not a problem.

If the data structure lacks field delimiters then either there is only one field or the fields are identified by their length - that is, you have a fixed-width format file, and should use appropriate Format metadata.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vikramkola
Premium Member
Premium Member
Posts: 15
Joined: Sun Feb 22, 2009 3:31 pm

Post by vikramkola »

RAY, there are just rows and coloums with out comma, or any other delimiters ,even they are not fixed-width format.
vikram
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If there are no delimiters, how do you know there are rows and columns?

Do you have any description of the file's alleged format?

Are there separate lines in the file? If so could you post just a few of them?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Read it all as one column. Do pattern matching maybe to parse the columns. You probably need to use field() a lot to figure out where and how to parse.
Mamu Kim
Post Reply