create existing proxy table

The create existing table command also allows columns to be specified with a length of greater than 255 bytes. This allows CIS to treat columns in remote databases as char, varchar, binary or varbinary that previously had to be treated as text or image columns.

There is still an opportunity for column size mismatch errors. For example, in the case where the remote database contains a table with a column length of 5000 bytes, and the Adaptive Server Enterprise processing the create existing table command only supports columns up to 1900 bytes, a size mismatch error would occur. In this case, it is necessary to re-specify the column as a text or image column.

In the case where the proxy table column size exceeds that of the corresponding column in the remote table, a size mismatch error is detected and the command is aborted.