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
harikumar
Participant
Posts: 33 Joined: Wed Apr 21, 2010 9:19 pm
Location: banglore
Post
by harikumar » Sat Jul 03, 2010 9:10 am
my oracle table data is
ename
sri<>rama<>krishna
i want to do delete <> before load the data into source sequentialfile.
Sreenivasulu
Premium Member
Posts: 892 Joined: Thu Oct 16, 2003 5:18 am
Post
by Sreenivasulu » Sat Jul 03, 2010 9:11 am
1.Click 'search' in this forum
2.Go through the documentation
Regards
Sreeni
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sat Jul 03, 2010 9:19 am
Check out the Convert() function. Use it twice.
-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 » Sat Jul 03, 2010 2:30 pm
If your data are likely to contain single "<" or ">" characters prefer the Ereplace() function. This is not supplied by IBM for parallel jobs, but one of our posters has posted the code here on DSXchange.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sat Jul 03, 2010 4:38 pm
True, but assuming not, Convert is a perfectly valid solution.
-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 » Sun Jul 04, 2010 2:14 am
And, if that assumption holds, you only need one Convert() function.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sun Jul 04, 2010 6:34 am
True again! For some reason, had it stuck in my head that it only did one character - literally. Forgot about the whole matching list bit.
-craig
"You can never have too many knives" -- Logan Nine Fingers
venugopal.123
Participant
Posts: 9 Joined: Sun Jun 27, 2010 11:52 pm
Post
by venugopal.123 » Tue Jul 06, 2010 2:52 am
Use field function to remove <> in the column...
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Tue Jul 06, 2010 3:12 am
venugopal.123 wrote: Use field function to remove <> in the column...
I don't think that the field function is usable here. The FIELD() delimiter is a single character and not the 2-character sequence required here.