|
Name
|
Syntax and Description
|
|
|
AGGREGATE=YES | NO
Specifies whether detailed data or aggregated data should be used
Product: Base SAS
Document: Base SAS Guide to Information Maps
|
|
|
ALQ=
allocation-quantity
Specifies how many disk blocks to initially allocate to a new
SAS data set.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
ALQMULT=
n
Specifies the number of pages that are preallocated to a file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
ALTER=alter-password
Specifies a password for a SAS file that prevents users from replacing
or deleting the file, but permits read and write access.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
ALTER=alter-password
Specifies a password for a SAS file that prevents users from replacing
or deleting the file, but permits Read and Write access.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
ALTER=alter-password
Specifies a password for a SAS file that prevents users from replacing
or deleting the file, but permits READ and WRITE access.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
ALTER=
alter-password
Assigns an ALTER password to a SAS file that prevents
users from replacing or deleting the file, and enables access to a read- and
write-protected file.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
ASYNCINDEX=YES|NO
Specifies to create indexes in parallel when creating multiple
indexes on an SPD Engine data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
AUTHID=
authorization-ID
Lets you qualify the specified table with an authorization ID,
user ID, or group ID.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
AUTOCOMMIT=YES | NO
Specifies whether to enable the DBMS autocommit capability.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
AUTOCOMMIT=YES | NO
Determines whether the ACCESS engine commits (saves) updates as
soon as the user submits them.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
AUTOCOMMIT=YES | NO
Determines whether the
ACCESS engine commits (saves) updates as soon as the user submits them.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
BKS=
bucket-size
Specifies the bucket size for a new data set.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
BL_ALLOW_READ_ACCESS=YES | NO
Specifies that the original table data is still visible to readers
during bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_ALLOW_WRITE_ACCESS=YES | NO
Specifies that table data is still accessible to readers and writers
while import is in progress.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_BADDATA_FILE=
filename
Specifies where to put records that failed to process internally.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_BADFILE=
path-and-filename
Identifies a file that contains records that were rejected during
bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_CODEPAGE=
numeric-codepage-ID
Identifies the codepage that the DBMS engine uses to convert SAS
character data to the current database codepage during bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_CONTROL=
path-and-control-filename
[Oracle]
BL_CONTROL=
path-and-data-filename [Teradata]
Identifies the file that contains control statements.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_COPY_LOCATION=
pathname
Specifies the directory to which DB2 saves a copy of the loaded
data.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_CPU_PARALLELISM=
number of processes or threads
Specifies the number of processes or threads to use when building
table objects.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DATAFILE=
path-and-data-filename
Identifies the file that contains DBMS data for bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DATAFILE=
path-and-data-filename
Identifies the file that contains control statements.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: 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/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2CURSOR= 'SELECT * from filename'
Specifies a string that contains a valid DB2 SELECT statement
that points to either local or remote objects (tables or views).
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2DATACLAS=
data-class
Specifies a data class for a new SMS-managed data set.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2DEVT_PERM=
unit-specification
Specifies the unit address or generic device type to use for permanent
data sets that the LOAD utility creates—also SYSIN, SYSREC, and SYSPRINT
when SAS allocates them.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2DEVT_TEMP=
unit-specification
Specifies the unit address or generic device type to use for temporary
data sets that the LOAD utility creates (PNCH, COPY1, COPY2, RCPY1, RCPY2,
WORK1, WORK2).
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2DISC=
data-set-name
Specifies the SYSDISC data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2ERR=
data-set-name
Specifies the SYSERR data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2IN=
data-set-name
Specifies the SYSIN data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2LDCT1='string'
Specifies a string in the LOAD utility control statement between
LOAD DATA and INTO TABLE.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2LDCT2='string'
Specifies a string in the LOAD utility control statement between
INTO TABLE table-name and (field-specification).
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2LDCT3='string'
Specifies a string in the LOAD utility control statement after
(field-specification).
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2LDEXT= GENRUN | GENONLY | USERUN
Specifies the mode of execution for the DB2 LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2MAP=
data-set-name
Specifies the SYSMAP data set name for the LOAD utility .
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2MGMTCLAS=
management-class
Specifies a management class for a new SMS-managed data set.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2PRINT=
data-set-name
Specifies the SYSPRINT data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2PRNLOG= YES | NO
Determines whether to write SYSPRINT output to the SAS log.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2REC=
data-set-name
Specifies the SYSREC data set name for the LOAD utility.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2RECSP=
primary-allocation
Determines the number of cylinders to specify as the primary allocation
for the SYSREC data set when it is created.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2RSTRT= NO | CURRENT | PHASE
Tells the LOAD utility whether the current load is a restart and,
if so, indicates where to begin.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2SPC_PERM=
primary-allocation
Determines the number of cylinders to specify as the primary allocation
for permanent data sets that the LOAD utility creates.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2SPC_TEMP=
primary-allocation
Determines the number of cylinders to specify as the primary allocation
for temporary data sets that the LOAD utility creates.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2STORCLAS=
storage-class
Specifies a storage class for a new SMS-managed data set.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2TBLXST= YES | NO
Indicates whether the LOAD utility runs against an existing table.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2UNITCOUNT=
number-of-volumes
Specifies the number of volumes on which data sets can be extended.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DB2UTID=
utility-ID
Specifies a unique identifier for a given run of the DB2 LOAD
utility.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DELETE_DATAFILE=YES | NO
Deletes the data file that is created for the DBMS bulk-load facility.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DELIMITER='<any-single-character>'
Specifies override of the default delimiter character for separating
columns of data during data transfer or retrieval during bulk load or bulk
unload.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DIRECT_PATH=YES | NO
Sets the Oracle SQL*Loader DIRECT option.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DISCARDFILE=
path-and-discard-filename
Identifies the file that contains records that were filtered from
bulk load because they did not match the criteria as specified in the CONTROL
file.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_DISCARDS=
number-of-discarded-records
Specifies whether and when to stop processing a job, based on
the number of discarded records.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: 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/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_ERRORS=
number-of-failed-records
Specifies whether and when to stop processing a job based on the
number of failed records.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_EXCEPTION=
exception table-name
Specifies the exception table into which rows in error are copied.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_FAILEDDATA=
filename
Specifies where to put records that could not be written to the
database.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_INDEXING_MODE= AUTOSELECT | REBUILD | INCREMENTAL
| DEFERRED
Indicates which scheme the DB2 load utility should use for index
maintenance.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_INDEX_OPTIONS=
any valid SQL*Loader Index
option
segment-name
Lets you specify SQL*Loader Index options with bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_KEEPIDENTITY=YES | NO
Determines whether the identity column that is created during
bulk load is populated with values that Microsoft SQL Server generates or
with values that the user provides.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_KEEPNULLS=YES | NO
Indicates how NULL values in Microsoft SQL Server columns that
accept NULL are handled during bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_LOAD_METHOD=INSERT | APPEND | REPLACE | TRUNCATE
Specifies the method by which data is loaded into an Oracle table
during bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_LOAD_REPLACE=NO | YES
Specifies whether DB2 appends or replaces rows during bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_LOG=
path-and-log-filename
Identifies a log file that contains information for bulk load,
such as statistics and errors.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_METHOD=CLILOAD
Specifies which bulk-load method to use for DB2.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_OPTIONS='<
option…,option
>
' [DB2 UNIX/PC, OLE DB, Oracle]
BL_OPTIONS='<<
option
>
>
<<
value> ... '>
[Netezza]
Passes options to the DBMS bulk-load facility, which affects how
it loads and processes data.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_PARFILE=
<
parse-file
>
Creates a file that contains the SQL*Loader command line options.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_PORT_MAX=
<
integer
>
Sets the highest available port number for concurrent uploads.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_PORT_MIN=
<
integer
>
Sets the lowest available port number for concurrent uploads.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_PRESERVE_BLANKS=YES | NO
Determines how the SQL*Loader handles requests to insert blank
spaces into CHAR/VARCHAR2 columns with the NOT NULL constraint.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_RECOVERABLE=YES | NO
Determines whether the LOAD process is recoverable.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_REMOTE_FILE=
pathname-and-base-filename
Specifies the base filename and location of DB2 LOAD temporary
files.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_RETRIES=
number-of-attempts
Specifies the number of attempts to make for a job.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_RETURN_WARNINGS_AS_ERRORS=YES | NO
Specifies whether SQL*Loader (bulkload) warnings should surface
in SAS through the SYSERR macro as warnings or as errors.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_ROWSETSIZE=
number-of-records
Specifies the number of records to exchange with the database.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_SERVER_DATAFILE=
path-and-data-filename
Specifies the name and location of the data file that the DB2
server instance sees.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_SQLLDR_PATH=
pathname
Specifies the location of the SQLLDR executable file.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_SUPPRESS_NULLIF=
<_ALL_=YES | NO >
| ( <
column-name-1=YES |
NO >
<
column-name-n=YES | NO >
…)
Indicates whether to suppress the NULLIF clause for the specified
columns to increase performance when a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_SYNCHRONOUS=YES | NO
Specifies how to process source file record sets.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_SYSTEM=
unqualified-systemname
Specifies the unqualified name of the primary segment on an HP
Neoview system.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_TENACITY=
number-of-seconds
Specifies how long the HP Neoview Transporter waits before retrying.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_TRIGGER=YES | NO
Specifies whether to enable triggers on a table when loading jobs.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_TRUNCATE=YES | NO
Specifies whether the HP Neoview Transporter truncates target
tables (when loading) or target data files (when extracting) before job processing
begins.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_USE_PIPE=YES | NO
Specifies a named pipe for data transfer.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BL_WARNING_COUNT=
warning-count
Specifies the maximum number of row warnings to allow before the
load fails.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BUFFERS=
number-of-shared-memory-buffers
Specifies the number of shared memory buffers to use for transferring
data from SAS to Teradata.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: 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 Companion for the UNIX Environments
|
|
|
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 Language Reference: Dictionary
|
|
|
BUFSIZE= 0 | n | nK
Specifies the size of a permanent buffer page for an output SAS
data set.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
BUFSIZE=n | nK | nM | nG | hexX | MAX
Specifies the size of a permanent buffer page for an output SAS
data set.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
BUFSIZE=
n | nK | nM | nG | hexX | MAX
Specifies the size of a permanent buffer page for an output SAS
data set.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
BUFSIZE=
n | nK | nM | nG | hexX | MAX
Specifies the size of a permanent buffer page for
an output SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
BULKEXTRACT=YES | NO
Rapidly retrieves (fetches) large number of rows from a data set.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BULKLOAD=YES | NO
Loads rows of data as one unit.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BULKUNLOAD=YES | NO
Rapidly retrieves (fetches) large number of rows from a data set.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BULK_BUFFER=
numeric-value
Specifies the number of bulk rows that the SAS/ACCESS engine
can buffer for output.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
BYNOEQUALS=YES | NO
Specifies whether the output order of data set observations that
have identical values for the BY variable is guaranteed to be in the data
set order.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
BYSORT=YES | NO
Specifies for the SPD Engine to perform an automatic sort when
it encounters a BY statement.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
CACHENUM=
n
Specifies the number of I/O data caches used per SAS file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
CACHESIZE=
n | nK | nM | nG | hexX
Controls the size of the I/O data cache that is allocated for
a SAS file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
CAST=YES | NO
Specifies whether SAS or the Teradata DBMS server should perform
data conversions.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
CAST_OVERHEAD_MAXPERCENT=
<n>
Specifies the overhead limit for data conversions to perform in
Teradata instead of SAS.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
CNTLLEV=MEM | REC
Specifies the level of shared access to SAS data sets.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
CNTLLEV=LIB | MEM | REC
Specifies the level of shared access to a SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
COMMAND_TIMEOUT=
number-of-seconds
Specifies the number of seconds to wait before a command times
out.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
COMMAND_TIMEOUT=
number-of-seconds
Specifies the number of seconds to wait before a command times
out.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
COMMAND_TIMEOUT=
number-of-seconds
Specifies the number of seconds to wait before a command times
out.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
COMPRESS= NO | YES | CHAR | BINARY
Specifies to compress SPD Engine data sets on disk as they are
being created.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
COMPRESS=NO | YES | CHAR | BINARY
Specifies how observations are compressed in a new output SAS
data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
CURSOR_TYPE=KEYSET_DRIVEN | STATIC
Specifies the cursor type for read-only cursors and for cursors
to be updated.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
CURSOR_TYPE=DYNAMIC | FORWARD_ ONLY | KEYSET_DRIVEN
| STATIC
Specifies the cursor type for read-only cursors and cursors to
update.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
CURSOR_TYPE= DYNAMIC | FORWARD_ONLY | KEYSET_DRIVEN
| STATIC
Specifies the cursor type for read only and updatable cursors.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBCOMMIT=
number-of-rows
Enables you to issue a commit statement automatically after a
specified number of rows have been processed.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBCOMMIT=
number-of-rows
Lets you issue a commit statement automatically after a specified
number of rows have been processed.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBCOMMIT=
n
Causes an automatic COMMIT (a permanent writing of data to the
DBMS) after a specified number of rows are processed.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBCONDITION=
"SQL-query-clause"
Specifies criteria for subsetting and ordering data.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBCONDITION=
"SQL-query-clause"
Specifies criteria for subsetting and ordering data.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBCONDITION=
"DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS data.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBCREATE_TABLE_OPTS=
'SQL-clauses'
Specifies data source-specific syntax to be added to the CREATE
TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBCREATE_TABLE_OPTS=
'SQL-clauses'
Specifies data source-specific syntax to add to the CREATE TABLE
statement.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBCREATE_TABLE_OPTS=
'DBMS-SQL-clauses'
Specifies DBMS-specific syntax to add to the CREATE TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBENCODING='12–byte-SAS-encoding-value';
Specifies the encoding character set to use in the Microsoft Access
database or in the Excel workbook file.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBFORCE=YES | NO
Specifies whether to force the truncation of data during insert
processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBFORCE=YES | NO
Specifies whether to force the truncation of data during insert
processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBFORCE=YES | NO
Specifies whether to force the truncation of data during insert
processing.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBGEN_NAME=DBMS | SAS
Specifies whether to rename columns automatically when they contain
disallowed characters.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBGEN_NAME=DBMS | SAS
Specifies whether to rename columns automatically when they contain
disallowed characters.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBGEN_NAME=DBMS | SAS
Specifies how SAS automatically renames columns (when they contain
characters that SAS does not allow, such as $) to valid SAS variable names.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBINDEX=YES | NO | <'>index-name<'>
Detects and verifies that indexes exist on a DBMS table.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBKEY=
(<'>column-1<'> <...
<'>column-n<'>>)
Improves performance for a join with a large data source table
and a small SAS data set (specifies a column to use as an index).
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBKEY=
(<'>column-1<'> <...
<'>column-n<'>>)
Improves performance by specifying a column to use as an index
when you process a join that involves a large data source table and a small
SAS data set.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBKEY=(<'>
column-1
<'>
<… <'>
column-n
<'>
>
)
Specifies a key column to optimize DBMS retrieval.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBLABEL=YES | NO
Specifies whether to use SAS variable labels as data source column
names during output processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBLABEL=YES | NO
Specifies whether to use SAS variable labels as data source column
names during output processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBLABEL=YES | NO
Specifies whether to use SAS variable labels or SAS variable names
as the DBMS column names during output processing.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBLINK=
database-link
Specifies a link from your local database to database objects
on another server [Oracle]. Specifies a link from your default database to
another database on the server to which you are connected [Sybase].
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBMASTER=
YES
Designates which table is the larger table when you are processing
a join that involves tables from two different types of databases.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBMAX_TEXT=
integer
Determines the length of a very long data source character data
type that is read into SAS or written from SAS when you are using a SAS/ACCESS engine.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBMAX_TEXT=
integer
Determines the length of a very long data source character data
type that is read into SAS or written from SAS when you are using a SAS/ACCESS engine.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBMAX_TEXT=
integer
Determines the length of any very long DBMS character data type
that is read into SAS or written from SAS when you are using a SAS/ACCESS engine.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBNULL= (column-name-1=YES | NO <...column-name-n=YES | NO > |_ALL_=YES | NO)
Indicates whether NULL is a valid value for the specified columns
when a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBNULL= (column-name-1=YES | NO <...column-name-n=YES | NO > |_ALL_=YES | NO)
Indicates whether NULL is a valid value for the specified columns
when a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBNULL=
<_ALL=YES | NO >
| ( <
column-name-1=YES | NO >
<…<
column-name-n=YES
| NO >
>
)
Indicates whether NULL is a valid value for the specified columns
when a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBNULLKEYS= YES | NO
Controls the format of the WHERE clause when you use the DBKEY=
data set option.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBNULLKEYS= YES | NO
Controls the format of the WHERE clause when you use the DBKEY=
data set option.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBNULLKEYS= YES | NO
Controls the format of the WHERE clause with regard to NULL values
when you use the DBKEY= data set option.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBPROMPT=YES | NO
Specifies whether SAS displays a window that prompts you to enter
DBMS connection information.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBSASLABEL= COMPAT | NONE
Specifies whether SAS/ACCESS saves
the data source's column names as SAS label names.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBSASLABEL=COMPAT | NONE
Specifies how the engine returns column labels.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBSASTYPE=
(column-name-1=<'>SAS-data-type<'>
<...column-name-n=<'>SAS-data-type<'>>)
Specifies data type(s) to override the default SAS data type(s)
during input processing of data.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBSASTYPE=
(column-name-1=<'>SAS-data-type<'>
<...column-name-n=<'>SAS-data-type<'>>)
Specifies one or more data types to override one or more default
SAS data types during input processing of data.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBSASTYPE=
(column-name-1=<'>
SAS-data-type
<'>
<
…
column-name-n=<'>
SAS-data-type
<'>
>
)
Specifies data types to override the default SAS data types during
input processing.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBSLICE=("WHERE-clause-1" " WHERE-clause-2" < ... "WHERE-clause-n">
)
DBSLICE=(<
server=>
"WHERE-clause-1" <
server=>
" WHERE-clause-2" < … <
server=>
"WHERE-clause-n">
)
Specifies user-supplied WHERE clauses to partition a DBMS query
for threaded reads.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBSLICEPARM=( NONE | THREADED_APPS | ALL <, max-threads
>
)
Controls the scope of DBMS threaded reads and the number of DBMS
connections.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DBTYPE=
(column-name-1=<'>data-source-type<'>
<...column-name-n=<'>data-source-type<'>>)
Specifies a data type to use instead of the default data source
data type when SAS creates a data source table.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBTYPE=
(column-name-1=<'>data-source-type<'>
<...column-name-n=<'>data-source-type<'>>)
Specifies a data type to use instead of the default data source
data type when SAS creates a data source table.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
DBTYPE=(column-name-1=<'>
DBMS-type
<'>
<
…column-name-n=<'>
DBMS-type
<'>
>
)
Specifies a data type to use instead of the default DBMS data
type when SAS creates a DBMS table.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DDBCOMIT=
n
Specifies the number of rows that will be processed before a database
COMMIT statement is issued.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
|
|
|
DDBERLMT=
n
Specifies the number of errors that are used before SAS stops
processing and issues a rollback.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
|
|
|
DDBKEY='default-key'
Specifies a Default Key.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
|
|
|
DDBLOAD= 0|1
Specifies a fast-loading process.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
|
|
|
DDBLOCK= 0|1
Suppresses the creation of an interface spool file.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
|
|
|
DDBPW='password'
Specifies a CA-DATADICTIONARY password.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
|
|
|
DDBSV='status/version'
Specifies the status and version of the CA-Datacom/DB table
that you want to access.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
|
|
|
DDBTRACE= 0|1
Displays information for debugging purposes.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
|
|
|
DDBURT='User-Requirements-Table-name'
Specifies the URT that will be used by the interface view engine
when it opens the view descriptor.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
|
|
|
DDBUSER='userid'
Specifies the CA-DATADICTIONARY userid.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to CA-Datacom/DB: Reference
|
|
|
DEGREE= ANY | 1
Determines whether DB2 uses parallelism.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DEQ=
default-file-extension-quantity
Specifies how many disk blocks to add when OpenVMS automatically
extends a SAS data set during a write operation.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
DEQMULT=
n
Specifies the number of pages to extend a SAS file.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
DISTRIBUTE_ON='column-1 <... ,column-n>' | RANDOM
Specifies a column name to use in the DISTRIBUTE ON clause of
the CREATE TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
DLDMGACTION=FAIL | ABORT | REPAIR | NOINDEX | PROMPT
Specifies the action to take when a SAS data set
in a SAS library is detected as damaged.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
DROP=
variable-1 <...variable-n>
For an input data set, excludes the specified variables
from processing; for an output data set, excludes the specified variables
from being written to the data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
ENCODING= ANY | ASCIIANY | EBCDICANY | encoding-value
Overrides the encoding to use for reading or writing a SAS data
set.
Product: Base SAS
Document: SAS National Language Support: Reference Guide
|
|
|
ENCRYPT=YES | NO
Specifies whether to encrypt an output SPD Engine data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
ENCRYPT=YES | NO
Specifies whether to encrypt an output SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
ENDOBS=
n
Specifies the end observation number in a user-defined range of
observations to be processed.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
ERRLIMIT=
integer
Specifies the number of errors that are allowed before SAS stops
processing and issues a rollback.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
ERRLIMIT=
integer
Specifies the number of errors that are allowed before SAS stops
processing and issues a rollback.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
ERRLIMIT=
integer
Specifies the number of errors that are allowed before SAS stops
processing and issues a rollback.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
ESCAPE_BACKSLASH=YES | NO
Specifies whether backslashes in literals are preserved during
data copy from a SAS data set to a table.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
EXPCOLUMNLEN=column-length
Specifies the default length of the SAS character column when
a data item defined with expressions is encountered
Product: Base SAS
Document: Base SAS Guide to Information Maps
|
|
|
FILECLOSE= FREE | LEAVE | REREAD | REWIND
Specifies how a tape is positioned when a SAS data set is closed.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
FILECLOSE=DISP | LEAVE | REREAD | REWIND
Specifies how a tape is positioned when a SAS data
set is closed.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
FILEDISP=NEW | OLD
Specifies the initial disposition for a sequential access bound
SAS library.
Product: Base SAS
Document: SAS Companion for z/OS
|
|
|
FILTER=(<NOT>
filter-1
< ... Boolean-operator
<NOT>
filter-n
>
)
Uses the filters that are defined in an information map to specify
criteria in a query for subsetting a result set
Product: Base SAS
Document: Base SAS Guide to Information Maps
|
|
|
FIRSTOBS=
n| nK | nM | nG | hexX | MIN | MAX
Specifies the first observation that SAS processes
in a SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
GENMAX=
number-of-generations
Requests generations for a new data set, modifies
the number of generations for an existing data set, and specifies the maximum
number of versions.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
GENNUM=
integer
Specifies a particular generation of a SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
IDXBY=YES | NO
Specifies whether to use an index when processing BY statements
in the SPD Engine.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
b IDXNAME=
index-name
Directs SAS to use a specific index to match the
conditions of a WHERE expression.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
IDXWHERE=YES | NO
Specifies to use indexes when processing WHERE expressions in
the SPD Engine.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
IDXWHERE=YES | NO
Specifies whether SAS uses an index search or a sequential
search to match the conditions of a WHERE expression.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
IGNORE_READ_ONLY_COLUMNS=YES | NO
Specifies whether to ignore or include columns whose data types
are read-only when generating an SQL statement for inserts or updates.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
IN=
'database-name.tablespace-name'|'DATABASE database-name'
Lets you specify the database or tablespace in which you want
to create a new table.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
IN=
variable
Creates a Boolean variable that indicates whether
the data set contributed data to the current observation.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
INDEX=(index-specification-1 ...<
index-specification-n
>
)
Defines an index for a new output SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
INSERTBUFF=
number-of-rows
Specifies the number of rows in a single insert.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
INSERTBUFF=
number-of-rows
Specifies the number of rows in a single insert.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
INSERTBUFF=
positive-integer
Specifies the number of rows in a single DBMS insert.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
INSERT_SQL=YES | NO
Determines the method that is used to insert rows into a data
source.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
INSERT_SQL=YES | NO
Determines the method to use to insert rows into a data source.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
INSERT_SQL=YES | NO
Determines the method to use to insert rows into a data source.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
IOBLOCKSIZE=
n
Specifies the size in bytes of a block of observations to be compressed.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
KEEP=
variable-1 <...variable-n>
For an input data set, specifies the variables to
process; for an output data set, specifies the variables to write to the data
set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
KEYSET_SIZE=
number-of-rows
Specifies the number of rows in the cursor that the keyset drives.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
LABEL='label'
Specifies a label for a SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
LIBNAME
libref
pcfiles
<
connection-options
>
<
libname-options
>
;
LIBNAME
libref CLEAR | _ALL_
CLEAR;
LIBNAME
libref LIST | _ALL_
LIST;
Associates a SAS libref with a workbook, database, or ODBC data
source.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
LIBNAME
libref
<
engine-name
>
<
physical-file-name
>
<
SAS/ACCESS-engine-connection-options
>
<
SAS/ACCESS-libname-options
>
;
LIBNAME
libref CLEAR | _ALL_ CLEAR;
LIBNAME
libref LIST | _ALL_ LIST;
Associates a SAS libref with a workbook or database.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
LISTFILES=YES | NO
Specifies whether the CONTENTS procedure lists the complete pathnames
of all of the component files of an SPD Engine data set.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
LOCATION=
location-name
Lets you further specify exactly where a table resides.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
LOCKREAD=YES | NO
Specifies whether to read a record if a lock cannot be obtained
for the record.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
LOCKTABLE=EXCLUSIVE | SHARE
Places exclusive or shared locks on tables.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
LOCKWAIT=YES | NO | n
Indicates whether SAS should wait for a locked record.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
MBF=
multibuffer-count
Specifies the multibuffer count for a data set.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
MBUFSIZE=
size-of-shared-memory-buffers
Specifies the size of the shared memory buffers to use for transferring
data from SAS to Teradata.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
ML_CHECKPOINT=
checkpoint-rate
Specifies the interval between checkpoint operations in minutes.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
ML_ERROR1=
temporary-table-name
Specifies the name of a temporary table that MultiLoad uses to
track errors that were generated during the acquisition phase of a bulk-load
operation.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
ML_ERROR2=
temporary-table-name
Specifies the name of a temporary table that MultiLoad uses to
track errors that were generated during the application phase of a bulk-load
operation.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
ML_LOG=
prefix-for-MultiLoad-temporary-tables
Specifies a prefix for the names of the temporary tables that
MultiLoad uses during a bulk-load operation.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
ML_RESTART=
temporary-table-name
Specifies the name of a temporary table that MultiLoad uses to
track checkpoint information.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
ML_WORK=
temporary-table-name
Specifies the name of a temporary table that MultiLoad uses to
store intermediate data.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
MULTILOAD=YES | NO
Specifies whether Teradata insert and append operations should
use the Teradata MultiLoad utility.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
MULTISTMT=YES | NO
Specifies whether insert statements are sent to Teradata one at
a time or in a group.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
NULLCHAR= YES | NO
Indicates how SAS character missing values are handled during
insert, update, and DBKEY= processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
NULLCHAR= YES | NO
Indicates how SAS character missing values are handled during
insert, update, and DBKEY= processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
NULLCHAR= SAS | YES | NO
Indicates how missing SAS character values are handled during
insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
NULLCHARVAL=
'character-string'
Defines the character string that replaces SAS character missing
values during insert, update, and DBKEY= processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
NULLCHARVAL=
'character-string'
Defines the character string that replaces SAS character missing
values during insert, update, and DBKEY= processing.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
NULLCHARVAL=
'character-string'
Defines the character string that replaces missing SAS character
values during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
OBS=
n | nK | nM
| nG | nT | hexX | MIN | MAX
Specifies the last observation that SAS processes
in a data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
OBSBUF=
n
Determines the size of the view buffer for processing a DATA step
view.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
ORHINTS=
'Oracle-hint'
Specifies Oracle hints to pass to Oracle from a SAS statement
or SQL procedure.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
OR_PARTITION=
name of a partition in a partitioned
Oracle table
Allows reading, updating, and deleting from a particular partition
in a partitioned table, also inserting and bulk loading into a particular
partition in a partitioned table.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
OR_UPD_NOWHERE=YES | NO
Specifies whether SAS uses an extra WHERE clause when updating
rows with no locking.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
OUTREP=
format
Specifies the data representation for the output SAS data set.
Product: Base SAS
Document: SAS Companion for OpenVMS on HP Integrity Servers
|
|
|
OUTREP=
format
Specifies the data representation for the output SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
PADCOMPRESS=
n
Specifies the number of bytes to add to compressed blocks in a
data set opened for OUTPUT or UPDATE.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
PARTSIZE=
n | nM | nG | nT
Specifies the maximum size (in megabytes, gigabytes, or terabytes)
that the data component partitions can be. The value is specified when an
SPD Engine data set is created. This size is a fixed size. This specification
applies only to the data component files.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: 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 Language Reference: Dictionary
|
|
|
PRESERVE_COL_NAMES=NO | YES
Preserves spaces, special characters, and case sensitivity in
DBMS column names when you create DBMS tables.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
PW=password
Assigns a READ, WRITE, or ALTER password to a SAS file, and enables
access to a password-protected SAS file.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
PW=
password
Assigns a READ, WRITE, and ALTER password to a SAS
file, and enables access to a password-protected SAS file.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
PWREQ=YES | NO
Specifies whether to display a dialog box to enter
a SAS data set password.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
QUALIFIER=
<qualifier-name>
Specifies the qualifier to use when you are reading database objects,
such as DBMS tables and views.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
QUERY_TIMEOUT=
number-of-seconds
Specifies the number of seconds of inactivity to wait before canceling
a query.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: 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 Language Reference: Dictionary
|
|
|
READBUFF=
number-of-rows
Specifies the number of rows of data to read into the buffer.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
READBUFF=
number-of-rows
Specifies the number of rows of data to read into the buffer.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
READBUFF=
integer
Specifies the number of rows of DBMS data to read into the buffer.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
READBUFF=integer
Specifies the number of rows to hold in memory for input into
SAS
Product: Base SAS
Document: Base SAS Guide to Information Maps
|
|
|
READ_ISOLATION_LEVEL=
DBMS-specific-value
Specifies which level of read isolation locking to use when you
are reading data.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
READ_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
Specifies how data in a DBMS table is locked during a read transaction.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
READ_MODE_WAIT=YES|NO
Specifies during SAS/ACCESS
read operations whether Teradata waits to acquire a lock or fails your request
when a different user has locked the DBMS resource.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
RENAME=(old-name-1=new-name-1
< ...old-name-n=new-name-n
>
)
Changes the name of a variable.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
REPEMPTY=YES | NO
Specifies whether a new, empty data set can overwrite
an existing SAS data set that has the same name.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
REPLACE=NO | YES
Specifies whether a new SAS data set that contains
data can overwrite an existing data set that has the same name.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
REUSE=NO | YES
Specifies whether new observations can be written
to freed space in compressed SAS data sets.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SASDATEFMT=
(data-source-date-column-1='SAS-date-format'<...
data-source-date-column-n='SAS-date-format'>)
Changes the SAS date format of a data source column.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
SASDATEFMT=
(data-source-date-column-1='SAS-date-format'<...
data-source-date-column-n='SAS-date-format'>)
Changes the SAS date format of a data source column.
Product: SAS/ACCESS
Document: SAS/ACCESS Interface to PC Files: Reference
|
|
|
SASDATEFMT=(DBMS-date-col-1='SAS-date-format'
<
… DBMS-date-col-n='SAS-date-format'
>
)
Changes the SAS date format of a DBMS column.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
SCHEMA=
schema-name
Lets you read a data source (such as a DBMS table and view) in
the specified schema.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
SEGMENT_NAME=
segment-name
Lets you control the segment in which you create a table.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
SET=YES | NO
Specifies whether duplicate rows are allowed when creating a table.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
SGIO= YES| NO
Activates the Scatter/Gather I/O feature for a data set.
Product: Base SAS
Document: SAS Companion for Windows
|
|
|
SLEEP=
number-of-minutes
Specifies the number of minutes that MultiLoad waits before it
retries logging in to Teradata.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
SORTEDBY=
by-clause
</ collate-name
>
| _NULL_
Specifies how a data set is currently sorted.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
SPILL=YES | NO
Specifies whether to create a spill file for non-sequential processing
of a DATA step view.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
STARTOBS=
n
Specifies the starting observation number in a user-defined range
of observations to be processed.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
SYNCADD=YES|NO
Specifies to process one observation at a time or multiple observations
at a time.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
TENACITY=
number-of-hours
Specifies how many hours MultiLoad continues to retry logging
on to Teradata if the maximum number of Teradata utilities are already running.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: 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 Scalable Performance Data Engine: Reference
|
|
|
TOBSNO=
n
Specifies the number of observations to send in a
client/server transfer.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
TRAP151=YES | NO
Enables columns that cannot be updated to be removed from a FOR
UPDATE OF clause so updating of columns can proceed as normal.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
TYPE=
data-set-type
Specifies the data set type for a specially structured SAS data
set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
UNIQUESAVE=YES|NO
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.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
UPDATEBUFF=
positive-integer
Specifies the number of rows that are processed in a single DBMS
update or delete operation.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
UPDATE_ISOLATION_LEVEL=
DBMS-specific-value
Defines the degree of isolation of the current application process
from other concurrently running application processes.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
UPDATE_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
Specifies how data in a DBMS table is locked during an update
transaction.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
UPDATE_MODE_WAIT=YES|NO
Specifies during SAS/ACCESS update
operations whether the DBMS waits to acquire a lock or fails your request
when a different user has locked the DBMS resource.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
UPDATE_SQL=YES | NO
Determines which method to use to update and delete rows in a
data source.
Product: SAS/ACCESS
Document: SAS/ACCESS for Relational Databases: Reference
|
|
|
USEDIRECTIO=
Turns on direct file I/O for a library that contains the file
to which the ENABLEDIRECTIO option has been applied.
Product: Base SAS
Document: SAS Companion for the UNIX Environments
|
|
|
WHERE=(where-expression-1<logical-operator where-expression-n>)
Specifies specific conditions to use to select observations
from a SAS data set.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
WHERENOINDEX=(name1 name2...)
Specifies a list of indexes to exclude when making WHERE expression
evaluations.
Product: Base SAS
Document: SAS Scalable Performance Data Engine: Reference
|
|
|
WHEREUP=NO | YES
Specifies whether to evaluate new observations and
modified observations against a WHERE expression.
Product: Base SAS
Document: SAS Language Reference: Dictionary
|
|
|
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 Language Reference: Dictionary
|