Column generator for dates

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
wfis
Premium Member
Premium Member
Posts: 70
Joined: Wed Feb 28, 2007 2:38 am
Location: India

Column generator for dates

Post by wfis »

Hi,

We are trying to use Column generator stage to generate two dates in a column as following

Column1
________
2009-08-04
2009-08-05
2009-08-04
2009-08-05
2009-08-04
2009-08-05
2009-08-04
2009-08-05


I have used the following setting in teh Edit row option
Type: Cycle
Inital Value: 2009-08-04
Limit: 2009-08-05

But the output gives some default dates like
1960-02-03
1960-02-04
1960-02-06
1960-02-05
1960-02-09
1960-02-01
1960-02-08
1960-02-07

Thank you.
WFIS
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The Epoch property sets the earliest date to be used.

It defaults to 1960-01-01.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
wfis
Premium Member
Premium Member
Posts: 70
Joined: Wed Feb 28, 2007 2:38 am
Location: India

Post by wfis »

I set the Epoch value to 2000-01-01 with Initial Value: 2009-08-04 and Limit: 2009-08-05.


This i receive the following dates
2005-07-02
2005-07-02
2005-07-02
2005-07-02
2005-07-02
2005-07-02
2005-07-02

Any other option missing?

I even tried giving Epoch to 2009-08-04 it does not work.

Thank you
WFIS
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Have you left increment at 0 ?

Can you generate random dates in your epoch?

Also try not having an initial value - after all, the Epoch property does that.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
deployDS
Premium Member
Premium Member
Posts: 45
Joined: Thu Mar 09, 2006 9:36 am

Post by deployDS »

You can try with the following options:

Epoch: 2009-08-04
Type: Cycle
Increment: 1
Limit: 1
Post Reply