DSXchange

So a field delimiter rather than a record delimiter issue. Odd.

Not sure how that would cause that... what is your record delimiter? Something unusual?

Sure. Answer my previous question as that will drive the design. Basically I assume you either want to process them one by one (multiple job runs) or find a way to process them "all at once" in a single job run. I've already noted how you do the former. Very high level, granted, but answer...

What code page / characterset is your target database using?

I've never had the opportunity of working with an external monitoring tool like that. How are your jobs being scheduled / launched? Any kind of Enterprise Scheduler would not only be running the jobs but doing also monitoring and reporting in real time. Now if your only scheduler is Director then yo...

Please only post your question once. I removed the duplicate in the other forum.

These 'multiple files' - do you need to pass them to and run the job one at a time? That would mean a looping sequence job and you would just build a delimited list of filenames and then iterate through that list.

You need to also check while the job runs.

Let us know if you need more help with this. Right now I'm marking it as Resolved, you can always reopen it if you need to.

Perhaps this?

Been discussed here already as an exact search should turn up. One example is here.

I don't believe you have any other option here. I don't see a way off the top of my head to do any kind of intelligent "replace string" to remove randomly placed duplicate values.

Just to be anal but if it can also include a sign wouldn't it technically be a PIC S9?

Not that that helps at all.

Let's get you into your own conversation. FYI - split off from this resolved topic. Not sure why you would expect the dsjob "list jobs" function to include shared containers in its output or how that relates to the topic at hand. I'm curious if you've tried doing istool exports to see what...

What have you tried?

In other words, there's no "setting" for this.