fixed width flat files

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
kamesh
Participant
Posts: 72
Joined: Tue May 27, 2003 1:47 am

fixed width flat files

Post by kamesh »

my source file is a fixed width file. it will contain both numeric and character data. i am trying to view the data but all column data comming in first column..can i use seqential stage in parallel job.
please let me know if anyone know ans..
dsedi
Participant
Posts: 220
Joined: Wed Jun 02, 2004 12:38 am

Re: fixed width flat files

Post by dsedi »

opps..I missed that!!

Define the meta data using the Schema file property and Define the Field name and Length on the output LInk...

Edi
Last edited by dsedi on Tue Nov 06, 2007 2:02 pm, edited 1 time in total.
kamesh
Participant
Posts: 72
Joined: Tue May 27, 2003 1:47 am

Post by kamesh »

It is fixed length columns
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Then mark is thus in the properties!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
reddy.vinod
Participant
Posts: 36
Joined: Mon Jul 16, 2007 3:37 am
Location: USA

Re: fixed width flat files

Post by reddy.vinod »

Hi kamesh,
I have one suggestion.First in sequential file stage go to "format " tab ,there on final delimeter give one right click now one window will open there select "unix file termination".
I am not confirm on it.............
VINOD
sravanthi
Participant
Posts: 83
Joined: Fri Jun 02, 2006 5:37 am

Re: fixed width flat files

Post by sravanthi »

Verify your metadata.It may be the problem.Also in the format tab add delimiter,final delimiter as none.
sravanthi
Post Reply