I have job which is writing to a file by using sequential file stage.
The record delimiter is "TAB"
The output is coming like this:
FILENAME VAL_STATUS
NJB_CIS_DIM_MST_DAT SUCCESS
NJB_CIS_DIM_TAX_DAT SUCCESS
NJB_CIS_DIM_MGR_DAT SUCCESS
I want ouput like this (ie column names aligned with the data)
FILENAME VAL_STATUS
NJB_CIS_DIM_MST_DAT SUCCESS
NJB_CIS_DIM_TAX_DAT SUCCESS
NJB_CIS_DIM_MGR_DAT SUCCESS
Pls let me know if anybody has any tips.
Format of an output in a Seq file stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu May 22, 2003 4:40 am
- Location: California
-
- Participant
- Posts: 27
- Joined: Thu May 22, 2003 4:40 am
- Location: California
You need to use
Code: Select all
tags to make your examples clear. Or people need to 'Reply with Quote' to see your original format as the forum software removes all extra whitespace otherwise. :?
I don't see the point of this 'need', a single tab will work fine depending on what you are using to view the file. If you really need that alignment regardless of viewer, then the TAB delimiters have to go and you'd need a fixed-width file. I'd wager, however, that what you have right now is perfectly fine.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
One easy way would be to write to a fixed-width format sequential file.
Another way would be to specify Char as the data type of the two columns, and change the DataStage pad character from 0x00 to space.
Another way would be to specify Char as the data type of the two columns, and change the DataStage pad character from 0x00 to space.
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.