Search found 3 matches
- Tue Dec 19, 2006 4:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Add 1.5 days or 36 hrs to input date.
- Replies: 2
- Views: 1745
Add 1.5 days or 36 hrs to input date.
I have to migrate SQL Server based DTS application to DataStage jobs. In DTS, Microsoft VB has DateAdd function. What is the right way to add 1.5 days to inputdate , say today, in DataStage to get future date? Does DataStage have the function to support this type of situation? Thank you in advance.
- Fri Aug 29, 2003 2:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: If data is new then insert else update
- Replies: 3
- Views: 1537
If data is new then insert else update
Hi, everyone especially ray wurlod. I have a situation to load data into a table. If data is new then insert else update. Currently the program uses the lookup table. Using select SQL, if there is no record return from target table, then insert. However, it will be very slow process. What is the bes...
- Mon Feb 24, 2003 12:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Incremental Table Transfer....
- Replies: 6
- Views: 2134