Job Options
Using the Large Decimal Teradata Database Feature
The Export operator optional attribute MaxDecimalDigits allows Teradata PT to use the Large Decimal functionality of the Teradata Database. But what if MaxDecimalDigits is set and the Teradata Database or the CLIv2 does not support this feature? Using the IgnoreMaxDecimalDigits attribute allows the Teradata PT job to continue. This attribute is available to the Export and SQL Selector operators.
Figure 14 shows the logic flow used to determine if the Teradata PT job will continue. The main decision points are:
The job will terminate with an Exit code of eight and an error message if IgnoreMaxDecimalDigits has not been set and either the Teradata Database or CLI levels do not support the Large Decimal feature.
If the Teradata Database and CLI versions do not support the Large Decimal feature and the IgnoreMaxDecimalDigits attribute is set, continue the job.
The Export and SQL Selector operators will continue the job when the Large Decimal feature in not supported because the maximum returned decimal digits is 18 which is in the valid range.