Migration of data between an XPS 8.50 database on a UNIX or Linux platform and a database on a platform that uses a Windows operating system is inefficient, because the CREATE EXTERNAL TABLE statement restricts the length of the record-delimiter specification to a single byte. Windows expects a 2-byte sequence (carriage-return, linefeed) to separate consecutive records, so the XPS user must insert into an external table the Cartesian product of all the carriage-return delimited UNIX rows of data with a table whose only column contains a single linefeed character, a relatively costly workaround.
This feature also extends the maximum length of the record-delimiter delimiter to 128 bytes, the same upper limit as for an SQL identifier, in order to improve usability and performance in data migration between UNIX or Linux and Windows operating system environments.
The Table Options clause of CREATE EXTERNAL TABLE now accepts a 'record-delimiter' specification longer than one byte, and enclosed between quotes, immediately following the RECORDEND keyword. See the Guide to SQL: Syntax for the complete syntax of the CREATE EXTERNAL TABLE statement.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]