Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 484
  • Last Modified:

Numeric value - importing a decimal (20,4) as char and recasting

Hi,

   Whats the maximum precision of a numeric value that Netezza can handle.?I will be importing a char field that contains a decimal value (db2 decimal (20,4)). What would be the correct casting that is required in Netezza?


Thanks
0
LuckyLucks
Asked:
LuckyLucks
1 Solution
 
NetExpert_plCommented:
DECIMAL | DEC | NUMERIC | NUM

    specifies a fixed-point decimal number. The precision and scale of the number determines the position of the decimal point. The numbers to the right of the decimal point are the scale, and the scale cannot be negative or greater than the precision. The maximum precision is 38 digits.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now