DSXchange

So? That's the beauty of it - 0 is false and anything else is true, not just literally a 1.

Not quite. Index would return a 1 for 'VS'. Perhaps:


Treated as a boolean the derivation will be triggered by any non-zero return.

Good to know! Time to mark this as Resolved it seems.

LEN checks for Length, not content. You need to use the substring operator:



ps. Welcome! :D

Sure, just cast it TO_DATE using the proper matching mask:

Interesting... to be perfectly honest, all I've ever needed to use was a splat so just made an assumption that it was doing O/S pattern matching. You're right, the help notes only the use of '*' and '...' which implies Universe pattern matching, or so it seems to me. Anyone done anything other than ...

Well... nothing about that technique itself requires a database table, just some form of persistent storage. I chose a table because of my need to include my ids in other sql operations. And the scope of the persistence would be whatever was appropriate for you needs - just the life of the process, ...

What kind of values are in the "_DEF_" portion of the filenames you want to avoid? Not sure how to do this on Windows, but if "DEF" is always character data, then something like this on a UNIX system would work: ABC_[0-9]* You could also use '?' rather than '*' to specify a maximum number of charact...

Well... running them in a Sequence job or in a single Server job with no dependencies between the job streams will both run all four 'in parallel'. It's just that you have restartability and other options available in the Sequence job that you don't have in your original approach.

Hmmm... this is hardly 'normal' behaviour. If you've continued to have issues across major versions like that, seems to me there's either an environment issue or something (not sure what, however) in how it is being managed. Never ran DataStage on an AIX box so don't know how much of a factor that m...

No, you'd need to use dsexport instead. Refer here.

If you can connect to the database in question and run the stored procedure from the server where DataStage is installed, then it sure seems to me that DataStage should be able to do the same. The fact that the job doesn't report any errors and yet your work was not done implies to me that you may n...

Unless they've specifically added that 'parameter set' option to the command line, you'll need to specify each individually. Check the documentation or type dsjob -run and check the usage statements.

I don't have 8 dot anything so can't check myself.

OP = Original Poster = Oops.

Ah... wasn't aware of the knotted version in the PX world.