When extracting NUMBER(m,n), the target column can be defines as NUMBER (M,N).
The following conditions still hold in the Teradata PT job for the values m and n.
A Teradata PT job:
- Terminates with error if n>N
- Runs if n<N or n=N
- Runs if m<=M, assuming n<M or n=N
- Attempts to run if m>M, assuming n<N or n=N