Page 1 of 1
Info missing !
Posted: Tue Jan 10, 2006 10:38 pm
by antojj
Info missing !
Posted: Tue Jan 10, 2006 10:57 pm
by jzparad
Personally I would prefer to keep a database table that records at least the following information
Job start time
Job end time
Number of records extracted
You can then query this table for the max date prior to starting the next run. Storing information on a file on the operating system is risky and this gives you the added advantage of being able to track changes in record numbers and processing time.
Obviously this whole design is based on the assumption that all tables to be extracted will have a timestamp attribute.
Posted: Tue Jan 10, 2006 11:46 pm
by ray.wurlod
DataStage is not a report-writer.
Please don't ask for urgent help here - it causes offence. We are an all-volunteer site, who post (unpaid) when we can.
If you want urgent support, sign up for premium support from your service provider, and discover the true cost of "urgent".
Posted: Tue Jan 10, 2006 11:57 pm
by antojj
ray.wurlod wrote:DataStage is not a report-writer.
Please don't ask for urgent help here - it causes offence. We are an all-volunteer site, who post (unpaid) when we can.
If you want urgent support, sign up for premium support from your service provider, and discover the true cost of "urgent".
Ray,
I removed the post. In future this wont happen.
Regards,