Search found 38 matches

by dsnovice
Thu Apr 06, 2006 11:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation Error
Replies: 6
Views: 1954

Actually It never let me compile it. How ever when I logged out of the Designer and Logged back in and tried compilinng it. I was able to compile it. I dont get that error. I belive this error might have got triggered when I initialy tried doing Trim(Change(Iconv("string","MCP"),...
by dsnovice
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. (...
by dsnovice
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 ...
by dsnovice
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...
by dsnovice
Thu Nov 03, 2005 10:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: recursive Routine
Replies: 3
Views: 1604

ArndW 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 ArndW, I am able compile it with out errors

Thank you,

dsnovice
by 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 =...
by dsnovice
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

rkumar28 wrote:HI Guys...Any Input on this one....

Thanks
Raj
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.

Thank you,

novice
by dsnovice
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

Can you use ISNOTFOUND(LINKNAME) to satisfy this condition?

Thank you,