DSXchange

Can you do a view-data on this input file, which I assumed that you have checked does exist and has sufficient access rights?

Yes.

Since you posted this in PX, you are talking about c routines in libraries. These can call each other without issue. If you are talking about DS/Basic routines,then they, too, can call each other when declared with the DEFFUN declaration.

Look at your runtime column propagation (RPC) settings. Using the search function will also assist you further.

If you have enable job administration in the director then you can do this by clearing the status in the director.

Craig - one reason I posted it here is that I often forget how it works, then cannot find the DSGetJobInfo() call. This way I know that all I need to do when I forget it next time is to search DSXchange. I sometimes use both methods, either a file existing/not existing or a STOP request. One aspect ...

Moreover, an earlier reply by one of the members mentioned that the hashed file will only be available for reading once all data has been written to it. . That was me and it is correct for the specific example you mentioned. Since the write stage is the same as the subsequent read stage DataStage k...

The statement

So during a lookup, if it couldn't find a match, it will go back to disk to search for it

is incorrect.
If the file is too large to fit in memory the lookups will be done from disk, otherwise from memory.

I tend to use very short SLEEP periods (5-10 seconds) inside a loop; that way any interrupts can be handled when the SLEEP returns to the program. In a sequence you can call IF DSGetJobInfo(DSJ.ME,DSJ.JOBCONTROL)=DSR.STOP.JOB THEN ... ELSE ... to see if a stop request for the current job has...

Can you add the SAP data to your peek stage as well to see if they `look' the same? That problem seems rather odd, and I don't know what could be causing it.

Add a PEEK stage to your job to make sure it is the sequential write and not the Oracle Read (vs. the view-data) doing this.

I just checked my "full export" file - which didn't contain object code or routines

It is normally not directly visible. In the designer, do Stage Types -> Parallel -> Processing -> BASIC Transformer.

Hello and welcome to DSXChange. The complete standard documentation is available on each installation CD. The documents are copyrighted by IBM so we just can't send them out (unless they are now available for download at IBM's website, but I haven't seen that).

only 2 full words were cut out, "s particular job". Yes, the load to memory won't start until the file has been written to, regardless of the cache settings.