DSXchange

I don't believe there is such an option in the Join stage... but let's see what others have to say. Pretty sure those are your two options.

What you call "clutter" I call a useful piece of information.

You can also use an APT variable to turn off automatic TSORT insertion for that entire job but I personally would recommend sticking with the Sort stage.

You have to tell it WHAT you want trimmed - by default it trims spaces. And you should also ensure you specify "leading".

I believe you have to use a single job parameter there.

There are five that need to be 'escaped' as Ernie notes: " " ' &apos; < < > > & & So your example output as posted is incorrect as "RANJAN & CASH" would be escaped in the XML as "RANJAN & CASH"... I'm assuming that's a typo on your part.

First step would be to read the Connectivity Guide for Netezza Performance Server pdf. Or check out the information available online.

You get this error when, exactly? And is this affecting everyone or just you?

Except for the "C2 is not fixed length" part... I was thinking that Transformer Looping might be the way to go, hence the version question.

Index isn't going to be helpful here, unless perhaps you're willing to execute it 26 times. Seems to me you'll need something more like a Regular Expression to detect the presence of four contiguous occurances of the same letter in your data.

Neither of those expressions are valid:

If (Len(Trim(InputColumn)) = 5 Or Len(Trim(InputColumn)) = 6) Then 1 Else 0

InputColumn=0 OR InputColumn=1

What have you tried?

I'd also be curious what exact 8.x version of DataStage you are running.

:idea: Please do not come here and simply post input and output examples and ask for "logic to implement". Explain to us in words what your requirements are, what needs to be done to turn the input data into the output data. Ideally, also add what you've tried so far and what issues you ha...

I'm not Arnd but you can check the help index and look for any that start with 'DSGetLog'.

As Mike noted, you don't need all that but rather simply switch from IsValidDate (which needs a date not a string) to IsValid with a parameter of "date" and the format string.