DSXchange

It is not possible.

You can create a Batch in Director, which is automatically compiled, but that it the only thing that can be compiled from Director. And you're not in charge of that - it's triggered by the Save of the Batch.

Try invoking it with the start command. To learn more, type START /? at a DOS prompt.

That has nothing whatsoever to do with hashed files, indeed it's a problem on the client. Please begin a new thread.

qutesanju wrote:I applied transformer stage but the problem is that if I provided more than two columns it throws error.

ray.wurlod wrote:Welcome aboard.

You might like to investigate the Folder stage. ...

Who mentioned Transformer stage?

A more precise solution is to allow the right input columns and any output columns derived from them to be Nullable, and check explicitly for NULL.

I said that.

Do you have an ODBC driver for Excel on your DataStage server? If so, use that to read the worksheet and you can save the rows however you wish.

You would have had to create two ODBC stages even without the local container, because passive stages can not open their outputs until their inputs are closed - with one stage only your design would have a deadly embrace situation.

Use DIGITS transform (which is a meaningfully named way to invoke the "MCN" conversion).

Yes. QualityStage 7.5 supports NLS.

Create a server job that reads your file and invokes UtilityRunJob() to run a generic job that takes the file name (and anything else needed) as a job parameter. You could do the same with a job sequence (instead of a server job), if you read the file then convert the line terminators into a delimit...

DROP TABLE is not a UNIX command. You'd have to wrap that in an sqlplus script or similar.

Try setting the "case sensitive names" property. This, if I recall correctly, adds quotes to identifiers such as table and column names.

Version Control is dead. It does not exist in version 8.0 and later. No further development (though I guess they'd still fix bugs were any found).

A replacement is promised in version 8.1 or 8.2, which will have more of the attributes of a source code control system.

Welcome aboard.

The obvious response, lacking other information, is to suggest that you review your job for any location where division by zero might be attempted.