DSXchange

Posted: **Wed Sep 25, 2013 8:35 am**

Hello,

I am working in DataStage v9.1 Fix Pack 2 and am using the Row Generator stage to generate a Date data type. I open the extended column properties and set a generation option of random and a limit option of some date (for example 2013-01-01).

The stage generates random dates but doesn't apply the limit filter. The data I am getting is like this:

Date
9562-12-03
8390-02-22
8107-03-22
...

I signed into a v8.7 FP2 environment and noticed that there is no problem applying a limit to the generation date.

Does anyone have an idea of why I can't limit the generated data.

Thanks!

Posted: **Wed Sep 25, 2013 8:44 am**

I believe you have discovered a bug. I tried at 8.7FP1 with seed 1 and limit 2013-01-01 and got

Code: Select all

Peek_3,0: test:1960-05-19
Peek_3,0: test:1960-05-12
Peek_3,0: test:1962-06-25
Peek_3,0: test:1963-07-04
Peek_3,0: test:1964-07-10
Peek_3,0: test:1963-08-02
Peek_3,0: test:1961-01-26
Peek_3,0: test:1964-02-03

Same settings at 9.1FP1

Code: Select all

Peek_3,0: test:8684-08-30
Peek_3,0: test:2876-04-04
Peek_3,0: test:6864-01-09
Peek_3,0: test:6669-10-05
Peek_3,0: test:5851-12-02
Peek_3,0: test:3697-04-19
Peek_3,0: test:2762-03-08
Peek_3,0: test:6147-02-25

You should submit this to your support provider.

Posted: **Wed Sep 25, 2013 8:59 am**

Good thing I installed both those fix packs.

Thanks for the help!

Posted: **Wed Sep 25, 2013 9:23 am**

Just think of it as your contribution to Fix Pack 3!

Posted: **Wed Sep 25, 2013 12:40 pm**

The Limit property is not a date. It is a number of days since the beginning of your chosen epoch. Try (for example) using an Epoch of 1990-01-01 and a Limit of 20000.

Posted: **Wed Sep 25, 2013 1:54 pm**

Ray,

I tried your approach and got the same results. The Epoch option is definitely working in the Row Generator stage but no matter which value I set for the limit, it doesn't apply. Whether the Limit value is 20 or 20000, the stage generates the same values.

Thanks for pointing out that the Limit option isn't a date. I logged into my 8.7 environment and noticed this.

DSXchange

Row Generator stage in 9.1

Row Generator stage in 9.1