DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
smeliot
Participant



Joined: 18 Mar 2007
Posts: 19

Points: 157

Post Posted: Thu May 22, 2008 11:28 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Very simple job. Compiles and runs with IsNull( ...) in constraint (although doesn't give expected results).

When we add the Trim inside the IsNull function, we get the followng error when compiling:
##W IIS-DSEE-TOSH-00049 12:26:13(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (DY005_MRG_ECC_CIS.Transformer_50)


Have changed to "IsNull( ...) Or ...=' '" but am wondering why IsNull( Trim( ...) ) isn't working. And whether or not we should go through the hassle of reporting the problem.

Any ideas?

Thanks.
kumar_s

Premium Poster


since February 2006

Group memberships:
Premium Members, Heartland Usergroup

Joined: 16 Jun 2005
Posts: 5233

Points: 26291

Post Posted: Thu May 22, 2008 11:56 am Reply with quote    Back to top    

Hi Welcome Aboard Very Happy

What is the exact derivation given with Trim and isNull function. Is it just a field name? Doese the derivation gives the blue color after the edit or will it still give you red color for wrong derivation?

_________________
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Rate this response:  
Not yet rated
smeliot
Participant



Joined: 18 Mar 2007
Posts: 19

Points: 157

Post Posted: Thu May 22, 2008 12:00 pm Reply with quote    Back to top    

kumar_s wrote:
What is the exact derivation given with Trim and isNull function. Is it just a field name? Doese the derivation gives the blue color after the edit or will it still give you red color for wrong derivation?


IsNull( Trim( ...) ) where ... = link.column

No red - which is why we were compiling.
Rate this response:  
Not yet rated
kumar_s

Premium Poster


since February 2006

Group memberships:
Premium Members, Heartland Usergroup

Joined: 16 Jun 2005
Posts: 5233

Points: 26291

Post Posted: Thu May 22, 2008 12:18 pm Reply with quote    Back to top    

Other than the given warning, what other useful warning you get along with this?

_________________
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Rate this response:  
Not yet rated
smeliot
Participant



Joined: 18 Mar 2007
Posts: 19

Points: 157

Post Posted: Thu May 22, 2008 12:22 pm Reply with quote    Back to top    

kumar_s wrote:
Other than the given warning, what other useful warning you get along with this? ...


Not a thing, sorry.
Rate this response:  
Not yet rated
wesd
Participant

Group memberships:
Heartland Usergroup

Joined: 16 Aug 2004
Posts: 22

Points: 142

Post Posted: Thu May 22, 2008 1:09 pm Reply with quote    Back to top    

Maybe because you can't Trim a null character? Did you try using TRIM(IsNull(in.ABC,0))?

_________________
Wes Dumey
Senior Consultant
Data Warehouse Projects
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 51677
Location: Canberra, Australia
Points: 280650

Post Posted: Thu May 22, 2008 3:25 pm Reply with quote    Back to top    

IsNull() returns a TinyInt, and Trim() can only be applied to a string. This is why it won't compile. Trim() won't like NULL so you have to convert this null before the Trim() function is applie ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong
currently hiring: Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours