DSXchange

Source your dsenv file first so the environment is properly set:

I agree with Ray. Null is the 'unknown' value.

Anything you need to be able to run multiple 'copies' of at the same time needs to be Multi-Instance, Sequence jobs included. You've got the macro right and you would use it in the Job Activity stage of the Sequence job.

Excellent detective work. :D

Now you just need to mark the thread as Resolved using the big button at the top of the screen.

We do that by having multiple projects created on the server rather than multiple servers installed. Is that not an option for you?

Continue here. I'm pretty sure you can edit the job type as I could swear people have done so in the past.

And here I even took the time to check your posting history and saw that all of the old questions were for Server jobs, so just figured we were just in the wrong forum.

Right, we know. Was hoping you would figure out the need to separate the two portions before performing the calculation. And when you are done, put the time back on.

Or that.

Meaning, you posted in again over there. Roy, our dear Moderator, would have moved it for you given the chance. Ah, well.

Ah... true. I tend to forget about UtilityRunJob as I don't use it. I was worried about the whole 'passing the entire contents of the file in a single record' aspect of the Folder, but you can avoid that by using it to simply return the filenames and then running the processing job for each row.

Transformer. Take advantage of the fact that, if properly prepared with intermixed record terminators, one 'record' can be written out by a Sequential File stage that reads back in as multiple records.

There's a FAQ posting on this very subject:

http://www.dsxchange.com/viewtopic.php?t=88639

Try putting 'sh' or 'ksh' in the command box rather than the dot.

Why not try posting some lines here from it, say from the 10 before to the 10 after? Then perhaps we can help more. Use [code] tags, please.

Don't worry, your English is muy bien.

Still would like you know if you looked at the actual source code at line 489. You would need to be in the Project directory, under the RT_BP1671 subdirectory looking at the "JOB.973446432.DT.1484558420.TRANS3" file.

I can see what you are trying to do. You didn't answer my question about what exactly you are putting in each prompt in the stage. And what exact 7.x version are you running?