DSXchange

Can we output to a flat file of the following format...If yes how do we do it...

1000 |James |510
2000 |Gary |360
3000 |Terry |760
20 |park Beach |California| USA|8887009
30 |South End |Florida | USA|9008675
4000 |Barry |890
:
:
:
:
(: colan stands for following the structure)
id | name | code
loc id| address| state | country | zip

what is ur job design ? u can go to format tab in out put file and set the delimiter as '|' manually , final delimiter none or end and null field value ''.

Not easily using a Sequential File stage. Only one record format is permitted. You can use multiple Sequential File stages each writing one record format then assemble the resultant files into one with a cat command. Or you could specify the table definition for the Sequential File as a single, large VarChar column and build your own record including delimiters.
Another possibility is to investigate using a Complex Flat File stage.

Etiquette Note
samsuf2002 please write in English.