DSXchange

That doesn't sound substantially different than what the stage being discussed does. Have you run your 20M records both ways and compared the results?

Can you test this out at all? Or does everything need to be theory until you actually lose your servers?

deepa_shenoy wrote:I have given NULL Field value as '\xAB' for NULL handling.

I'm assuming this is the issue, the use of extended ascii for null fields. I doubt the viewer supports them, does the file look correct from the O/S?

Exactly, as already explained.

You've posted two versions - 7.5.2 & 7.5v2 - neither of which will run PX jobs on Windows. Do you actually have 7.5x2? And yes, you need to install a supported C++ compiler.

Yes, direct reference is made to the TNS name, a.k.a. the appropriate entry in the tnsnames.ora file... or possibly out on a names server. The question was how does DataStage (technically any app leveraging the client) know where to find the tnsnames.ora file.

And all DataStage does is add it to 'cron' anyways, assuming it is a recurring schedule. Otherwise it submits it to 'at' for those one-time times.

There is a DS_AUDIT table, search for that here for many discussions on how to access it.

Yes, repeat the process (the 'Add to Schedule' option) three times, once for each time desired.

Note that Ray did not say increment, he said "increment". There's a reason why it was in quotes.

Right, simply 'Add to Schedule' multiple times.

Or just rely on the fact that both methods are going to produce pretty much identical results.

satish.raghavan wrote:Sorry for using U. i meant You. Please change accordingly.I was Fast typing mistake.

Just for the record, you can go back and edit your own posts after the fact. To paraphrase Apple - there's a button for that.

Right, it's got nothing to do with ODBC and for Windows it uses the environment variables - ORACLE_HOME or TNS_ADMIN if set to override the default location of $ORACLE_HOME/network/admin.

Still... all this... completely unnecessary: ErrCode = DSSetParam(hJob1, "$DSDir", $DSDir) ErrCode = DSSetParam(hJob1, "$OracleUser", $OracleUser) ErrCode = DSSetParam(hJob1, "$OracleRemote", $OracleRemote) ErrCode = DSSetParam(hJob1, "$OraclePwd", $OraclePwd)