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!
Job design to do table maintenance task
Moderators: chulett, rschirm, roy
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...
Are you doing something before/after SQL or some kind of "hard-coded" update? Wondering if this really needs to be a job...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers