Search found 3 matches

by arg_etl
Wed Nov 15, 2017 1:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: From Sybase to Netezza: decimal mark error
Replies: 4
Views: 3046

Solution

This issue is solved with the patch APAR JR58661.
Regards.
by arg_etl
Tue Aug 15, 2017 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: From Sybase to Netezza: decimal mark error
Replies: 4
Views: 3046

Thank you for your answer! Unfortunately, those are all set to period, and it still doesnt change.. You might also want to test Row Generator stage to Peek stage, to remove the database stages and the Sequential File stage as variables. Yeah,but for some reason the Row Gen doesn't generate decimals ...
by arg_etl
Mon Aug 14, 2017 2:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: From Sybase to Netezza: decimal mark error
Replies: 4
Views: 3046

From Sybase to Netezza: decimal mark error

We've found a problem when we tried to upload to Netezza the data that we got from Sybase, this issue arose specifically with the floating points data types. Then, we found out that the issue is not from any of the databases, but from datastage itself. The test that proves it is the Row Generator wh...