Dynamic Insert SQL Statement

[ray.wurlod]

Do their Rules require a hammer to fasten a screw? The idea here is to use the right tool for the task. In this case it's a sequence (and, preferably a server job to read the file).

You can update a values file of a parameter set directly, but you have to overwrite the entire file. You could do this with a job design that read from a values file, only changed it where the parameter name was the one you wanted to change, and wrote back to a file. Use before- and after-job subroutines to fiddle about with file names.

[joycerecacho]

Do their Rules require a hammer to fasten a screw? The idea here is to use the right tool for the task. In this case it's a sequence (and, preferably a server job to read the file).

You can update a values file of a parameter set directly, but you have to overwrite the entire file. You could do this with a job design that read from a values file, only changed it where the parameter name was the one you wanted to change, and wrote back to a file. Use before- and after-job subroutines to fiddle about with file names.

Hi everybody.
It looks great! I'll try this solution!!!


I have a doubt about your comment above. Why is it preferable to use Server job than Parallel for this solution?

Tk you so much.

Best Regards,

[ray.wurlod]

There's only one row to be processed by the job. Why start up a parallel job to process one row? Also, the interface to the user status area is much simpler in a server job.