Forward data type mappings - Teradata example

When creating federated objects, you can use the sample forward type mapping provided for Teradata.

You need to create these mappings before you create a nickname or federated procedure.

CREATE TYPE MAPPING FROM LOCAL TYPE timestamp(0)
   TO SERVER TYPE teradata REMOTE TYPE timestamp(0);

CREATE TYPE MAPPING FROM LOCAL TYPE timestamp(1)
   TO SERVER TYPE teradata REMOTE TYPE timestamp(1);

CREATE TYPE MAPPING FROM LOCAL TYPE timestamp(2)
   TO SERVER TYPE teradata REMOTE TYPE timestamp(2);

CREATE TYPE MAPPING FROM LOCAL TYPE timestamp(3)
   TO SERVER TYPE teradata REMOTE TYPE timestamp(3);

CREATE TYPE MAPPING FROM LOCAL TYPE timestamp(4)
   TO SERVER TYPE teradata REMOTE TYPE timestamp(4);

CREATE TYPE MAPPING FROM LOCAL TYPE timestamp(5)
   TO SERVER TYPE teradata REMOTE TYPE timestamp(5);