The CREATE EXTERNAL TABLE statement of SQL creates an operating system file that Extended Parallel Server can manipulate like a database table. XPS 8.51 introduces new syntax for the Table Options clause to support data migration between XPS and DB2, and between UNIX and Windows. This enhanced syntax also supports database server migration between XPS and DB2:
Data migration from an XPS database to DB2 database currently requires XPS users to perform two tasks before a DB2 database server can load the data:
For supported data types, this feature eliminates the second task by adding the 'DB2' keyword as a FORMAT option in the "Table Options" clause of CREATE EXTERNAL TABLE, so that data values from an XPS database can be loaded directly from an external table into a DB2 database.
Migration of data between an XPS database (on a UNIX or Linux platform) and a Windows database is currently inefficient because the same CREATE EXTERNAL TABLE statement restricts the length of record-end delimiters to a single byte. Windows expects a 2-byte (carriage-return, linefeed) sequence to separate consecutive records. This feature also extends the maximum size of the record-end delimiter to 128 bytes, in order to improve usability and performance in data migration between UNIX or Linux systems and Windows systems.
For more information about these syntax enhancements to the CREATE EXTERNAL TABLE statement, see Formatting External Tables for DB2 or Windows.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]