DSXchange

He did.

Stick with letting Oracle do your 'load balancing' for you.

ray.wurlod wrote:I think the requirement is to read from the DBF files directly

I assumed so to, something ODBC should be able to handle quite easily I would think.

highpoint wrote:My understanding is ODBC stages will use odbc.ini and will not use tnsnames.ora

Not true, it will need both for Oracle.

highpoint also wrote:Would appreciate clear lucid reply.

'Lucid' as in rational and sane? As opposed to our normal mad rantings?

In other words, check first and only perform the division when the divisor is not zero.

I know, it wasn't a question... I posted it because the answer you got was specific to PX jobs.

Server job.

Which is what I meant by 'DataStage' - Engine, Projects, etc.

You can read about Job Scheduling in Chapter 2 of the Director Client Guide pdf, all of the options are explained there. Just re-read it myself and seems I was wrong about the date options, you'll only be able to do the 'every two months' thing one at a time just before it is time for it to run.

Perhaps you could read this in using an XML Input stage and then send it back to an XML Output stage, dropping the SeqNum in the process?

So, it this actually a Parallel job question?

Probably time to involve your official support provider.

ODBC. You (or someone here) will need to check if one of the branded ODBC drivers that ship with the product suport .dbf files, if not one would need to be purchased.

Then it seems to me it's time to involve your official support provider. Perhaps this is a known issue.

maheshkumar.bm wrote:My job will run once at every two months ,how can we schedule like this for our job.

You'll need to 'Add to Schedule' once for each explicit date, so six times to cover a full year.