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
ds2000
Premium Member
Posts: 109 Joined: Sun Apr 22, 2007 7:25 pm
Location: ny
Post
by ds2000 » Wed Aug 13, 2008 3:59 pm
Want to make a tab delimited flat file (dos style). What value has to be used in Sequential file settings in FORMAT -> DELIMITER. I tried 011 but it didnt work. Its server job.
CFF -> Transformer -> Seq. file
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Aug 13, 2008 4:01 pm
Decimal, not Octal so "009". Assuming that's where you were going wrong.
-craig
"You can never have too many knives" -- Logan Nine Fingers
amarpatkar
Participant
Posts: 7 Joined: Thu Apr 19, 2007 10:22 pm
Location: Melbourne
Post
by amarpatkar » Wed Aug 13, 2008 6:01 pm
ds2000 wrote: Want to make a tab delimited flat file (dos style). What value has to be used in Sequential file settings in FORMAT -> DELIMITER. I tried 011 but it didnt work. Its server job.
CFF -> Transformer -> Seq. file
Mate,
In the FORMAT under the Field defaults you will have a property called delimiter. It should have a 'tab' option in the drop down list.
Cheers,
Amar
Cheers,
Amar
Consultant
Zenith Solutions (Aust) Pty Ltd.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Aug 13, 2008 6:28 pm
Not in server jobs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed Aug 13, 2008 6:29 pm
Not in server jobs.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
amarpatkar
Participant
Posts: 7 Joined: Thu Apr 19, 2007 10:22 pm
Location: Melbourne
Post
by amarpatkar » Wed Aug 13, 2008 8:17 pm
ray.wurlod wrote: Not in server jobs. ...
Sorry guys, I dont why I missed that I was reading the DS server edition category.
Cheers,
Amar
Consultant
Zenith Solutions (Aust) Pty Ltd.
Ramani
Participant
Posts: 58 Joined: Mon Oct 08, 2007 1:51 am
Post
by Ramani » Sat Aug 23, 2008 7:04 am
amarpatkar wrote: ray.wurlod wrote: Not in server jobs. ...
Sorry guys, I dont why I missed that I was reading the DS server edition category.
So server jobs cannot have a delimeter tab in sequential file? Please confirm?
Thanks
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sat Aug 23, 2008 7:46 am
No, of course it can. It's just that there's no drop-down select list, you need to (gasp) type in the decimal value or the actual delimiter.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Ramani
Participant
Posts: 58 Joined: Mon Oct 08, 2007 1:51 am
Post
by Ramani » Sat Aug 23, 2008 8:24 am
chulett wrote: No, of course it can. It's just that there's no drop-down select list, you need to (gasp) type in the decimal value or the actual delimiter.
...
No. Because I was confused about Ray's message.
Thanks
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sat Aug 23, 2008 8:40 am
Which I clarified. His 'not in server jobs' comment was
specific to the mention of a
drop down list which does not exist in Server, not that you can't use a tab delimited file.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ds2000
Premium Member
Posts: 109 Joined: Sun Apr 22, 2007 7:25 pm
Location: ny
Post
by ds2000 » Sat Aug 23, 2008 9:28 am
009 value works to make tab delimited file.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sat Aug 23, 2008 10:11 am
As noted in the first reply.
-craig
"You can never have too many knives" -- Logan Nine Fingers