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 pmLocation: 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.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pmLocation: 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 pmLocation: 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.
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,
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pmLocation: Sydney, Australia
Contact:
Post
by ray.wurlod Wed Aug 13, 2008 6:28 pm
Not in server jobs.
IBM Software Services Group
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pmLocation: Sydney, Australia
Contact:
Post
by ray.wurlod Wed Aug 13, 2008 6:29 pm
Not in server jobs.
IBM Software Services Group
amarpatkar
Participant
Posts: 7 Joined: Thu Apr 19, 2007 10:22 pmLocation: 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,
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 pmLocation: 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 pmLocation: 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 pmLocation: 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 pmLocation: 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
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.