Search found 38 matches
- Thu Apr 06, 2006 11:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Compilation Error
- Replies: 6
- Views: 1954
- Thu Apr 06, 2006 10:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Compilation Error
- Replies: 6
- Views: 1954
Compilation Error
Compiling: Source = 'RT_BP1531/JOB.1647055971.DT.1397645304.TRANS1', Object = 'RT_BP1531.O/JOB.1647055971.DT.1397645304.TRANS1' **************************************************************************************************************************************************** Compilation Complete. (...
- Fri Feb 17, 2006 12:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date check for business validation
- Replies: 14
- Views: 7680
Re: Date Check
kcs, I like your suggestion, but if you stick with DW conversion and an integer you can make your logic simpler, this assumes you will make your order go to the Friday before a weekend, see: StageVar "DW" = OCONV(Date()+30,'DW') StageVar "DWCorrection" = IF DW >5 THEN DW-5 ELSE ...
- Wed Feb 15, 2006 4:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generate Dates between 2 Dates
- Replies: 3
- Views: 1288
Re: Generate Dates between 2 Dates
If your main requirement is to find out the number of days between any two given days . I would say from your calendar table take in all the days starting from Day 1 determine whether its an holiday or a week end. If not then give it a count 1. then keep on incrementing this work day count according...
- Thu Nov 03, 2005 10:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: recursive Routine
- Replies: 3
- Views: 1604
Thank you ArndW, I am able compile it with out errorsArndW wrote:Your DEFFUN is fine, but a function returns a value, so needs to be part of an assignment statement. You need to specify a line like:
Code: Select all
Ans = GetWorkDayFromHash(HashTable,HashKey)
Thank you,
dsnovice
- Thu Nov 03, 2005 10:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: recursive Routine
- Replies: 3
- Views: 1604
recursive Routine
Hello All, For most of my querries I found the search button very useful but once in a while I meet with some problems that seem to be dead end with out a helping hand. I need to write a recursive function that looks up a hash table for a given key The routine has been defined as below RoutineName =...
- Tue Oct 04, 2005 3:05 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Transformaer creating Multiple files
- Replies: 3
- Views: 2290
Re: XML Transformaer creating Multiple files
Raj, were you able to resolve this error, as I am also getting the same error. please any clues or advise on this will be of great help.rkumar28 wrote:HI Guys...Any Input on this one....
Thanks
Raj
Thank you,
novice
- Tue Jul 05, 2005 6:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: HOW TO GIVE NOT EQUAL CONDITION IN LOOKUP
- Replies: 5
- Views: 4189