DSXchange

hi,

i needed a job to update records on the db. so i created

row_generator -> db2_connector

above works, but, how would you design the job differently?


TIA!

If it works, I would not change it.

ok. i must mention RG is creating one dummy record just to have an input to next stage. because it will not work having just db2 stage there by itself. this design just feels a little awkward.

Well, that's how you do it in a Parallel job when you just need to trigger an action in the database. In a Server job you would start from a Transformer, they can be re-jiggered to serve as a "row generator".

Are you doing something before/after SQL or some kind of "hard-coded" update? Wondering if this really needs to be a job...

there is no before/after sql. this job is actually part of a sequence. it's like preparing the table before the main job does it's thing.

"Preparing the table"?

If you're good, go ahead and mark this as resolved and I'll move along. I'm just morbidly curious at this point.

preparing, like updating old records before new ones come in.

thank you for your inputs.