DSXchange

Welcome aboard. :D I presume you mean Lookup File Set, since there's no such thing as a Lookup Data Set. How did you make the copy? The "contiguous lookup table" referred do is an index-like structure stored within the Lookup File Set itself. If you made the copy using operating system commands, the...

I don't see any -n options in the sort specifications.

The 81xxx messages relate to the dsrpc daemon. Specifically, 81021 decodes as Error writing to pipe. SELECT * FROM SYS.MESSAGE WHERE @ID = 081021; Something (possibly intermittent) has gone awry between processes, dsrpcd, dsapi_server, dsapi_slave. Exactly where is not reported. Establishing a new c...

Every DataStage process runs as a phantom (= background process) and maps its output into a file in &PH&. Typically these files contain only "started", "finished" and "stage finished" messages. It is from here that additional diagnostic information can be transferred to the job log "from pre...

Virtual Data Sets must be re-created. They only exist while the job is running. Are we talking persistent Data Sets here? Was the problem therefore one of design, where you were relying upon existence of a Data Set that was being overwritten? There's nothing you can do in a DataStage job that will a...

You can create your own style sheets.

That is an unrelated error, caused by the job not being compiled or the job having aborted, crashed or been stopped. Change your execution rule to "reset if required, then run". Has the routine problem been solved? Note that routine names are case sensitive. Routines are not catalogued until they ha...

Could you generate the stream of data using something like cat `cat FileA`?

You do not require DBA privilege, which you are unlikely to be granted in any case. You only need SELECT privilege. There are several system tables to which you require SELECT privilege when using the Oracle Enterprise stage; search the forum to learn what they are.

Are the parameters successfully passed? Have the BAT file echo its command line and any other arguments or parameters on which it depends. Capture its output and log this as an event in the job log. Report what you see in that logged event. Are you using ExecDOS or DSExecute()? That is, are you usin...

Two separate jobs.

How are you scheduling the bat file (for such I assume it to be)? There may be problems passing passwords. Have you tried simply adding the bat file to the AT queue from a DOS prompt?

If you select from a View, then the SELECT statement that defines that view must be executed first. One approach would be to pre-execute that original SELECT statement (perhaps in a DataStage job) capturing the result into a text file. You may well find that this is taking the bulk of the time - if ...

DSExecute() is not a command. It is a subroutine callable from your own Routines, which can execute operating system or DataStage commands. You can find the full syntax in on-line help. For a fee, someone might be prepared to transcribe that information into this post for you.

Just avoid any jobs that might currently be running. I typically use find (UNIX) or Search (Windows Explorer) to filter just those files two or more days old, and only delete those.