Table Options Listed by Product
Base SAS
|
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- and Write-protected file.
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 DS2 Language Reference
| |
|
BL_DELETE_DATAFILE=
YES | NO
Specifies whether to delete intermediate files created by the bulk loading
facility.
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 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 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 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 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 DS2 Language Reference
| |
|
DBCREATE_TABLE_OPTS= 'DBMS-options'
Specifies DBMS-specific options to be added to the
DATA statement.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
DROP= (column-list)
For an input table, excludes the specified columns
from processing; for an output table, excludes the specified columns
from being written to the table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
ENCRYPT==AES | AES2 | NO | YES
Specifies whether to encrypt an output SAS data
set.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
ENCRYPTKEY=key-value
Specifies a key value for AES encryption.
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 DS2 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
| |
|
FETCH_NUMERIC_TYPE=FLOAT64 | NUMERIC
Specifies how to handle NUMERIC data from Google BigQuery.
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
| |
|
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
| |
|
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
| |
|
IN=variable
Creates an integer variable that indicates whether
the table contributed data to the current row.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
INLINE
Specifies that the package or thread source code
is not saved to a table for reuse and is validated and compiled only
when loaded by a data program.
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 DS2 Language Reference
| |
|
KEEP=(column-list)
For an input table, specifies the columns to process;
for an output table, specifies the columns to write to the table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
LABEL='label'
Specifies a label for a table.
Product: Base SAS
Document: SAS DS2 Language Reference
| |
|
LOCKTABLE=SHARE | EXCLUSIVE
Places shared or exclusive locks on tables.
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 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 DS2 Language Reference
| |
|
OVERWRITE=YES | NO
For a table, drops the output table before the replacement
output table is populated with rows; for packages and threads, drops
the existing package or thread if a package or thread by the same
name exists.
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 DS2 Language Reference
| |
|
PARTSIZE=
n
Specifies the size of the table partitions.
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 DS2 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
| |
|
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
| |
|
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
| |
|
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 DS2 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
| |
|
RENAME=(old-name {
= | AS } new-name [...old-name {
= | AS } new-name])
Changes the name of a column.
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 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 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 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 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 DS2 Language Reference
| |
|
TYPE=data-set-type
Specifies the data set type for a specially structured SAS data
set.
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 DS2 Language Reference
| |
|
USER=HDFS-user
Specifies the HDFS user name.
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 DS2 Language Reference
| |
|
WRITE=write-password
Assigns a WRITE password to a SAS file that prevents
users from writing to a file, unless they enter the password.
Product: Base SAS
Document: SAS DS2 Language Reference
|
SAS Cloud Analytic Services
|
Name
|
Syntax and Description
|
|---|---|
|
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
| |
|
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
| |
|
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
|
SAS Federation Server
|
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
ASYNCINDEX=
YES | NO
Specifies to create indexes in parallel when creating multiple indexes on an SPD
Engine data set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_ACCOUNTNAME=
account-name
Specifies the name of the account to use on the external storage system.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_ALLOW_READ_ACCESS=
YES | NO
Specifies that the original table data is still visible to readers during bulk
load.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_APPLICATIONID=
"string"
Specifies the application ID (a GUID string) for accessing the external storage
system.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_AWS_CONFIG_FILE=path-and-file-name
Specifies the location of the AWS configuration file.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_AWS_CREDENTIALS_FILE=path-and-file-name
Specifies the path to the credentials file.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_AWS_PROFILE_NAME=profile-name
Specifies the AWS profile to use when there is more than one profile in
the AWS configuration file.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_AZURE_SAS=
value
Specifies the Azure shared access signature token value.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_AZURE_TENANTID=
tenant-id
Specifies the tenant ID for connecting to a Microsoft Azure storage system.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_BUCKET='<bucket-name>'
Specifies the bucket name to use when transferring data files in
bulk.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_COMPRESS=
YES | NO
Specifies whether to compress data files using the gzip format.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_CONFIG='<path-and-file-name>'
Specifies the location of the optional configuration file that the SAS
communication layer uses to interact with the Amazon S3 tool.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_COPY_LOCATION=
pathname
Specifies the directory to which DB2 saves a copy of the loaded data.
Product: SAS Federation Server
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: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_DEFAULT_DIR=
host-specific-directory-path
Specifies the location where the bulk load facility creates intermediate files.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_DELETE_DATAFILE=
YES | NO
Specifies whether to delete intermediate files created by the bulk loading
facility.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_DELIMITER=
'single-ascii-character | octal-representation'
Overrides the default delimiter character for separating columns of data during
bulk loading.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_ERRORS=
number
Specifies that, after the indicated number of errors is received, the load should
stop.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_EXCEPTION=
exception-table-name
Specifies the exception table into which rows in error are copied.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_FILESYSTEM=
file-system-name
Specifies the name of the file system within the external storage system.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_FOLDER=
file-path-and-folder
Specifies the folder or file path for the data in the external storage system.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_IAM_ASSUME_ROLE_ARN="ARN-value"
Specifies an Amazon Resource Name (ARN) that identifies an IAM
role.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_IAM_ASSUME_ROLE_NAME="value"
Specifies an AWS IAM role name that enables you to connect to an Amazon S3
environment.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_IAM_ROLE='role-value'
Specifies an optional Amazon Web Services IAM role to use for the COPY
command.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_INTERNAL_STAGE=stage-and-path
Specifies the internal stage and path for bulk loading to Snowflake.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_KEY=key-value
Specifies the Amazon Web Services access key that is used with key-based
access control.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_LOAD_REPLACE=
NO | YES
Specifies whether DB2 appends or replaces rows during bulk
loading.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_LOGFILE=
'log-file-name'
Specifies the filename for the bulk load log file.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_NUM_DATAFILES=
value
Specifies the number of data files to create to contain the source data.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_PARALLEL=
YES | NO
Specifies whether to perform a parallel bulk load.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_PORT_MAX=
integer
Sets the highest available port number for concurrent uploads.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_PORT_MIN=
integer
Sets the lowest available port number for concurrent uploads.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_RECOVERABLE=
YES | NO
Specifies whether the LOAD process is recoverable.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_REGION=region
Specifies the Amazon Web Services (AWS) region from which data is being
retrieved.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_REMOTE_FILE=
pathname-and-base-filename
Specifies the base filename and location of DB2 LOAD temporary
files.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_SECRET=secret-access-key
Specifies the secret access key that is used when you transfer data in
bulk.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_SKIP=
number-of-rows
Specifies to skip the indicated number of rows before starting the bulk
load.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_SKIP_INDEX_MAINTENANCE=
YES | NO
Specifies whether to perform index maintenance on the bulk
load.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_TIMEOUT=
value
Specifies the maximum completion time in seconds for a storage
task.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_TOKEN=temporary-token
Specifies a temporary token that is associated with the temporary credentials
that you specify with the BL_KEY= and BL_SECRET= options.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_USE_ESCAPE=
YES | NO
Specifies whether to escape a predefined set of special characters during bulk
loading or bulk retrieval.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BL_USE_SSL=YES | NO
Specifies whether to use TLS encryption for connections to Amazon
S3.
Product: SAS Federation Server
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: SAS Federation Server
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: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BULKLOAD=
YES | NO
Determines whether SAS uses a DBMS facility to insert data into a DBMS table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BULKOPTS=
(option[ ...option])
Provides a container for bulk-load options.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
BULKUNLOAD=
YES | NO
Rapidly retrieves (fetches) large number of rows from a DBMS
table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
COMPRESS=
NO | YES | CHAR | BINARY
Specifies how rows are compressed in a new output
data set or table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
CONFIG="configuration-path"
Specifies a file or path name for Hadoop configuration path
resolution.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
DATAFILE=
"filename"
Specifies an alternate name and location for the temporary HDFS
file.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
DBCREATE_INDEX_OPTS= 'DBMS-SQL-clauses'
Allows DBMS-specific options to be added to the
CREATE INDEX statement.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
ENCODING=encoding-value
Specifies the encoding to use when creating a SAS
data set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
ENCRYPT= AES | AES2 | NO | YES
Specifies whether to encrypt an output SAS data
set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
ENCRYPTKEY= [' | "]key-value [' | "]
Specifies a key value for AES and AES2 encryption.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
ENDOBS=
n
Specifies the end observation number in a user-defined range of observations to
be processed.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
FETCH_NUMERIC_TYPE=FLOAT64 | NUMERIC
Specifies how to handle NUMERIC data from Google BigQuery.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
GP_DISTRIBUTED_BY=
'DISTRIBUTED
BY (column [, ...column])
| DISTRIBUTED RANDOMLY' Specifies the distribution key for the table being created.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
IDXNAME= index-name
Directs SAS to use a specific index to match the
conditions of a WHERE clause.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
IOBLOCKSIZE=
n
Specifies the number of rows in a block to be used in an I/O
operation.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
KMS_PATH=”path-and-filename"
Specifies the location of a key file resource within
a project.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
LABEL= 'label '
Specifies a label for a table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
LOCATION='value'
Specifies the location of the data set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
LOCKTABLE= EXCLUSIVE | SHARE
Places shared or exclusive locks on tables.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
ORHINTS='/* Oracle-hint
*/'
Specifies Oracle hints to pass to Oracle from FedSQL.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
ORNUMERIC=YES | NO
Specifies how numbers read from or inserted into the Oracle NUMBER column are
treated.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
PARTSIZE=
n
Specifies the size of the table partitions.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
PASSWORD="value"
Specifies the password for the HDFS user.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
PICKLIST="filename"
Specifies the picklist to use for the bulk-loading operation.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL 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: SAS Federation Server
Document: SAS FedSQL 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: SAS Federation Server
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: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
READMODE=STANDARD | STORAGE
Specifies the method to use when moving data from
Google BigQuery into SAS.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
REUSE=
NO | YES
Specifies whether new rows can be written to freed
space in a compressed SAS data set.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
RS_AWS_CONFIG='path-and-file-name'
Specifies the location of the Amazon Web Services (AWS) configuration
file.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
RS_BUCKET='bucket-name'
Specifies the name of the AWS bucket to use when bulk loading data.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
RS_CREDENTIALS_FILE='path-and-file-name'
Specifies the AWS credentials file to use when bulk loading
data.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
RS_DEFAULT_DIR='directory-path'
Specifies where intermediate bulk-load files are created.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
RS_DELETE_DATAFILE=TRUE | FALSE
Specifies whether to delete the data file or all files created by the
bulk-loading facility.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
RS_KEY='key-value'
Specifies the Amazon Web Services access key that is used with key-based
access control. If you are using temporary token credentials, this is the temporary
access
key ID.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
RS_REGION='region'
Specifies the AWS region for Amazon S3 data.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
RS_SECRET='secret-access-key'
Specifies the secret access key that is used to bulk load
data.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
RS_TOKEN='token'
Specifies a temporary token that is associated with the temporary credentials
that you specify with the RS_KEY= and RS_SECRET= table options.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
STARTOBS=
n
Specifies the starting row number in a user-defined range of rows to be
processed.
Product: SAS Federation Server
Document: SAS FedSQL 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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_BUFFER_MODE=
YES | NO
Specifies whether the LOAD method is used.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_CHECKPOINT=
number
Specifies when the TPT operation issues a checkpoint or savepoint to the
database.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_DATA_ENCRYPTION=
YES | NO
Activates data encryption.
Product: SAS Federation Server
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: SAS Federation Server
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: SAS Federation Server
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: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_ERROR_TABLE_1=
name-of-table
Specifies a name for the first error table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_ERROR_TABLE_2=
name-of-table
Specifies a name for the second error table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_LOG_MECH_DATA="string"
Specifies additional data for the logon mechanism.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_LOG_MECH_TYPE=
mechanism
Specifies the logon mechanism for a bulk load.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_LOG_TABLE=
name-of-table
Specifies the name of the restart log table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_LOGDB=
database-name
Specifies the database where the TPT utility tables are
created.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_MAX_SESSIONS=
integer
Specifies the maximum number of logon sessions that TPT can acquire for a
job.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_MIN_SESSIONS=
integer
Specifies the minimum number of sessions for TPT to acquire before a job starts.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_NOTIFY_LEVEL=
level
Specifies the level at which log events are recorded.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_NOTIFY_METHOD=
method
Specifies the method for reporting events.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_NOTIFY_STRING=
string
Defines a string that precedes all messages sent to the system
log.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_PACK=
number
Specifies the number of statements to pack into a multistatement
request.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_PACK_MAXIMUM=
YES | NO
Lets the Stream operator determine the pack factor for the current Stream
job.
Product: SAS Federation Server
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: SAS Federation Server
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: SAS Federation Server
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: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_TPT_OPER=
operator
Specifies the load operator that is used by the Teradata Parallel
Transporter.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_TRACE_OUTPUT=
filename
Specifies the name of the external file used for trace
messages.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_UNICODE_PASSTHRU=
YES | NO
Allows pass-through characters (PTCs) to be imported into and exported from
Teradata.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_WORK_TABLE=
name-of-table
Specifies a name for the TPT Work table.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TD_WORKING_DB=
database-name
Specifies the database where the insert table is to be
created.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
TYPE= data-set-type
Specifies the data set type for a specially structured
SAS data set.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
USER=HDFS-user
Specifies the HDFS user name.
Product: SAS Federation Server
Document: SAS FedSQL Language Reference
| |
|
WHERENOINDEX=
(name1 name2...)
Specifies a list of indexes to exclude when making WHERE expression
evaluations.
Product: SAS Federation Server
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: SAS Federation Server
Document: SAS FedSQL Language Reference
|
SAS Scalable Performance Data Server
|
Name
|
Syntax and Description
|
|---|---|
|
ASYNCINDEX=NO | YES
When you are creating multiple indexes on an SPD
Server table, specifies whether to create the indexes in parallel.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
BYNOEQUALS=NO | YES
Specifies the output order of table rows with identical
values for the BY column.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
BYSORT=NO | YES
Specifies to perform an implicit automatic sort
when SPD Server encounters a BY clause for a given table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
COMPRESS=CHAR | YES | BINARY | NO
Compresses SPD Server tables on disk.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
ENCRYPT=AES | NO | YES
Encrypts SPD Server tables on disk.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
ENCRYPTKEY=key-value
Specifies a key value to enable AES encryption and
decryption.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
ENDOBS=n
Specifies the end row number in a user-defined range
for the processing of a given table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
IOBLOCKSIZE=n
Specifies the number of rows in a block to be stored
in or read from an SPD Server table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
MINMAXVARLIST=(variable-name(s) )
Creates a list that documents the minimum and maximum
values of specified columns.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
NETPACKSIZE=size-of-packet
Specifies the size of the SPD Server network data
packet.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
NOINDEX=NO | YES
Specifies whether to use the table's indexes when
processing WHERE clauses. NOINDEX= can also be used to disable index
use for BY order determination.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
PARTSIZE=n
Specifies the size of an SPD Server table partition.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
SEGSIZE=n
Specifies the size of the segment for an index file
associated with an SPD Server table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
STARTOBS=n
Specifies the start row number in a user-defined
range for the processing of a given table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
SYNCADD=NO | YES
Specifies to process one row at a time or multiple
rows at a time when adding rows.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
THREADNUM=n
Specifies the number of threads to be used for WHERE
clause evaluations.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
UNIQUESAVE=NO | REP | YES
Specifies to save rows that contain duplicate values
(which would be rejected) when appending or inserting data in tables
with unique indexes.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
VERBOSE=NO | YES
Specifies whether the CONTENTS procedure output
includes details about compressed blocks, data partition size, and
indexes.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
| |
|
WHERENOINDEX=(name(s) )
Specifies a list of indexes to exclude when making
WHERE clause evaluations.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
|
Last updated: September 16, 2026