RowNumberColumn

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
G SHIVARANJANI
Participant
Posts: 137
Joined: Sun Jan 07, 2007 11:17 pm
Location: VISAKHAPATNAM

RowNumberColumn

Post by G SHIVARANJANI »

Hi,


How to initialise RowNumberColumn to 1 instead of the default value 0.

ThankU,
Shivaranjani
JoshGeorge
Participant
Posts: 612
Joined: Thu May 03, 2007 4:59 am
Location: Melbourne

Post by JoshGeorge »

Initialise in the 'edit metadata' option of that column.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
G SHIVARANJANI
Participant
Posts: 137
Joined: Sun Jan 07, 2007 11:17 pm
Location: VISAKHAPATNAM

Post by G SHIVARANJANI »

Hi,

I have tried putting start position and default value as 1 but it dint work out.It starts with 0...

and as i am taking this column as a key column for join, the join stage is giving an error saying: " partitioner requires a key column"

Note:i have put up hash partitioning with key as rowNumberColumn in join stage.
JoshGeorge wrote:Initialise in the 'edit metadata' option of that column.
Shivaranjani
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Everything in C starts from 0. Get used to it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply