DSXchange

Exactly, and why I asked. The issue and the setting changes you'd need to make (or at least check) are documented here:

viewtopic.php?t=125607

Why not show us what these flattened out Oracle records would need to look like, ideally using the same data you posting in your XML.

Rather than all of those steps and an interruption on the server, simply set up a cron job to find and delete any file over two days old in the &PH& folder. Set it to run it once a day, everyday, and then forget about it. No need to clear job logs on any kind of regular manual basis either. ...

No, it doesn't. In the OCI stage :2 would represent the second column, anywhere else the second ? in the 'where' clause would be mapped to the second Key column. Meaning, outside of the OCI stage with its numbered bind parameters, you'd need to pass the value in twice to achieve this. FYI.

The result? :shock: Hmmm, harken back to 1984 for a moment with me... Stantz: Fire and brimstone coming down from the skies! Rivers and seas boiling! Spengler: Forty years of darkness! Earthquakes, volcanoes... Zeddemore: The dead rising from the grave! Venkman: Human sacrifice, dogs and cats living...

Interesting... which 8.x version are you running? Specifically, is this 8.1 where the job logs are in the XMETA repository or are they still hashed files in the project? Known issue, if the former, and there's a way to force them back to the "Universe" layer.

Ah... duh, should have caught that. That or reference only the first element of the Output dynamic array in your expression.

Sorry, yes meant time on a 24-hour clock not strictly "zulu" or GMT time.

UserStatus <> Job Status and that's just text, not anything meaningful. You need a custom trigger to check for:
Replace "JobActivityStage" with the actual name of the stage in your Sequence job.

Yup, and you typically need to standardize the dates so month/day are forced to two digits and also handle the conversion of AM/PM to military time. Typically.

Why not just read the chapter on the Modify Stage in the Parallel Job Developer's Guide pdf? Got examples and everything.

Server BASIC routines are not "strongly typed" so not typically an issue as everything is handled as a string under the covers. Post your routine code so we can see what all is going on in there, especially around Line 15. I'm also curious what you're going to do with this computed value? ...

A simple search for "Master record" turned up a number of relevant conversations, for example:

viewtopic.php?t=99961

Perhaps it's obvious to everyone else, but I'm curious what "disturbing the link properties" means here.

Pass in yesterday's date as a job parameter. Use it in both the ExecSH call and the Sequential File stage.