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
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Perhaps...
Code: Select all
DIGITS(in.FldName) = in.FldName And in.FldName < 1000000
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
tbtcust
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 230
- Joined: Tue Mar 04, 2008 9:07 am
Post
by tbtcust »
Apologies chulett. This should have been posted to the Parallel job forum. I'll repost there. Thanks.
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
This *is* the Parallel job forum.
Just edit the original post and change the job type.
-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 »
With what character are the Char(18) fields padded?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
tbtcust
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 230
- Joined: Tue Mar 04, 2008 9:07 am
Post
by tbtcust »
Sorry about the confusion chulett
ray.wurlod , the field is padded with spaces. The number sometimes has a leading zero or two.
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Compare the trimmed strings. If that alone doesn't work is the Compare() function available? (I'm not on site right now.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
tbtcust
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 230
- Joined: Tue Mar 04, 2008 9:07 am
Post
by tbtcust »
I got the same results with Compare ray.wurlod.
NUM(Trim(in.field)) = 1 And Len(Trim(in.field)) < 7 seems to work. Not so pleased with this workaround but hey it does seem to give me what I need.