DSXchange

Well... Ray has a Server version of the IsValid() function stashed somewhere, that could be one approach. Or you'd need to use a mess of IConv/OConv function plus perhaps the other type checks like Num or Alpha. Then you'd need to decide how you wanted to implement it, how to get all of the values i...

I've seen problems going the other direction - a 7.5.1a client accessing a 7.5.3 server. The official line you'll get from support will be that they have to match.

#1 is simple enough, why not go that route? Anything else seems like an... 'over-complication' to me.

LOL... obviously I was looking for something a little more specific than that but perhaps that is all that is known.

Let's get you into your own post, Phil.

I'm guessing that it is because 7 is an illegal value and that you got away with it in 8.1 but that 'loophole' has now been closed. Where did the 7 come from?

I'm curious what part of "start your own post" was unclear? Regardless, here you are split out into your own post, one which you can now control the fate of. I had to guess on the Release & OS values, please let us know if those are wrong. Can you elaborate just a wee bit on your requi...

I trust you actually read what Phil posted?

Define "complex statement". There is a limit to the length of the SQL statement you can use, does "complex" in your case translate to "really long"?

Nulls, perhaps?

Just for grins, Phil, can you share for us the settings you are using in the Sequential File stage? You've mentioned how your data is delimited and what the file looks like, but not the actual settings you are using... I just don't want to assume anything.

Please start your own topic, explain to us what you are needing/trying to do and post the code you are using.

A string is always "valid", what exactly are you expecting and/or trying to check for? As noted, there are functions to check the contents of a string for alpha, numerics, etc.

Post the relevant message from the log, the one that shows the command being executed and the result. Also curious what your script does and what value(s) it returns. When you ran it by hand from the command line, nothing was checking the return code, the status it passed back. DataStage does.

datastagedw wrote:Also we need to join this huge data with little less(less than a million records) data from a different database table.

A different table... in the same database?