Issue with Surrogate Key generator stage in 8.1 PX version

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
krishna.m
Premium Member
Premium Member
Posts: 4
Joined: Tue Apr 07, 2009 11:46 pm

Issue with Surrogate Key generator stage in 8.1 PX version

Post by krishna.m »

Hi All,

I have a problem in using surrogate key generator stage. I am using the "Source Type=Flat File". In the options i am selection the below.

File Block Size= User Specified
User Specified Block Size=1
File Initial Value=1080019000000000000

I am ending up with the below fatal error.

"When processing argument -start_valueWhen processing number: 1080019000000000000 is less than lower limit 1"

From the DS help i have learnt that the max value that can be generated is INT 64 i.e 9,223,372,036,854,775,807. The value that i am providing is way lesser than the max value. Please help me out in resolving this issue.
LS
Participant
Posts: 5
Joined: Tue Mar 15, 2011 3:48 pm
Location: Europe
Contact:

Re: Issue with Surrogate Key generator stage in 8.1 PX versi

Post by LS »

Hi krishna.m.

Are you running a 64bit machine? Also check your compiler options...

Have fun,
me.

[snip]
I'm just a Player, with no Section Leader.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

With the value 1080019000000000000 you have achieved a arithmetic underflow. Research the term "twos complement" to see why.
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