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!
Row Generator stage in 9.1
Moderators: chulett, rschirm, roy
I believe you have discovered a bug. I tried at 8.7FP1 with seed 1 and limit 2013-01-01 and got
Same settings at 9.1FP1
You should submit this to your support provider.
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
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
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.