Hi,
Is it possible to add more than one delimiter in a target sequential file in Server job?
Delimiter in Sequential File
Moderators: chulett, rschirm, roy
Delimiter in Sequential File
Ankita
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why not simply remove the (apparently stupid) requirement for a two-character delimiter? Use a non-printing character, such as Ctrl-Y (represented in DataStage as 025).
While you can use the Transformer stage as I mentioned above, the other team will have to jump through similar hoops to unpack the data you have created.
While you can use the Transformer stage as I mentioned above, the other team will have to jump through similar hoops to unpack the data you have created.
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.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
When you map the derivation for each column in the transformer, you can do something like this
Link.ColumnName : '||'
You need not do this for the last column derivation.
And then specify that the delimiter in sequential file as nothing. You may want to adjust your metadata definitions accordingly for the seq file.
OR, as Ray suggested, go for a single character delimiter.
Link.ColumnName : '||'
You need not do this for the last column derivation.
And then specify that the delimiter in sequential file as nothing. You may want to adjust your metadata definitions accordingly for the seq file.
OR, as Ray suggested, go for a single character delimiter.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!