Yes,
Write a Job1 where you select the Table with the timestamps, than start your loadjob and give him the timestamp as parameter. In the where part of the reading select (suppose the Name of the Parameter is TimeAfter) you write Selectdate>#TimeAfter#. That is it.
If this doesn't work, maybe that the two timestamps don't fit to each other. Best than is to change them to string or so.
Wolfgang
Identifying incremental data
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
Here is some code that would be in your Job1 job:
hJob1 = DSAttachJob("LoadJob", DSJ.ERRFATAL)
ErrCode = DSSetParam(hJob1, "TimeAfter", TimeAfter)
The first argument to DSSetParam is the handle of the job.
The second argument is the parameter in the LoadJob job.
The third argument is the variable (or a parameter of Job1) that contains the date you want the TimeAfter parameter set to.
Hope this helps,
John
hJob1 = DSAttachJob("LoadJob", DSJ.ERRFATAL)
ErrCode = DSSetParam(hJob1, "TimeAfter", TimeAfter)
The first argument to DSSetParam is the handle of the job.
The second argument is the parameter in the LoadJob job.
The third argument is the variable (or a parameter of Job1) that contains the date you want the TimeAfter parameter set to.
Hope this helps,
John