Forward data type mappings - Sybase example

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

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

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

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