Warning for Implicit conversion "uint64" to "

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
Novak
Participant
Posts: 97
Joined: Mon May 21, 2007 10:08 pm
Location: Australia

Warning for Implicit conversion "uint64" to "

Post by Novak »

Hi,

Can anyone help with the warning raised in Surrogate Key Generator. The warning is 'Implicit conversion from source type "uint64" to result type "int64": Possible range limitation.' . This happens for all of our jobs using this stage.
We want the message handler to be our last option.

Sequence Source type within SK stage is Oracle database.

Regards,

Novak
Ravi.K
Participant
Posts: 209
Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore

Post by Ravi.K »

Define the attribute as Unsigned integer at Target. You can define the Unsigned integer at extended option of columns tab.
Cheers
Ravi K
Novak
Participant
Posts: 97
Joined: Mon May 21, 2007 10:08 pm
Location: Australia

Post by Novak »

Hi,

There is no such thing as 'extended option' under output tab in Surrogate Key stage.

Regards,

Novak
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

It is located in the Columns grid of the Output link of the stage.

Output->Columns->Extended column

Alternately, you can double-click on the column number (to the left of the column name) to open the properties for that column. There is an Extended (unsigned) checkbox on the left of the window.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
Novak
Participant
Posts: 97
Joined: Mon May 21, 2007 10:08 pm
Location: Australia

Post by Novak »

Thanks a lot Ravi and James.
Issue fixed.

Regards,

Novak
Post Reply