DSXchange

Not ExecTCL; this executes "UniVerse" commands. Use ExecSH. You may need to use the full path of the orchadmin command, if its parent directory ($APT_ORCHHOME/bin) is not defined in your PATH.

Forty Two

Even easier (and better performing, because you will get parallel operation) would be to use multiple File properties in the Sequential File stage, or to change the read mode to "File Pattern" and specify a regular expression to select the files.

Add an index option (in the Oracle Enterprise stage) or drop indexes, recompile and rerun.

Get into the habit of using meaningful stage and link names.

One task, one stage. (Transformer excepted but, if you examine the code it generates, there's a heap of Orchestrate operators that might appear there.) The Transformer stage can, of course, do what the Filter stage does in addition to the transformation. So, if you lose the Filter stage and set up m...

Study the SDK date/time routines. Find out what the "generic" SDK timestamp format is.

I will to increase the number of virtual processors in DataStage Server. I think that license is by number of processors, so can I have some problem if I increase the number of virtual processors? Regards, Fernando What - precisely - do you mean by virtual procesors? DataStage is licensed by the nu...

The OP marked the job type as parallel. That rules out hashed files.

Sounds like it's time for the OP to enrol in a training class.

It could be security on the target (Red Brick) machine. They may have blocked telnet (port #23). You will need to ask whether this is the case. If it is, you will need to work a different way, and it may involve creating a shell script to invoke "secure telnet" (SSH), which uses port #22, to invoke ...

Why not monitor it in the routine itself? The same routine that "keeps running a job until the job gets some input". You can pick up the job start time (use DataStage macro perhaps), and the current time. That ("keeps running a job until the job gets some input") is an interesting concept. Can you p...

DataStage server jobs on Windows can use functions exposed in ActiveX controls. You do not need to use the GCI explicitly to call these. Beware, though, that performance sucks. There is a mechanism for calling other C functions, but in this case you do need to set up "GCI subroutine definitions". Th...

Note that Arnd's method is only checking the Transformer stage(s); it is NOT a way to compile jobs on the server. But, in our experience, it is in Transformer stages that most compilation errors occur. Nonetheless, it could be difficulties with the Repository structures themselves. What happens if y...

For example Fmt(InLink.ColA, "11'0'R") Fmt(InLink.ColB, "11'0'R2") Fmt(InLink.ColC, "11'0'R3") Beware, though, that ColB and ColC may not fit into a Char(11) field; they have potentially 12 and 13 significant digits respectively. How do you plan ...

Welcome aboard. :D Look at the Folder stage; this may do what you require. Search the forum for techniques to use if the XML files are very large. You could also construct multiple jobs (for the different sets of elements), and set the Sequential File (target) to append rather than overwrite. Help o...

For one value, I'd still recommend the user status area. Use a server job (or a fully sequential parallel job that includes a BASIC Transformer) to obtain that value and store it in its user status area. Use the parent job sequence to retrieve that job's user status value, and supply that as the val...