TIMESTAMP data type support

For the Db2® data source, remote timestamps map to TIMESTAMP(p), where p represents the precision and specifies the number of fractional seconds. The range of p is 0 to 12, inclusive.

For other data sources, remote timestamps map to TIMESTAMP with a default precision of 6. For these data sources, you can take advantage of TIMESTAMP(p) support by using mappings similar to the samples provided for default forward type mappings.

When a nickname TIMESTAMP column has a smaller precision than its corresponding remote table column, and the remote table column contains non-zero digits in the extra fractional digits, the result of predicates using that nickname column can be unpredictable. The result of predicates using that nickname column works correctly if the predicate is not pushed down.