DSXchange

Raftsman wrote:You could always create a lookup fileset and compare and replace with the character you want.

As I explained earlier, DS is not reading the accented characters correctly, so I don't think the junk character can match to the lookup.

Post your syntax - the suggestion was strictly in regards to using one rather than a bajillion inline function calls. The syntax still contains a billion functions: Convert(Char(135),'c', Convert(Char(128),'C', Convert(Char(221),'Y', Convert(Char(150),'u', Convert(Char(151),'u', Convert(Char(219),'...

chulett wrote:One suggestion - use Convert rather than EReplace, that way you'll only need one statement. Check the online help for the gory details.

Already tried, does not work.

Ronetlds wrote:Just confirming, I should have said "Is this what you have set up"

Anyway, try

SUM_CASH_VAL :decimal[11,2] = handle_null(SUM_CASH_VAL,0)

Note the brackets [] after the word "decimal". Not parens (). That could be your problem.

Thanks a lot Dude. That resolved it.

Yes, Thats how its setup. I am not sure what u r trying to say, pls explain.

ray.wurlod wrote:Yes, unless the middle fifteen don't do anything in particular, in which case replace those with "the one sequence to rule them all".

Great! Thanks Guys

Calling/using nested job sequences to achieve a more modular, and therefore more maintainable, design is a "best practice". While an activity is executing its controller (the job sequence) is effectively sleeping, waiting for the activity to conclude. DLLs on Windows are, by their very na...

Hi Gurus I have a design question. We are running DS 7.5.2 EE on windows 2003 server. In parallel jobs, if we create multiple layers of sequences so that it doesn't look messy on the designer, does that have any implications? I mean if one sequence calls another sequence and the second sequence call...

Try doing the 'If Then Else' part in a stage variable. Set APT_STRING_PADCHAR \x00 and Trim DS.ID1 and DS.ID2 in the else part. You can also try to bring both the input fields as varchar instead of char to test for success. If DS.ID1 = '000000000000' Then If DS.ID2 = '000000000000' Then SetNull() E...

ray.wurlod wrote:Because CHAR(12) requires twelve characters and APT_STRING_PADCHAR is set to \x00.

I will really appreciate any help on this. I am sure this is not a big deal for the gurus.

Because CHAR(12) requires twelve characters and APT_STRING_PADCHAR is set to \x00. Thanks Ray, so how can I detect 12 nulls? bcoz ISNULL doesn't work. I need to check if the value contains NULLs and then reject it. I also added the $APT_STRING_PADCHAR to job parameters and the value is 0x20 (space)...

Hi Gurus I have 2 fields both - CHAR(12) Not Null columns coming from Complex Flat file, which goes through Joins (no change to column metadata) and enters Transformer1, which has: If DS.ID1 = '000000000000' Then If DS.ID2 = '000000000000' Then SetNull() Else DS.ID2 Else DS.ID1 and the output column...

Search the forum, on-line help or the manuals for APT_STRING_PADCHAR environment variable. Hi Ray Thanks for the reply. I tried that - but no change. However I changed the source file to be the left link in the left outer join and now the filter works. this is a little wierd, I don't know why the A...

The point is that it doesn't matter - in a constraint expression - whether anything is removed - the result does not propagate. The expression will return True if there is any non-space character in the string, and False otherwise. Thanks to all. I tried all the suggestions, but no success. I found...

ray.wurlod wrote:

Code: Select all

If Len(Convert(" ", "", NullToValue(InLink.TheColumn, " "))) > 0 ...

Hi Ray

Thanks for the reply. I tried that, no luck yet