DSXchange

There's no magic 'rename every job' button, it's a singleton operation.

karthi_gana wrote:I ran the batch for more than 5 time. I received the same error message.

Didn't ask you to rerun the dang thing 5 times but rather Reset the aborted job and look for the log message I noted.

I am not aware of KDA stuff... can you explain it ? Mentioning "Job Control batches" and "job hierarchy and ini files" means the KBA Job Control Utilities to me. And if that's true, there should be someone where you work supporting that. Ask them. It's not exactly a small one-po...

One at a time, manually, in the Designer. Or perhaps export the project, edit the dsx file to rename all the jobs and import them into a new project. Why in the world the need to rename everything?

Sounds like KBA stuff but that's not nearly enough information for anyone to help. Reset the aborted job and post any 'From previous run...' message that gets logged.

Sounds like a lookup to me. A sparse lookup to be precise.

Is this 8.0 or 8.1?

Official support doesn't get much more official than IBM.

Not sure what you mean by 'a misuse of OCI'.

Right, that's another approach - something akin to what is detailed here in the FAQ forum. As noted, can depend on your input column count - is it constant or a variable?

Have you not been reading the replies here? Please double-check your requirements as right now they make no sense.

So... let me get this straight. Rather than create multiple jobs, or perhaps leverage a schema file, you instead are willing to export the job / change the metadata / reimport the job back and forth as needed? Or have some mechanism to import the 'proper' dsx for the file to be processed?

Why bother with doing something like this? What you've removed is what the job needs to run, forcing a recompile.

That would be either the DSGet* functions if you want to do this 'in job' or the equivalent options in the dsjob command line utility.

As noted, the difference between two timestamps will be an interval, not another timestamp. You need to figure out what you really need.

I'm assuming what Ray means is you shouldn't have to. Try the conversion noted and let us know what happens.