I'd like to help, but please clarify the following:
1. Is there a system date in every record in your Teradata data?
2. Is there a creation date in every record in your comparison data?
Thanks,
BP
System Date - Datastage PX
Moderators: chulett, rschirm, roy
Well, could you enter today's date into a parameter and check against it? Or perhaps you can enter today's date into an environment var?
Also, there's an APT function called today() that assigns the System Date to a field that is an APT_Date. You can use this function in the PX buildop stage. There's also a compare(APT_Date1, APT_Date2) function that can be used within buildop.
If you haven't already, you might want to check out using PX buildop in place of PX transform.
BP
Also, there's an APT function called today() that assigns the System Date to a field that is an APT_Date. You can use this function in the PX buildop stage. There's also a compare(APT_Date1, APT_Date2) function that can be used within buildop.
If you haven't already, you might want to check out using PX buildop in place of PX transform.
BP
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Server jobs generate DataStage BASIC code and, therefore, have available to them all of the DataStage BASIC system variables, such as @DATE, and DataStage BASIC functions.
Parallel jobs generate C code and, therefore, do not have DataStage BASIC system variables available to them. They have a rich set of functions available (see Parallel Job Developer's Guide) but these are not the same as the DataStage BASIC functions in server jobs, though there are overlaps.
Server jobs may be encapsulated in shared containers - subject to certain conditions - and incorporated into parallel jobs.
A paper on this will shortly be published on www.DataStageXChange.com.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Parallel jobs generate C code and, therefore, do not have DataStage BASIC system variables available to them. They have a rich set of functions available (see Parallel Job Developer's Guide) but these are not the same as the DataStage BASIC functions in server jobs, though there are overlaps.
Server jobs may be encapsulated in shared containers - subject to certain conditions - and incorporated into parallel jobs.
A paper on this will shortly be published on www.DataStageXChange.com.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518