Deleting the rows

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Aug 10, 2005 12:44 am

Why are you implementing this using DS and not any other way?

ray.wurlod · Post by **ray.wurlod** » Wed Aug 10, 2005 1:17 am

Provide the table name as a job parameter.
Run the job in multiple instances, one per table.

kool_cons · Post by **kool_cons** » Mon Aug 15, 2005 3:17 pm

Ray,
If no of tables to be deleted is less than 10 tables, you idea is acceptable. but i need to delete 80 tables minimum. i am thking that batch job is good idea which can pass table names as parameters. but i dont know how to write a code/job control in job properties. if you guys have any sample code for basic programming,that would be great.

chulett · Post by **chulett** » Mon Aug 15, 2005 3:27 pm

Why not just write a sql script to do this? Not every nail has to be whacked with the DataStage job hammer.

kool_cons · Post by **kool_cons** » Mon Aug 15, 2005 3:35 pm

i dont want to go with sql since my manager dont like this. So i need an approch with datastage job only.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 16, 2005 2:27 am

Learn to write the job control code, or hire someone with the skill. It's not a big ask. The main design specification will be how the list of table names is to be delivered.