DSXchange

Because you're doing this in a job sequence before the job starts, you can simply request the job start timestamp in a Routine activity. FUNCTION GetJobStart(TheJobName) $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF hJob = DSAttachJob(TheJobName, DSJ.ERRNONE) Ans = DSGe...

Design a single job for each file, and maintain them into the future.

As soon as you wish to apply any kind of transformation, even a Trim() function, you must name the input column and output column explicitly. That rules out runtime column propagation.

You've missed the point. You don't need to treat them separately, because they follow a common pattern, namely nnnnnn$aaaannnnn. As was described - documented - in the response by DSguru2B, the expression takes: everything to the left of the $ character { Field(x, "$", 1, 1) } the first character of...

Convert them to internal format (which is an integer number of days from a particular day #0) and subtract. You then have the difference in days.

Don't you have another thread open on this very question?

Documentation on the orchadmin command can be found in the Orchestrate Administrator manual.

Is the sequencer an "any" or "all" sequencer? Possibly, downstream of the sequencer, you need to create a loop for each job, that iterates for no more than your specified interval, sleeping (or napping) for small intervals in between checking whether the job's status is still "running". Suggestion: ...

MKS Toolkit? Ships and installs with version 7.5x2.

Even version 7.5x2 (Windows) permits conditional lookups.

The Lookup stage has its own "Constraints" area - click on the second tool from the left in its toolbar.

Another possibility is that the job was exported from another project and imported into this one but the routine was not, so that ClearHashFile does not even appear in the Repository. If this is the case, you must obtain the routine from wherever the job was exported from.

Folks, I m trying to use the Modify_Stage and I was wondering if anybody has used "lookup_int16_from_string" Conversion. I m trying to pull the substring from the column 1. "3.5 L V6 24-Valve DOHC" ---------------------> 3.5 L 2. "3.8 Liter V-6 24-Valve DOHC" -------------------...

Briak Kernighan is the "k" in "awk" - Aho, Weinberg and Kernighan.

Should work, but is inefficient.

... then why did you post in the Server forum?

Craig covered the possibilities; either use an FTP stage or use a facility like Samba that makes your Windows folders visible to your UNIX machine (as if they were mounted there) or vice versa.