Understanding BULKLOAD Table Options

Table options that are related to bulk loading are available only when the FedSQL language processes the call, as opposed to when the driver uses the native SQL language. The FedSQL language processor is used over native SQL to process requests that create tables or insert data from multiple data sources. In order for the table options to be enforced, the data source that supports them must be specified in the CREATE TABLE or INSERT INTO part of the query. The FedSQL language processor is also used to process CREATE TABLE and INSERT statements for a single data source when the requests specify a SAS function.