Table Options Listed by Category
Bulk Loading
|
Name
|
Syntax and Description
|
|---|---|
|
BL_ALLOW_READ_ACCESS= YES | NO
Specifies that the original table data is still
visible to readers during bulk load.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_ALLOW_READ_ACCESS= YES | NO
Specifies that the original table data is still
visible to readers during bulk load.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_COPY_LOCATION= pathname
Specifies the directory to which DB2 saves a copy
of the loaded data.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_COPY_LOCATION= pathname
Specifies the directory to which DB2 saves a copy
of the loaded data.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_CPU_PARALLELISM= number-of-processes-or-threads
Specifies the number of processes or threads to
use when building table objects.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_CPU_PARALLELISM= number-of-processes-or-threads
Specifies the number of processes or threads to
use when building table objects.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_DATA_BUFFER_SIZE= buffer-size
Specifies the total amount of memory to allocate
for the bulk load utility to use as a buffer for transferring data.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_DATA_BUFFER_SIZE= buffer-size
Specifies the total amount of memory to allocate
for the bulk load utility to use as a buffer for transferring data.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_DEFAULT_DIR= host-specific-directory-path
Specifies the location where bulk load creates all
intermediate files.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_DEFAULT_DIR= host-specific-directory-path
Specifies the location where bulk load creates all
intermediate files.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_DISK_PARALLELISM= number-of-processes-or-threads
Specifies the number of processes or threads to
use when writing data to disk.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_DISK_PARALLELISM= number-of-processes-or-threads
Specifies the number of processes or threads to
use when writing data to disk.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_ERRORS= number
Specifies that, after the indicated number of errors
is received, the load should stop.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_ERRORS= number
Specifies that, after the indicated number of errors
is received, the load should stop.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_EXCEPTION= exception-table-name
Specifies the exception table into which rows in
error are copied.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_EXCEPTION= exception-table-name
Specifies the exception table into which rows in
error are copied.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_INDEXING_MODE= AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED
Specifies which scheme the DB2 load utility should
use for index maintenance.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_INDEXING_MODE= AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED
Specifies which scheme the DB2 load utility should
use for index maintenance.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_LOAD= number-of-rows
Specifies that, after the indicated number of rows
is loaded, the load should stop.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_LOAD= number-of-rows
Specifies that, after the indicated number of rows
is loaded, the load should stop.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_LOAD_REPLACE= NO | YES
Specifies whether DB2 appends or replaces rows during
bulk loading.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_LOAD_REPLACE= NO | YES
Specifies whether DB2 appends or replaces rows during
bulk loading.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_LOG= "path-and-log-file-name"
Identifies a log file that contains information
such as statistics and error information for a bulk load.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_LOG= "path-and-log-file-name"
Identifies a log file that contains information
such as statistics and error information for a bulk load.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_LOGFILE= 'log-file-name'
Specifies the filename for the bulk load log file.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_LOGFILE= 'log-file-name'
Specifies the filename for the bulk load log file.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_OPTIONS= 'option [,
…option ] '
Passes options to the DBMS bulk load facility, affecting
how it loads and processes data.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_OPTIONS= 'option [,
…option ] '
Passes options to the DBMS bulk load facility, affecting
how it loads and processes data.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_PARALLEL= YES | NO
Specifies whether to perform a parallel bulk load.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_PARALLEL= YES | NO
Specifies whether to perform a parallel bulk load.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_PORT_MAX= integer
Sets the highest available port number for concurrent
uploads.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_PORT_MAX= integer
Sets the highest available port number for concurrent
uploads.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_PORT_MIN= integer
Sets the lowest available port number for concurrent
uploads.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_PORT_MIN= integer
Sets the lowest available port number for concurrent
uploads.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_RECOVERABLE= YES | NO
Specifies whether the LOAD process is recoverable.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_RECOVERABLE= YES | NO
Specifies whether the LOAD process is recoverable.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_REMOTE_FILE= pathname-and-base-filename
Specifies the base filename and location of DB2
LOAD temporary files.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_REMOTE_FILE= pathname-and-base-filename
Specifies the base filename and location of DB2
LOAD temporary files.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_SKIP= number-of-rows
Specifies to skip the indicated number of rows before
starting the bulk load.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_SKIP= number-of-rows
Specifies to skip the indicated number of rows before
starting the bulk load.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_SKIP_INDEX_MAINTENANCE= YES | NO
Specifies whether to perform index maintenance on
the bulk load.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_SKIP_INDEX_MAINTENANCE= YES | NO
Specifies whether to perform index maintenance on
the bulk load.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_SKIP_UNUSABLE_INDEXES= YES | NO
Specifies whether to skip index entries that are
in an unusable state and continue with the bulk load.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_SKIP_UNUSABLE_INDEXES= YES | NO
Specifies whether to skip index entries that are
in an unusable state and continue with the bulk load.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BL_WARNING_COUNT= number-of-warnings
Specifies the maximum number of row warnings to
allow before the load fails.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BL_WARNING_COUNT= number-of-warnings
Specifies the maximum number of row warnings to
allow before the load fails.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BULKLOAD= YES | NO
Determines whether SAS uses a DBMS facility to insert
data into a DBMS table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BULKLOAD= YES | NO
Determines whether SAS uses a DBMS facility to insert
data into a DBMS table.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BULKOPTS= (option[ ...option])
Provides a container for bulk-loading options.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BULKOPTS= (option[ ...option])
Provides a container for bulk-loading options.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
CONFIG="configuration-path"
Specifies a file or pathname for Hadoop configuration
path resolution.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
CONFIG="configuration-path"
Specifies a file or pathname for Hadoop configuration
path resolution.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
DATAFILE= "filename"
Specifies an alternate name and location for the
temporary HDFS file.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DATAFILE= "filename"
Specifies an alternate name and location for the
temporary HDFS file.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
PASSWORD="value"
Specifies the password for the HDFS user.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PASSWORD="value"
Specifies the password for the HDFS user.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
PICKLIST="filename"
Specifies the picklist to use for the bulk-loading
operation.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PICKLIST="filename"
Specifies the picklist to use for the bulk-loading
operation.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_BUFFER_MODE= YES | NO
Specifies whether the LOAD method is used.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_BUFFER_MODE= YES | NO
Specifies whether the LOAD method is used.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_CHECKPOINT= number
Specifies when the TPT operation issues a checkpoint
or savepoint to the database.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_CHECKPOINT= number
Specifies when the TPT operation issues a checkpoint
or savepoint to the database.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_DATA_ENCRYPTION= YES | NO
Activates data encryption.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_DATA_ENCRYPTION= YES | NO
Activates data encryption.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_DROP_ERROR_TABLE= YES | NO
Drops the log table at the end of the job, whether
the job was completed successfully or not.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_DROP_ERROR_TABLE= YES | NO
Drops the log table at the end of the job, whether
the job was completed successfully or not.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_DROP_LOG_TABLE= YES | NO
Drops the log table at the end of the job, whether
the job completed successfully or not.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_DROP_LOG_TABLE= YES | NO
Drops the log table at the end of the job, whether
the job completed successfully or not.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_DROP_WORK_TABLE= YES | NO
Drops the work table at the end of the job, whether
the job was completed successfully or not.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_DROP_WORK_TABLE= YES | NO
Drops the work table at the end of the job, whether
the job was completed successfully or not.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_ERROR_LIMIT= number-of-records
Specifies the maximum number of records that can
be stored in an error table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_ERROR_LIMIT= number-of-records
Specifies the maximum number of records that can
be stored in an error table.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_ERROR_TABLE_1= name-of-table
Specifies a name for the first error table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_ERROR_TABLE_1= name-of-table
Specifies a name for the first error table.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_ERROR_TABLE_2= name-of-table
Specifies a name for the second error table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_ERROR_TABLE_2= name-of-table
Specifies a name for the second error table.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_LOG_MECH_DATA="string"
Specifies additional data for the logon mechanism.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_LOG_MECH_DATA="string"
Specifies additional data for the logon mechanism.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_LOG_MECH_TYPE= mechanism
Specifies the logon mechanism for a bulk load.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_LOG_MECH_TYPE= mechanism
Specifies the logon mechanism for a bulk load.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_LOG_TABLE= name-of-table
Specifies the name of the restart log table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_LOG_TABLE= name-of-table
Specifies the name of the restart log table.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_LOGDB= database-name
Specifies the database where the TPT utility tables
are created.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_LOGDB= database-name
Specifies the database where the TPT utility tables
are created.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_MAX_SESSIONS= integer
Specifies the maximum number of logon sessions that
TPT can acquire for a job.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_MAX_SESSIONS= integer
Specifies the maximum number of logon sessions that
TPT can acquire for a job.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_MIN_SESSIONS= integer
Specifies the minimum number of sessions for TPT
to acquire before a job starts.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_MIN_SESSIONS= integer
Specifies the minimum number of sessions for TPT
to acquire before a job starts.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_NOTIFY_LEVEL= level
Specifies the level at which log events are recorded.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_NOTIFY_LEVEL= level
Specifies the level at which log events are recorded.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_NOTIFY_METHOD= method
Specifies the method for reporting events.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_NOTIFY_METHOD= method
Specifies the method for reporting events.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_NOTIFY_STRING= string
Defines a string that precedes all messages sent
to the system log.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_NOTIFY_STRING= string
Defines a string that precedes all messages sent
to the system log.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_PACK= number
Specifies the number of statements to pack into
a multistatement request.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_PACK= number
Specifies the number of statements to pack into
a multistatement request.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_PACK_MAXIMUM= YES | NO
Lets the Stream operator determine the pack factor
for the current Stream job.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_PACK_MAXIMUM= YES | NO
Lets the Stream operator determine the pack factor
for the current Stream job.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_PAUSE_ACQ= YES | NO
Forces a pause between the acquisition phase and
the application phase of a load job.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_PAUSE_ACQ= YES | NO
Forces a pause between the acquisition phase and
the application phase of a load job.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_SESSION_QUERY_BAND= string
Passes a string of user-specified name=value pairs
for use by the TPT session.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_SESSION_QUERY_BAND= string
Passes a string of user-specified name=value pairs
for use by the TPT session.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_TENACITY_HOURS= integer
Specifies the amount of time the TPT operator continues
trying to log on to the Teradata database.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_TENACITY_HOURS= integer
Specifies the amount of time the TPT operator continues
trying to log on to the Teradata database.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_TENACITY_SLEEP= integer
Specifies the amount of time the TPT operator pauses,
before retrying to log on to the Teradata database.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_TENACITY_SLEEP= integer
Specifies the amount of time the TPT operator pauses,
before retrying to log on to the Teradata database.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_TPT_OPER= operator
Specifies the load operator that is used by the
Teradata Parallel Transporter.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_TPT_OPER= operator
Specifies the load operator that is used by the
Teradata Parallel Transporter.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_TRACE_LEVEL= trace-level
Specifies the trace levels for driver tracing. TD_TRACE_LEVEL
sets the primary trace level. TD_TRACE_LEVEL_INF sets the secondary
trace level.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_TRACE_LEVEL= trace-level
Specifies the trace levels for driver tracing. TD_TRACE_LEVEL
sets the primary trace level. TD_TRACE_LEVEL_INF sets the secondary
trace level.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_TRACE_OUTPUT= filename
Specifies the name of the external file used for
trace messages.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_TRACE_OUTPUT= filename
Specifies the name of the external file used for
trace messages.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_UNICODE_PASSTHRU= YES | NO
Allows pass-through characters (PTCs) to be imported
into and exported from Teradata.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_UNICODE_PASSTHRU= YES | NO
Allows pass-through characters (PTCs) to be imported
into and exported from Teradata.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_WORK_TABLE= name-of-table
Specifies a name for the TPT Work table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_WORK_TABLE= name-of-table
Specifies a name for the TPT Work table.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TD_WORKING_DB= database-name
Specifies the database where the insert table is
to be created.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TD_WORKING_DB= database-name
Specifies the database where the insert table is
to be created.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
USER=HDFS-user
Specifies the HDFS user name.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
USER=HDFS-user
Specifies the HDFS user name.
Product: Base SAS
Document: SAS FedSQL Language Reference
|
Data Access
|
Name
|
Syntax and Description
|
|---|---|
|
TABLE_TYPE= [COLUMN | GLOBAL | GLOBAL TEMPORARY | LOCAL | LOCAL TEMPORARY | ROW]
Specifies the type of table storage FedSQL will
use when creating tables in SAP HANA.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
TABLE_TYPE= [COLUMN | GLOBAL | GLOBAL TEMPORARY | LOCAL | LOCAL TEMPORARY | ROW]
Specifies the type of table storage FedSQL will
use when creating tables in SAP HANA.
Product: Base SAS
Document: SAS FedSQL Language Reference
|
Data Control
|
Name
|
Syntax and Description
|
|---|---|
|
ORHINTS='/* Oracle-hint */'
Specifies Oracle hints to pass to Oracle from FedSQL.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
ORHINTS='/* Oracle-hint */'
Specifies Oracle hints to pass to Oracle from FedSQL.
Product: Base SAS
Document: SAS FedSQL Language Reference
|
Index Control
|
Name
|
Syntax and Description
|
|---|---|
|
DBCREATE_INDEX_OPTS= 'DBMS-SQL-clauses'
Allows DBMS-specific options to be added to the
CREATE INDEX statement.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DBCREATE_INDEX_OPTS= 'DBMS-SQL-clauses'
Allows DBMS-specific options to be added to the
CREATE INDEX statement.
Product: Base SAS
Document: SAS FedSQL Language Reference
|
Observation Control
|
Name
|
Syntax and Description
|
|---|---|
|
ENDOBS= n
Specifies the end observation number in a user-defined
range of observations to be processed.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
ENDOBS= n
Specifies the end observation number in a user-defined
range of observations to be processed.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
STARTOBS= n
Specifies the starting row number in a user-defined
range of rows to be processed.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
STARTOBS= n
Specifies the starting row number in a user-defined
range of rows to be processed.
Product: Base SAS
Document: SAS FedSQL Language Reference
|
Table Access
|
Name
|
Syntax and Description
|
|---|---|
|
KMS_PATH=”path-and-filename"
Specifies the location of a key file resource within
a project.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
LOCATION='value'
Specifies the location of the data set.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
READMODE=STANDARD | STORAGE
Specifies the method to use when moving data from
Google BigQuery into SAS.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
READMODE=STANDARD | STORAGE
Specifies the method to use when moving data from
Google BigQuery into SAS.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
SCANSTRINGCOLUMNS=NO | YES
Specifies whether to determine the maximum length
of character columns in a database table or a query.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
SCANSTRINGCOLUMNS=NO | YES
Specifies whether to determine the maximum length
of character columns in a database table or a query.
Product: Base SAS
Document: SAS FedSQL Language Reference
|
Table Control
|
Name
|
Syntax and Description
|
|---|---|
|
ALTER= alter-password
Assigns an ALTER password to a data set that prevents
users from replacing or deleting the file, and enables access to a
Read- or Write-protected file.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BUFNO= n | nK | hexX | MIN | MAX
Specifies the number of buffers to be allocated
for processing a SAS data set.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BUFNO= n | nK | hexX | MIN | MAX
Specifies the number of buffers to be allocated
for processing a SAS data set.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
BUFSIZE=n | nK | nM | nG | hexX | MIN | MAX
Specifies the size of a permanent buffer page for
an output SAS data set.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
BUFSIZE=n | nK | nM | nG | hexX | MIN | MAX
Specifies the size of a permanent buffer page for
an output SAS data set.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
COMPRESS=[TRUE | FALSE]
Specifies whether rows are compressed in a new output
CAS table.
Product: SAS Cloud Analytic Services
Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
| |
|
COMPRESS= NO | YES | CHAR | BINARY
Specifies how rows are compressed in a new output
data set or table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
COMPRESS= NO | YES | CHAR | BINARY
Specifies how rows are compressed in a new output
data set or table.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
DBCREATE_TABLE_OPTS= 'DBMS-SQL-clauses'
Allows database-specific options to be placed after
the CREATE TABLE statement in generated SQL code.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
ENCODING=encoding-value
Specifies the encoding to use when creating a SAS
data set.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
ENCRYPT= AES | AES2 | NO | YES
Specifies whether to encrypt an output SAS data
set.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
ENCRYPTKEY= [' | "]key-value [' | "]
Specifies a key value for AES and AES2 encryption.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
EXTENDOBSCOUNTER=YES | NO
Specifies whether to extend the maximum observation
count in a new output SAS data set.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
GP_DISTRIBUTED_BY= 'DISTRIBUTED
BY (column [, ...column])
| DISTRIBUTED RANDOMLY' Specifies the distribution key for the table being
created.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
GP_DISTRIBUTED_BY= 'DISTRIBUTED
BY (column [, ...column])
| DISTRIBUTED RANDOMLY' Specifies the distribution key for the table being
created.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
IOBLOCKSIZE= n
Specifies the number of rows in a block to be used
in an I/O operation.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
IOBLOCKSIZE= n
Specifies the number of rows in a block to be used
in an I/O operation.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
LABEL=[ ' | "]string[ ' | "]
Specifies a label for an output table.
Product: SAS Cloud Analytic Services
Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
| |
|
LABEL= 'label '
Specifies a label for a table.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
LOCKTABLE= EXCLUSIVE | SHARE
Places shared or exclusive locks on tables.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
ORNUMERIC=YES | NO
Specifies how numbers read from or inserted into
the Oracle NUMBER column are treated.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
ORNUMERIC=YES | NO
Specifies how numbers read from or inserted into
the Oracle NUMBER column are treated.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
PADCOMPRESS= n
Specifies the number of bytes to add to compressed
blocks in an SPD Engine data set that is opened for OUTPUT or UPDATE.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PADCOMPRESS= n
Specifies the number of bytes to add to compressed
blocks in an SPD Engine data set that is opened for OUTPUT or UPDATE.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
PARTSIZE= n
Specifies the size of the table partitions.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PARTSIZE= n
Specifies the size of the table partitions.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
POINTOBS= YES | NO
Specifies whether SAS creates compressed data sets
whose observations can be randomly accessed or sequentially accessed.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
POINTOBS= YES | NO
Specifies whether SAS creates compressed data sets
whose observations can be randomly accessed or sequentially accessed.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
POST_TABLE_OPTS="DBMS-SQL-options"
Allows database-specific options
to be placed after the table name in the DATA statement.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
POST_TABLE_OPTS="DBMS-SQL-options"
Allows database-specific options
to be placed after the table name in the CREATE TABLE statement.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
PRE_TABLE_OPTS="DBMS-SQL-options"
Allows database-specific options
to be placed before the table name in the DATA statement.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PRE_TABLE_OPTS="DBMS-SQL-options"
Allows database-specific options
to be placed before the table name in the CREATE TABLE statement.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
PW= password | key-value
Assigns a READ, WRITE, and ALTER password to a SAS
data set or an SPD Engine data set and enables access to the password-protected
file. Specifies a key value for accessing an encrypted SPD Server
table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
PW= password | key-value
Assigns a READ, WRITE, and ALTER password to a SAS
data set or an SPD Engine data set and enables access to the password-protected
file. Specifies a key value for accessing an encrypted SPD Server
table.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
READ= read-password
Assigns a READ password to a SAS file that prevents
users from reading the file, unless they enter the password.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
REPLACE=[TRUE | FALSE]
Specifies to internally delete an existing table
of the same name and create a replacement output table.
Product: SAS Cloud Analytic Services
Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
| |
|
REPLICATION= number
specifies the number of copies of the table to make
for fault tolerance.
Product: SAS Cloud Analytic Services
Document: SAS Viya Platform: FedSQL Programming for SAS Cloud Analytic Services
| |
|
REUSE= NO | YES
Specifies whether new rows can be written to freed
space in a compressed SAS data set.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
REUSE= NO | YES
Specifies whether new rows can be written to freed
space in a compressed SAS data set.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
THREADNUM= n
Specifies the maximum number of I/O threads the
SPD Engine can spawn for processing an SPD Engine data set.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
THREADNUM= n
Specifies the maximum number of I/O threads the
SPD Engine can spawn for processing an SPD Engine data set.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
TYPE= data-set-type
Specifies the data set type for a specially structured
SAS data set.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
WRITE= write-password
Assigns a WRITE password to a SAS file that prevents
users from writing to the file or that enables access to a Write-protected
file.
Product: Base SAS
Document: SAS FedSQL Language Reference
|
User Control of Index Usage
|
Name
|
Syntax and Description
|
|---|---|
|
ASYNCINDEX= YES | NO
Specifies to create indexes in parallel when creating
multiple indexes on an SPD Engine data set.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
ASYNCINDEX= YES | NO
Specifies to create indexes in parallel when creating
multiple indexes on an SPD Engine data set.
Product: Base SAS
Document: SAS FedSQL Language Reference
|
User Control of SAS Index Usage
|
Name
|
Syntax and Description
|
|---|---|
|
IDXNAME= index-name
Directs SAS to use a specific index to match the
conditions of a WHERE clause.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
IDXNAME= index-name
Directs SAS to use a specific index to match the
conditions of a WHERE clause.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
IDXWHERE= YES | NO
Specifies whether SAS uses an index search or a
sequential search to match the conditions of a WHERE clause.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
IDXWHERE= YES | NO
Specifies whether SAS uses an index search or a
sequential search to match the conditions of a WHERE clause.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
UNIQUESAVE= YES | NO
Specifies to save observations with nonunique key
values (the rejected observations) to a separate data set when inserting
observations into data sets with unique indexes.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
UNIQUESAVE= YES | NO
Specifies to save observations with nonunique key
values (the rejected observations) to a separate data set when inserting
observations into data sets with unique indexes.
Product: Base SAS
Document: SAS FedSQL Language Reference
| |
|
WHERENOINDEX= (name1 name2...)
Specifies a list of indexes to exclude when making
WHERE expression evaluations.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
WHERENOINDEX= (name1 name2...)
Specifies a list of indexes to exclude when making
WHERE expression evaluations.
Product: Base SAS
Document: SAS FedSQL Language Reference
|
Last updated: May 16, 2023