DSXchange

How about a file with a timestamp as part of its file name?

sujaoschin wrote:Ray,
Please let me know how to use the NOTFOUND variable.

More pedantically, as soon as they have been committed.

What output do you get for these rows?

Check in the job log to ascertain that parameter values passed to the job by the sequence are as expected.

What error did you get from the compiler when "it wouldn't compile"?

Instead of the angle bracket notation you can use a Field() function which is equivalent (that is, the delimiter is @FM).

I don't think so. If you find a way please post your findings.

Oracle Enterprise in Write mode uses sqlldr.

Can it be made an "auto run" macro that runs when the workbook is opened? Can you invoke a macro as if it were a stored procedure? Just ideas - no idea if they will work.

Is there no longer an Edit option under the Rules > Standardize Rules Management menu? (I don't have version 8 available at the moment.)

Did you Search?

If the lookup link is serviced by a hashed file, then you can use the NOTFOUND link variable for the reference input link. Otherwise use

It's an Oracle internal error code, not a DataStage internal error code, so surely you should be asking your Oracle DBA?

Safest is to pre-process all the data every time. Think about it. You don't process the same data in production that you do in development. You rarely re-process the same set of data. If the data happen to be sorted and your sample is "the first n% of rows" your range map will be badly wrong. If you...

Welcome aboard. I have never seen this. Try looking at the DOS command AT before you change the schedule and again afterwards, to see whether you can discern what might be happening. I suspect, though, that this will be one for your official support provider. Hang on, does version 8 still use the AT...

Are you confusing reindex with recompile? You should not need to reindex only because you've imported things - index maintenance should be automatic even in this case. Import does not use the bulk loader, so that there's not even any issue of deferred index building to worry about.