Job design to do table maintenance task

jeisma · Post by **jeisma** » Thu Jun 01, 2017 3:14 pm

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!

PaulVL · Post by **PaulVL** » Thu Jun 01, 2017 3:24 pm

If it works, I would not change it.

jeisma · Post by **jeisma** » Thu Jun 01, 2017 3:28 pm

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.

chulett · Post by **chulett** » Thu Jun 01, 2017 4:59 pm

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...

jeisma · Post by **jeisma** » Fri Jun 02, 2017 8:30 am

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.

chulett · Post by **chulett** » Fri Jun 02, 2017 8:49 am

"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.

jeisma · Post by **jeisma** » Fri Jun 02, 2017 8:53 am

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

thank you for your inputs.