Data Rule Definition like 'Date1 < Date2+Period'

graja83 · Post by **graja83** » Fri Nov 19, 2010 3:41 am

I have the requirement to define the rule definition like

Date1 < Date2 + Period

Date1- date datatype
Date2- date datatype
Period- decima data type

date1 values like:
1984-02-29
1981-07-15
1981-01-02
1976-08-26

date2 values like:
2023-02-28
2017-07-15
2018-01-02
2020-08-26

Period values like:
10.00
20.00

Please help me anybody have the idea on this.

ArndW · Post by **ArndW** » Fri Nov 19, 2010 4:28 am

What does "Period" mean? Does a "10" mean 10 days, 10 years, 10 months or something else?

ray.wurlod · Post by **ray.wurlod** » Fri Nov 19, 2010 4:33 am

Enterprise MVS Edition does not have an Information Analyzer equivalent.

ArndW · Post by **ArndW** » Fri Nov 19, 2010 8:14 am

I just realized that this was a IA question, not a normal DataStage job question. I should, but won't, redact my earlier post. Sorry.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 19, 2010 2:23 pm

Arnd's question is still relevant, assuming you really do have Information Analyzer. Without an answer to it, it's really impossibly to advise.

But it would be better to have the edition properly identified. It's not 390.

graja83 · Post by **graja83** » Tue Nov 23, 2010 3:19 am

ArndW wrote:What does "Period" mean? Does a "10" mean 10 days, 10 years, 10 months or something else? ...

present its take as 10days