Rules for Handling Decimal Data - Parallel Transporter

The following rules apply to the ODBC Operator running on z/OS, UNIX, and Windows platforms, when taking DECIMAL data from a non-database system (such as Oracle) and moving it to a database system.

• If the precision values between the source and target tables are not equal, the data will be checked at runtime. If the data does not fit, the job will be terminated.
• If the scale factors do not match, one of the following will happen:
  • If the source scale factor is less than the target, then Teradata PT will add 0s (zeros) to the end of the source scale factor until they do match, and then the job will continue.

    or,

  • If the source scale factor is greater than the target, the job will terminate before attempting to process the data, due to possible loss of data.
• For source column NUMBER (m, n) and target column DECIMAL (M, N), the job will do the following:
  • Terminate with error if n>N
  • Run if n<N or n=N
  • Run if m≤M, assuming n<N or n=N
  • Attempt to run if m>M, assuming n<N or n=N