List of Supported Table Options by Data Source
|
|
|
|
|
|
|
|
|
Specifies the column
name to use as the partition key for creating fact tables.
|
|
|
|
|
Specifies that the original
table data is still visible to readers during bulk load.
|
|
|
|
|
Specifies the directory
to which DB2 saves a copy of the loaded data.
|
|
|
|
|
Specifies the number
of processes or threads to use when building table objects.
|
|
|
|
|
Specifies the total
amount of memory to allocate for the bulk load utility to use as a
buffer for transferring data.
|
|
|
|
|
Specifies the number
of processes or threads to use when writing data to disk.
|
|
|
|
|
Specifies the exception
table into which rows in error are copied.
|
|
|
|
|
Specifies which scheme
the DB2 load utility should use for index maintenance.
|
|
|
|
|
Specifies whether DB2
appends or replaces rows during bulk loading.
|
|
|
|
|
Identifies a log file
that contains information such as statistics and error information
for a bulk load.
|
|
|
|
|
Passes options to the
DBMS bulk load facility, affecting how it loads and processes data.
|
|
|
|
|
Sets the highest available
port number for concurrent uploads.
|
|
|
|
|
Sets the lowest available
port number for concurrent uploads.
|
|
|
|
|
Specifies whether the
LOAD process is recoverable.
|
|
|
|
|
Specifies the base filename
and location of DB2 LOAD temporary files.
|
|
|
|
|
Specifies the maximum
number of row warnings to allow before the load fails.
|
|
|
|
|
Loads rows of data as
one unit.
|
|
|
|
|
Container for bulk load
options. This option must follow BULKLOAD=YES.
|
|
|
|
|
Specifies DBMS-specific
syntax to be added to the CREATE TABLE statement.
|
|
|
|
|
Specifies DBMS-specific
syntax to be added to the CREATE TABLE statement.
|
|
|
|
|
Specifies the distribution
key for the table being created.
|
|
|
|
|
Loads rows of data as
one unit.
|
|
|
|
|
Specifies DBMS-specific
syntax to be added to the CREATE TABLE statement.
|
|
|
|
|
Specifies DBMS-specific
syntax to be added to the CREATE TABLE statement.
|
|
|
|
|
Specifies DBMS-specific
syntax to be added to the CREATE INDEX statement.
|
|
|
|
|
Specifies where bulk
load creates all intermediate files.
|
|
|
|
|
Specifies that after
the indicated number of errors is received, that the load should stop.
|
|
|
|
|
Specifies that after
the indicated number of rows is loaded, that the load should stop.
|
|
|
|
|
Specifies the filename
for the bulk load log file.
|
|
|
|
|
Specifies whether to
perform a parallel bulk load.
|
|
|
|
|
Determines whether the
LOAD process is recoverable.
|
|
|
|
|
Specifies to skip the
indicated number of rows before starting the bulk load.
|
|
|
|
|
Specifies whether to
perform index maintenance on the bulk load.
|
|
|
|
|
Specifies whether to
skip index entries that are in an unusable state and continue with
the bulk load.
|
|
|
|
|
Loads rows of data as
one unit.
|
|
|
|
|
Container for bulk load
options. This option must follow BULKLOAD=YES.
|
|
|
|
|
Specifies DBMS-specific
syntax to be added to the CREATE TABLE statement.
|
|
|
|
|
Specifies Oracle hints
to pass to Oracle from FedSQL.
|
|
|
|
|
Specifies how numbers
read from or inserted into the Oracle NUMBER column will be treated.
|
|
|
|
|
Specifies DBMS-specific
syntax to be added to the CREATE TABLE statement.
|
|
|
|
|
Specifies the type of
table storage FedSQL will use when creating tables in SAP HANA.
|
|
|
|
|
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.
|
|
|
|
|
Specifies the number
of buffers to be allocated for processing a SAS data set.
|
|
|
|
|
Specifies the size of
a permanent buffer page for an output SAS data set.
|
|
|
|
|
Specifies how rows are
compressed in a new output data set.
|
|
|
|
|
Specifies whether to
encrypt an output SAS data set.
|
|
|
|
|
Specifies a key value
for AES encryption.
|
|
|
|
|
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.
|
|
|
|
|
Specifies a label for
a SAS data set.
|
|
|
|
|
Places shared or exclusive
locks on tables.
|
|
|
|
|
Specifies whether SAS
creates compressed data sets whose observations can be randomly accessed
or sequentially accessed.
|
|
|
|
|
Assigns a READ, WRITE,
and ALTER password to a SAS data set, and enables access to a password-protected
file.
|
|
|
|
|
Assigns a READ password
to a SAS data set that prevents users from reading the file, unless
they enter the password.
|
|
|
|
|
Specifies whether new
rows can be written to freed space in a compressed SAS data set.
|
|
|
|
|
Specifies the data set
type for a specially structured SAS data set.
|
|
|
|
|
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.
|
|
|
|
|
Specifies the size of
a SASHDAT file block in bytes, kilobytes, megabytes, or gigabytes.
|
|
|
|
|
Specifies how many copies
are made when file blocks are written to HDFS.
|
|
|
|
|
Indicates that the distribution
properties of the partitions depends on a hash function.
|
|
|
|
|
Specifies a label for
a SASHDAT file.
|
|
|
|
|
Specifies the columns
by which to order the data within a partition.
|
|
|
|
|
Specifies the list of
columns to use to partition the SASHDAT file.
|
|
|
|
|
Specifies the permission
setting when writing a SASHDAT file to HDFS.
|
|
|
|
|
Specifies to write the
SASHDAT file in a compressed format.
|
|
|
|
|
Specifies to use UCA
collation to order character variables in the ORDERBY= option.
|
|
|
|
|
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.
|
|
|
|
|
Specifies to compress
SPD Engine data sets on disk as they are being created.
|
|
|
|
|
Specifies whether to
encrypt an output SPD Engine data set.
|
|
|
|
|
Specifies a key value
for AES encryption.
|
|
|
|
|
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.
|
|
|
|
|
Specifies the size in
bytes of a block of observations to be used in an I/O operation.
|
|
|
|
|
Specifies a label for
an SPD Engine data set.
|
|
|
|
|
Specifies the number
of bytes to add to compressed blocks in a data set opened for OUTPUT
or UPDATE.
|
|
|
|
|
Specifies the size
of the data component partitions in an SPD Engine data set.
|
|
|
|
|
Assigns a READ, WRITE,
and ALTER password to a SAS data set, and enables access to a password-protected
file.
|
|
|
|
|
Assigns a READ password
to a SAS data set that prevents users from reading the file, unless
they enter the password.
|
|
|
|
|
Specifies the starting
observation number in a user-defined range of observations to be processed.
|
|
|
|
|
Specifies the maximum
number of I/O threads the SPD Engine can spawn for processing an SPD
Engine data set.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Loads rows of data as
one unit.
|
|
|
|
|
Container for bulk load
options. This option must follow BULKLOAD=YES.
|
|
|
|
|
Specifies DBMS-specific
syntax to be added to the CREATE TABLE statement.
|
|
|
|
|
Specifies whether the
LOAD method is used.
|
|
|
|
|
Specifies when the TPT
operation issues a checkpoint or savepoint to the database.
|
|
|
|
|
Activates data encryption.
|
|
|
|
|
Drops the log table
at the end of the job, whether the job completed successfully or not.
|
|
|
|
|
Drops the error tables
at the end of the job, whether the job completed successfully or not.
|
|
|
|
|
Drops the work table
at the end of the job, whether the job completed successfully or not.
|
|
|
|
|
Specifies the maximum
number of records that can be stored in an error table.
|
|
|
|
|
Specifies a name for
the first error table.
|
|
|
|
|
Specifies a name for
the second error table.
|
|
|
|
|
Specifies the name of
the restart log table.
|
|
|
|
|
Specifies the logon
mechanism for a bulk load.
|
|
|
|
|
Specifies additional
data for the logon mechanism.
|
|
|
|
|
Specifies the database
where the TPT utility tables are created.
|
|
|
|
|
Specifies the maximum
number of logon sessions that TPT can acquire for a job.
|
|
|
|
|
Specifies the minimum
number of sessions for TPT to acquire before a job starts.
|
|
|
|
|
Specifies the level
at which log events are recorded.
|
|
|
|
|
Specifies the method
for reporting events.
|
|
|
|
|
Defines a string that
precedes all messages sent to the system log.
|
|
|
|
|
Specifies the number
of statements to pack into a multistatement request.
|
|
|
|
|
Enables the Stream operator
to determine the maximum possible pack factor for the current Stream
job.
|
|
|
|
|
Forces a pause between
the acquisition phase and the application phase of a load job.
|
|
|
|
|
Passes a string of user-specified
name=value pairs for use by the TPT session.
|
|
|
|
|
Specifies the amount
of time the TPT operator continues trying to log on to the Teradata
database.
|
|
|
|
|
Specifies the amount
of time the TPT operator pauses, before retrying to log on to the
Teradata database.
|
|
|
|
|
Specifies the load operator
used by the Teradata Parallel Transporter.
|
|
|
|
|
Specify the trace levels
for driver tracing. TD_TRACE_LEVEL sets the primary trace level. TD_TRACE_LEVEL_INF
sets the secondary trace level.
|
|
|
|
|
Specifies the name of
the external file used for trace messages.
|
|
|
|
|
Specifies the database
where the table is to be created.
|
|
|
|
|
Specifies a name for
the TPT work table.
|