create proxy_table

The create proxy_table command imports metadata from a remote server and converts column information into an internal create existing table command, with a column list derived from the imported metadata. When obtaining the column metadata, conversion from the remote DBMS type to internal Adaptive Server Enterprise types is required.

If the size of remote columns (char, varchar, binary or varbinary datatypes) exceeds 255 bytes but is still less than or equal to the maximum Adaptive Server Enterprise column size, then equivalent Adaptive Server Enterprise datatypes are used for the proxy table. However, if the size of a remote column exceeds the column size supported by Adaptive Server Enterprise, then CIS converts the corresponding proxy table column to text or image (as is the case with the current in-market implementation).