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
Output to a flat file of the following structure
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Another possibility is to investigate using a Complex Flat File stage.
Etiquette Note
samsuf2002 please write in English.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.