tab as a filler

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
Svengiyil
Participant
Posts: 25
Joined: Tue May 05, 2009 12:16 am

tab as a filler

Post by Svengiyil »

Hi,

I need to have tab as a delimeter between two columns for the file I generate from datastage.

For ex: A<tab><tab>B<tab><tab>C

Is there any function like Space function in ds using which we can generate tab?

Thank you,
Svengiyil
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

The Char() function lets you input an ASCII value and the function returns that character. Thus, "Char(9)" would give you a TAB character.
Svengiyil
Participant
Posts: 25
Joined: Tue May 05, 2009 12:16 am

Post by Svengiyil »

Thanks a lot ArndW, Its working for me.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Performance tip: initialize a stage variable, say svTAB, to Char(9). That way the function is only evaluated once.
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