DSXchange

As you've found by searching the forums, doing this in a 'Before job' routine is too late as the job has already started. And there's nothing to set from the Directory other than a global default for jobs run from that instance of the Director. Your only option that I see is custom job control code,...

I would wager you'll need to roll your own conversion.

Before reading this, I thought it was a typo as 3x16 is 48 not 36... so, sexatrigesimal?

Why kind of help do you need? Stop sending multiple records with the same values in the unique indexes. Hashed files should be used to validate your processing and drive the inserts v. updates.

Short answer is you'll need to script the scp and execute the script from within your job control - Sequence, After Job, etc.

Do the looping in another Sequence that calls this Sequence inside the Start/End loop stages. A custom routine can exit the loop at the proper time.

It should be logged, double-click on the entry. Worst case, use DSLogInfo to write something specific.

ps. 'wc -l <filename>' will work fine, no need to pipe cats.

Make sure the file gets created properly... the salary information will be valid only if quoted - "10,000" for example, or have those inner commas removed.

Did you create them as 'Before/After' subroutines?

You just repeated your question, virtually verbatim, from the first post. If neither reply actually helps, you need to rephrase your question.

madog wrote:Do i just enter 027 under the delimiter section?

Yes, that's exactly what he means.

And in case you already have one of those and want to call a routine from inside it, search the forums for DEFFUN and all will be revealed.

Get a bigger boat?

parameswar wrote:Since it is 4 CPU, configuration file contains 4 Node

CPU != Node.

First suggestion would be to post in the proper forum. Hint - this isn't it. The 'General' forum would be most appropriate.

Another approach - run the sdk routine once such that it creates the SDKSequences hashed file properly in the project, then replace it from backup. Or do the original creation 'using Account Name'.

Don't build an 'infinite' loop?