DSXchange

SURA's suggestion is valid - what happens if you try the base IsValid() function with the "decimal" option rather than IsValidDecimal(), do you see the same behavior? From what I've read, they are not the same - the latter is not a 'shortcut' to the former.

You need to update the information in $DSHOME as well as in every project that you want to use the ODBC connection.

At this point you should be involving your support provider.

Have you ever worked with XML before? I don't mean in DataStage, I mean at any point. Just trying to judge your familiarity with XML... guessing it is new to you.

Key column. Singular. The whole point of this post is there can only be one. If you still need help, start a new post with your details.

Clarify for us what you mean by "set the Clear Log configurations"... what are you doing where? I'd also like to confirm where your logs are being stored as there are two choices in the post-7.x world controlled by these variables: RTLogging=1 ORLogging=0 What are yours set to? As above?

How can I get the sequence job to carry all possible parameters needed and _not_ just the parameters available to that one selected job the Job Activity requires? The job parameters that a Sequence carries are completely up to you. It is a separate, discrete list that may or may not have any relati...

I don't see the issue. The sequence job carries all possible parameters needed and you pass to each Job Activity stage whatever parameters each one needs.

techiexavier wrote: need the out from XML input stage for all files into one data set.

As noted, that is exactly what will happen by default, no need to append or clear - just replace each time.

And ps - you are not using a Server job. I corrected your post and moved it to the proper forum.

What does "does not work" mean? Keep in mind the fact that all of the "IsValid" functions require a string input, the goal being to see if the string can be successfully converted to the target data type before you actually effect the conversion. Are you saying that IsValidDecima...

Wow... better late than never I suppose.

Sorry but could you please do the Exact Search here that I mentioned? It's all out there, don't see a need to type it all up yet again.

your userid shows as a "premium member" here on the forum. Unfortunately, all this means is that they were Premium at one point - not that they are currently. They've let it expire. I've asked for this in the past to be changed to show one's current status but I don't think those kind of ...

ps. Split out to a new (but related) topic.

SURA wrote:

SURA wrote:Try if A <> 0.00

What i mean is, you can provide the condition like A <= 0.00 or A > 0.00

Aha! Then that's what you should have said. :D