DSXchange

I was looking for the syntax for this:

adityavarma wrote:But still one more issue is there , i am not able to pass the parameters to execute command acitivity from the Parameter set.

What does the .bat file return? Anything? I haven't used that exact stage before (never having worked with a Windows based DataStage server) but if it's anything like the Execute Command stage, any kind of a non-zero return is considered a failure.

It's not a pivot, just a concatenation. And there really shouldn't be any extra 'expense' with doing it in a stage variable.

I'd clarified what you need to do and hoped you'd put some effort into figuring out the rest but if you are looking for something more 'silver platter', then fine... The first link constraint should be something like: Today.Role_ID = "AAAAA" or Today.Role_ID = "BBBBB" or Today.Ro...

Constraints are expressions that evaluate to True or False and which control whether the link 'fires' or not, i.e. if data is allowed down it or not. What you've posted are assignments, in other words expressions that belong in the derivation of specific output fields, not in a constraint.

Ah yes, I've seen the same issue. Make sure everyone gets the fix, otherwise if someone without it compiles the sequence, the error will come back.

ArndW wrote:Craig, I agree with you - I would program it that way but expanded the logic to make the statement more understandable.

Of course and I figured as much... just couldn't resist the perfect setup.

What is your ultimate goal here? You said you already converted your timestamp to a date which is why the DateFromJulianDay() function fails - you don't have a julian day for it to convert to a date.

cat rejectfile1.txt rejectfile2.txt > commonrejectfile.txt && wc -l commonrejectfile.txt

As noted, no need to pipe cats. Are you 'cd'ing to this directory as part of the command? Always concerned when I see relative paths in something like this.

Or, exactly the same but my preference would be:
Constraint "Not(svDuplicate)"

"cat file1 file2 | wc -l" should be sufficient without having to create a file.

But that puts us firmly in the often scorned "piping cats" camp, so perhaps just one of the following?

wc -l file1 file2
wc -l file[1,2]
wc -l file*

http://home.iprimus.com.au/raywurlod/Da ... utines.dsx

ps. An hour is 60*60 or 3600 seconds.

About all you are missing from BugFree's comments is the irony they are dripping with. Perhaps some sarcasm as well.

So... still the same problem that you posted earlier?