How do I specify TAB delimited files

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ravij
Premium Member
Premium Member
Posts: 170
Joined: Mon Oct 10, 2005 7:04 am
Location: India

How do I specify TAB delimited files

Post by ravij »

Hi,

How can I give the delimiter Tab in the Format options in Delimiter Field inthe Sequential file in Server Jobs?

give me reply asap

Quote: Time is money but when you don't have money time is all you can afford.

--- Moved by moderator ---
DS version,Job Type and OS arbitrarily set
--------------------------------
Ravi
hexa
Participant
Posts: 51
Joined: Sun Aug 08, 2004 6:25 am

Post by hexa »

U mean how to give delimiter in format tab right?

Simply enter | symbol in delimiter tab
Sunshine2323
Charter Member
Charter Member
Posts: 130
Joined: Mon Sep 06, 2004 3:05 am
Location: Dubai,UAE

Post by Sunshine2323 »

You can give type 009 in the delimiter textbox

Also, please read the following article http://www.datastagexchange.com/Newslet ... habits.php
for getting acquainted with the good habits for posting in this forum
Warm Regards,
Amruta Bandekar

<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

(1) This is not a FAQ, please post it in the correct forum

(2) Nothing in this forum is urgent; at least not to anybody but the poster. Urgent and critical issues need to be raised with your support provider, they are paid to respond to problems like this. The forum is a loose agglomeration of volunteers who respond whenever they have the time and inclination. Usually posts with questions are responded to within the same timeframe as your support will do - but by putting in 'urgent' you will guarantee that response times will be longer, and many won't even bother to reply.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Re: How do I specify TAB delimited files

Post by roy »

ravij wrote:Hi,

How can I give the delimiter Tab in the Format options in Delimiter Field inthe Sequential file in Server Jobs?

give me reply asap

Quote: Time is money but when you don't have money time is all you can afford.

--- Moved by moderator ---
DS version,Job Type and OS arbitrarily set
--------------------------------
I'd apreciate credit for my phrase if your using it :!:
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You could have pressed F1 or selected the Help menu urgently to get this answer.

If you would like to engage my professional services to read manuals and help files for you, or even to present training, please contact me off-line.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
bharathappriyan
Participant
Posts: 47
Joined: Fri Sep 23, 2005 6:01 pm

Re: How do I specify TAB delimited files

Post by bharathappriyan »

ravij wrote:Hi,

How can I give the delimiter Tab in the Format options in Delimiter Field inthe Sequential file in Server Jobs?

give me reply asap

Quote: Time is money but when you don't have money time is all you can afford.

--- Moved by moderator ---
DS version,Job Type and OS arbitrarily set
--------------------------------
Please use 009 as Delimeter and 000 as Quote Delimeter and take out the defualt Padding Character #.
This format will give you the output file as Tab Delimited file.

Bye.
kejuste
Premium Member
Premium Member
Posts: 11
Joined: Wed Jun 01, 2005 11:42 pm
Location: Brisbane, Australia

Post by kejuste »

I agree with bharathappriyan,

Delimeter: 009
Quote Delimeter:000

i tried for my issue, I would suggest it will work.

Cheers,
Kathy Juster
Post Reply