DSXchange

Did you check this posting? Again, depends on what you mean by 'call'. It that just means 'use' then just use it directly, dollar sign and all.

Please explain exactly what is 'not working' about it. Simply saying 'it is not working' or 'i get an error' without mentioning the error involved makes it pretty hard to help you. You might want to post the entire routine. That snippet looks fine, the only 'error' I could see would be the value com...

Hmmm... what version of DataStage do you have? And could you explain what you mean by 'wanting to get' the name of the failed job? Get in what sense, what are you planning on doing with this information once you have it? That would shape the answer, I do believe...

When you use a Job Activity stage to run a Multi-Instance job in a Seqeunce job, a new field appears inside the stage: Invocation ID. That is where you would put the equivalent value to what you are passing on the command line after the 'dot'. You can hard-code the value in the stage, or use Job Par...

'Constants' = 'Consultants', I assume?

Which part is unclear? For whatever reason, you no longer have permission to create / write to those files or that location. You need to figure out why, see what changed that caused this.

Since you've marked it that way - what is your 'workaround'?

But we can not use the local drives, because our datastage is installed in the server system and also we use citrix connection. I've got no idea what 'our datastage is installed in the server system' means, but neither reason seems to me one that means you 'can not' use local drives. You might choo...

Ernie, is it possible to use a different Java runtime with XML jobs? I'm curious how 'hard wired' in the bundled version is.

They're not related, except they are both 'Update actions'. One effects an entire table while the other effects a single row. I'm assuming you know what the first does, contrast it with the 'Clear table and then Insert Rows' if you like. Clear does a transactional delete of all records. Replace Exis...

Sometimes we just don't ask.

Ah, and if only common sense were more common...

And I ain't talking about Thomas Paine.

Heck, probably marked double trade secret and Eyes Only.

Too bad about the class.

No problem. Now time for the obligatory post to request you to mark your thread as 'Resolved'. Thanks.

Do you need to be building your hashed files on a remote drive? That, in my mind, would generally be a Bad Idea.

Those are two notoriously slow stages, but 24 hours still sounds a wee bit long. However, that *is* a crapload of files to be processing all at once - we think we have a boatload when we get 1/10 that amount. Without knowing anything about your server setup or hardware or anything, about all that po...