You could store values like this in a parameter table, the use my Jobs and routines to integrate a parameter table into a sequence tool. This will allow you to save the date at the end of a successful run, and retrieve it at the beginning of the next run.
You will find this and other tools on the DataStage Tools page of www.anotheritco.com .
how to pass last run date to a source query to incremental
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Chuck Smith
www.anotheritco.com
www.anotheritco.com