Format of an output in a Seq file stage

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
prashanto_dev
Participant
Posts: 27
Joined: Thu May 22, 2003 4:40 am
Location: California

Format of an output in a Seq file stage

Post by prashanto_dev »

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.
prashanto_dev
Participant
Posts: 27
Joined: Thu May 22, 2003 4:40 am
Location: California

Post by prashanto_dev »

My desired output will be like this:

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
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi,

You are still not clear on your requirement. But how does it help if the column names are aligned agianst the data.

--Rich
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply