FedSQL Statement Table Options by Data Source

The following table lists the table options that are supported in FedSQL programs by the data source that supports them. The options are listed alphabetically for each data source.
List of Supported Table Options by Data Source
Data Source
Language Element
Category
Description
Aster
Table control
Specifies the column name to use as the partition key for creating fact tables.
DB2 under UNIX and PC
Bulk loading
Specifies that the original table data is still visible to readers during bulk load.
Bulk loading
Specifies the directory to which DB2 saves a copy of the loaded data.
Bulk loading
Specifies the number of processes or threads to use when building table objects.
Bulk loading
Specifies the total amount of memory to allocate for the bulk load utility to use as a buffer for transferring data.
Bulk loading
Specifies the number of processes or threads to use when writing data to disk.
Bulk loading
Specifies the exception table into which rows in error are copied.
Bulk loading
Specifies which scheme the DB2 load utility should use for index maintenance.
Bulk loading
Specifies whether DB2 appends or replaces rows during bulk loading.
Bulk loading
Identifies a log file that contains information such as statistics and error information for a bulk load.
Bulk loading
Passes options to the DBMS bulk load facility, affecting how it loads and processes data.
Bulk loading
Sets the highest available port number for concurrent uploads.
Bulk loading
Sets the lowest available port number for concurrent uploads.
Bulk loading
Specifies whether the LOAD process is recoverable.
Bulk loading
Specifies the base filename and location of DB2 LOAD temporary files.
Bulk loading
Specifies the maximum number of row warnings to allow before the load fails.
Bulk loading
Loads rows of data as one unit.
Bulk loading
Container for bulk load options. This option must follow BULKLOAD=YES.
Table control
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement.
Greenplum
Table control
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement.
Table control
Specifies the distribution key for the table being created.
HAWQ
Table control
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement.
Table control
Specifies the distribution key for the table being created.
Hive
Table control
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement.
Impala
Bulk loading
Loads rows of data as one unit.
Bulk loading
Provides a container for bulk load options.
Bulk loading
Specifies a file or path name for Hadoop configuration path resolution.
Bulk loading
Specifies an alternate name and location for the temporary HDFS file.
Bulk loading
Specifies the password for the HDFS user.
Bulk loading
Specifies the picklist to use for the bulk-loading operation.
Bulk loading
Specifies the HDFS user name.
MDS
Bulk loading
Loads rows of data as one unit.
MySQL
Table control
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement.
Netezza
Table control
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement.
ODBC
Index control
Specifies DBMS-specific syntax to be added to the CREATE INDEX statement.
Oracle
Bulk loading
Specifies where bulk load creates all intermediate files.
Bulk loading
Specifies that after the indicated number of errors is received, that the load should stop.
Bulk loading
Specifies that after the indicated number of rows is loaded, that the load should stop.
Bulk loading
Specifies the filename for the bulk load log file.
Bulk loading
Specifies whether to perform a parallel bulk load.
Bulk loading
Determines whether the LOAD process is recoverable.
Bulk loading
Specifies to skip the indicated number of rows before starting the bulk load.
Bulk loading
Specifies whether to perform index maintenance on the bulk load.
Bulk loading
Specifies whether to skip index entries that are in an unusable state and continue with the bulk load.
Bulk loading
Loads rows of data as one unit.
Bulk loading
Container for bulk load options. This option must follow BULKLOAD=YES.
Table control
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement.
Data control
Specifies Oracle hints to pass to Oracle from FedSQL.
Table control
Specifies how numbers read from or inserted into the Oracle NUMBER column will be treated.
SAP HANA
Table control
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement.
Data access
Specifies the type of table storage FedSQL will use when creating tables in SAP HANA.
SAS data set
Table control
Assigns an ALTER password to a SAS data set that prevents users from replacing or deleting the file, and enables access to a read- or write-protected file.
Table control
Specifies the number of buffers to be allocated for processing a SAS data set.
Table control
Specifies the size of a permanent buffer page for an output SAS data set.
Table control
Specifies how rows are compressed in a new output data set.
Table control
Specifies the encoding to use when creating a SAS data set.
Table control
Specifies whether to encrypt an output SAS data set.
Table control
Specifies a key value for AES encryption.
Table control
Specifies whether to extend the maximum observation count in a new output SAS data file.
User control of index usage
Directs SAS to use a specific index to match the conditions of a WHERE clause.
User control of index usage
Specifies whether SAS uses an index search or a sequential search to match the conditions of a WHERE clause.
Observation control
Specifies a label for a SAS data set.
Table control
Places shared or exclusive locks on tables.
Table control
Specifies whether SAS creates compressed data sets whose observations can be randomly accessed or sequentially accessed.
Table control
Assigns a READ, WRITE, and ALTER password to a SAS data set, and enables access to a password-protected file.
Table control
Assigns a READ password to a SAS data set that prevents users from reading the file, unless they enter the password.
Table control
Specifies whether new rows can be written to freed space in a compressed SAS data set.
Table control
Specifies the data set type for a specially structured SAS data set.
Table control
Assigns a WRITE password to a SAS data set or an SPD data set that prevents users from writing to the file or that enables access to a write-protected file.
SASHDAT file
Table control
Specifies the size of a SASHDAT file block in bytes, kilobytes, megabytes, or gigabytes.
Table control
Specifies how many copies are made when file blocks are written to HDFS.
Table control
Indicates that the distribution properties of the partitions depends on a hash function.
Table control
Specifies a label for a SASHDAT file.
Table control
Specifies the columns by which to order the data within a partition.
Table control
Specifies the list of columns to use to partition the SASHDAT file.
Security
Specifies the permission setting when writing a SASHDAT file to HDFS.
File control
Specifies to write the SASHDAT file in a compressed format.
Table control
Specifies to use UCA collation to order character variables in the ORDERBY= option.
SPD Engine data set
Table control
Assigns an ALTER password to an SPD Engine data set that prevents users from replacing or deleting the file, and enables access to a read- or write-protected file.
User control of index usage
Specifies to create indexes in parallel when creating multiple indexes on an SPD Engine data set.
Table control
Specifies to compress SPD Engine data sets on disk as they are being created.
Table control
Specifies whether to encrypt an output SPD Engine data set.
Table control
Specifies a key value for AES encryption.
Observation control
Specifies the end observation number in a user-defined range of observations to be processed.
User control of index usage
Specifies to use indexes when processing WHERE expressions in the SPD Engine.
Table control
Specifies the size in bytes of a block of observations to be used in an I/O operation.
Observation control
Specifies a label for an SPD Engine data set.
Table control
Specifies the number of bytes to add to compressed blocks in a data set opened for OUTPUT or UPDATE.
Table control
Specifies the size of the data component partitions in an SPD Engine data set.
Table control
Assigns a READ, WRITE, and ALTER password to a SAS data set, and enables access to a password-protected file.
Table control
Assigns a READ password to a SAS data set that prevents users from reading the file, unless they enter the password.
Observation control
Specifies the starting observation number in a user-defined range of observations to be processed.
Table control
Specifies the maximum number of I/O threads the SPD Engine can spawn for processing an SPD Engine data set.
Table control
Specifies the data set type for a specially structured SPD Engine data set.
User control of index usage
Specifies to save observations with nonunique key values (the rejected observations) to a separate data set when appending or inserting observations to data sets with unique indexes.
User control of index usage
Specifies a list of indexes to exclude when making WHERE expression evaluations.
Table control
Assigns a WRITE password to an SPD Engine data set that prevents users from writing to the file or that enables access to a write-protected file.
SPD Server table
Table control
Specifies to compress SPD Server tables on disk as they are being created.
Table access
Enables you to access an SPD Server table that is protected by AES encryption.
Observation control
Specifies the end observation number in a user-defined range of observations to be processed.
Table control
Specifies the size in bytes of a block of rows to be used in an I/O operation.
Table control
Specifies the size of the data component partitions in an SPD Server table.
Table access
Enables you to access an SPD Server table that is protected by SAS Proprietary encryption.
Observation control
Specifies the starting observation number in a user-defined range of observations to be processed.
Teradata
Bulk loading
Loads rows of data as one unit.
Bulk loading
Container for bulk load options. This option must follow BULKLOAD=YES.
Table control
Specifies DBMS-specific syntax to be added to the CREATE TABLE statement.
Bulk loading
Specifies whether the LOAD method is used.
Bulk loading
Specifies when the TPT operation issues a checkpoint or savepoint to the database.
Bulk loading
Activates data encryption.
Bulk loading
Drops the log table at the end of the job, whether the job completed successfully or not.
Bulk loading
Drops the error tables at the end of the job, whether the job completed successfully or not.
Bulk loading
Drops the work table at the end of the job, whether the job completed successfully or not.
Bulk loading
Specifies the maximum number of records that can be stored in an error table.
Bulk loading
Specifies a name for the first error table.
Bulk loading
Specifies a name for the second error table.
Bulk loading
Specifies the name of the restart log table.
Bulk loading
Specifies the logon mechanism for a bulk load.
Bulk loading
Specifies additional data for the logon mechanism.
Bulk loading
Specifies the database where the TPT utility tables are created.
Bulk loading
Specifies the maximum number of logon sessions that TPT can acquire for a job.
Bulk loading
Specifies the minimum number of sessions for TPT to acquire before a job starts.
Bulk loading
Specifies the level at which log events are recorded.
Bulk loading
Specifies the method for reporting events.
Bulk loading
Defines a string that precedes all messages sent to the system log.
Bulk loading
Specifies the number of statements to pack into a multistatement request.
Bulk loading
Enables the Stream operator to determine the maximum possible pack factor for the current Stream job.
Bulk loading
Forces a pause between the acquisition phase and the application phase of a load job.
Bulk loading
Passes a string of user-specified name=value pairs for use by the TPT session.
Bulk loading
Specifies the amount of time the TPT operator continues trying to log on to the Teradata database.
Bulk loading
Specifies the amount of time the TPT operator pauses, before retrying to log on to the Teradata database.
Bulk loading
Specifies the load operator used by the Teradata Parallel Transporter.
Bulk loading
Specify the trace levels for driver tracing. TD_TRACE_LEVEL sets the primary trace level. TD_TRACE_LEVEL_INF sets the secondary trace level.
Bulk loading
Specifies the name of the external file used for trace messages.
Bulk loading
Specifies the database where the table is to be created.
Bulk loading
Specifies a name for the TPT work table.
Last updated: February 23, 2017