DSXchange

The option is there in the upper right-hand side of any post that you have made: Delete this post up there with Reply with quote and Back to top. As long as there's no replies yet.

Not resolved as much as superfluous because it was (I assume) an accidental double-post. Really should have just deleted it before someone (or two someones) replied to it.

One of the three Tech Tips in the zip file here should get you going. Like some of us that hang out here, they may be old but they still work good. Some days more gooder than others, of course.

Have you tried running your job yet? Having any issues?

Is your documentation broke? These are all detailed in the Parallel Job Developer's Guide - description, aurguments and output.

Or you could write to a Folder stage in a Server job... just to round out the suggestions.

Yes, but you don't have dates - you have timestamps. Different beasts.

People, don't "clear up" your post by starting a new post, simply reply back to your original post and clear things up there.

How many records total in the target table? Is the field you are deleting based on indexed? Wondering about full table scans...

You'll need to reinstall everything and select the option then. Are you sure you really need NLS installed?

The way we noted here. Include where it lives in your PATH variable in the dsenv file. Or 'cd' to the directory first. Or fully path the command.

A single node should remove any locking issues from the table. As noted, deletes are very expensive - how many does the job need to do? What are you seeing in the Monitor?

Best way IMHO is to do this all in hand-coded BASIC job control. Read the file, DSAttachJob(), use DSSetParam() to establish the values and then DSRunJob() to run the Sequence, DSWaitJob(), etc. This is very similar to the job control code you can automatically generate in any job's Properties from ...

You can do the same using stage variables in a transformer, if that is really what you need to do.

Or run it on a single node.