SQL Statement Syntax

Version 8.51 of Extended Parallel Server introduces enhancements to three SQL statements:

Table 14. SQL statements with new or enhanced syntax features
SQL Statement	Description
CREATE EXTERNAL TABLE	The Table Options clause of this statement supports two syntax enhancements: The FORMAT specification can be 'DB2' to specify the load format for DB2 database servers, simplifying data migration between XPS databases and DB2 databases. The RECORDEND specification can be a string longer than a single byte, simplifying data migration between XPS databases and databases on Windows systems. For more information about this feature, see Formatting External Tables for DB2 or Windows.
GRANT	This statement can specify the WITH GRANT OPTION keywords when access privileges are granted to roles. This enables DBAs who hold a role that received access privileges with this attribute can grant privileges of the role to others by specifying the name of the role in the AS clause of a subsequent GRANT statement. For more information about this feature, see Propagating Access Privileges Through Roles.
SET ENVIRONMENT	This statement supports three new session environment variables: DS_CLASS FORCE_DDL_EXEC USABLE_SPACES For more information about these features, see Configuration Parameters.

In these SQL statements, the DB2, DS_CLASS, FORCE_DDL_EXEC, and USABLE_SPACES keywords are new in Version 8.51 of Extended Parallel Server.