DSXchange

My sweet apple-cheek'd mother taught me to darn SOX.

It's an informational message indicating that collection of data from all processing nodes must occur because you're performing an operation (export to a sequential file) that can only happen sequentially.

Welcome aboard! :D You need to construct the logic of detecting success or failure (you did not post any specifications for this). If failure is that of the overall job run you need to detect this in a controlling (parent) job or job sequence. Once you've detected success or failure, direct control ...

Why Is It So?

DS PX uses MKS Toolkit, and expects to see /tmp

This is presented by MKS Toolkit from \tmp on the currently logged Windows drive.

Not really. Deadlocks are avoided by disciplined programming practices.

Assuming version 7.5 you have StartLoop and EndLoop activities. Otherwise you can embed the loop in a job control routine, in much the way that the ClockMaster job control routine worked at a site where you worked earlier. Conceptually: Loop GoSub CheckWhetherShutdownRequested While Not(Shutdown...

Provided the other machine is visible and your authentication is OK, then a DOS-level COPY command as you suggested will be fine. The before-job subroutine is executed before anything else happens. Before any stage is opened, before any connection to a database is opened, before any file is opened, ...

2 - 18 or 30

You need to install the Pivot stage using the Package Installer on the server. You can also re-install the server, selecting the Pivot stage as one of the stage types to be installed in each project.

Assuming they're all inserts, use a bulk loader. SQL*Load (command is sqlldr) for Oracle.

A custom condition plus an annotation is perfectly legible, and satisfies the "law of least astonishment" (provided that the annotation text is apt).

Why not just create a job sequence (or job control code) that runs some trivial job in VALIDATE mode? The trivial job must, of course, access the database in question. Test its exit status to determine whether to proceed.

chulett wrote:Does the darn Filter command in the Sequential stage not support wildcards?

I am not aware of any darn command, therefore cannot advise how one might use it as a Filter command in a Sequential File stage. Is the darn command UNIX or DOS, or is it only used for SOX?

Just out of curiosity, there is a Perl category in the Routines branch in version 7.5.1. Would this task be able to be accomplished in Perl?

If there are always three sub-records you can use an intermediate sequential file. Write one column with a line terminator following each logical record. Imagine svLF is a stage variable containing the line character. Then the single output column into the sequential file stage (no delimiter, no quo...