|
Name
|
Syntax and Description
|
|---|---|
|
AGGREGATE=
YES
| NO
Specifies whether detailed data or aggregated data
should be retrieved.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
|
|
|
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 9.3 Companion for 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 9.3 Companion for z/OS
|
|
|
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 9.3 Data Sets: 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 9.3 Scalable Performance Data Engine: 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 9.3 Companion for 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 9.3 Data Sets: Reference
|
|
|
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 9.3 Companion for UNIX Environments
|
|
|
BUFSIZE=
0
|
n
|
nK
Specifies the size of a permanent buffer page for
an output SAS data set.
Product: Base SAS
Document: SAS 9.3 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 9.3 Data Sets: 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 9.3 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 9.3 Scalable Performance Data Engine: Reference
|
|
|
CNTLLEV=LIB | MEM | REC
Specifies the level of shared access to a SAS data
set.
Product: Base SAS
Document: SAS 9.3 Data Sets: 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 9.3 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 9.3 Data Sets: 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 9.3 Data Sets: Reference
|
|
|
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 9.3 Data Sets: Reference
|
|
|
ENCODING= ANY | ASCIIANY | EBCDICANY
| encoding-value
Overrides the encoding to use for reading or writing
a SAS data set.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
|
|
|
ENCRYPT=YES | NO
Specifies whether to encrypt an output SPD Engine
data set.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
|
|
|
ENCRYPT=YES | NO
Specifies whether to encrypt an output SAS data
set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
ENDOBS=
n
Specifies the end observation number in a user-defined
range of observations to be processed.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: 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 9.3 Guide to Information Maps
|
|
|
EXTENDOBSCOUNTER=NO | YES
Specifies whether to extend the maximum observation
count in a new output SAS data file.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
FILECLOSE=
DISP
| LEAVE
| REREAD
| REWIND
| FREE
Specifies how a tape is positioned when a SAS data
set is closed.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
|
|
|
FILECLOSE=DISP | LEAVE | REREAD |
REWIND
Specifies how a tape is positioned when a SAS data
set is closed.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
FILEDISP=
NEW
| OLD
Specifies the initial disposition for a sequential
access bound SAS library.
Product: Base SAS
Document: SAS 9.3 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 for subsetting a result set.
Product: Base SAS
Document: Base SAS 9.3 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 9.3 Data Sets: Reference
|
|
|
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 9.3 Data Sets: Reference
|
|
|
GENNUM=
integer
Specifies a particular generation of a SAS data
set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
IDXBY=YES | NO
Specifies whether to use an index when processing
BY statements in the SPD Engine.
Product: Base SAS
Document: SAS 9.3 Scalable Performance Data Engine: Reference
|
|
|
IDXNAME=
index-name
Directs SAS to use a specific index to match the
conditions of a WHERE expression.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
IDXWHERE=YES | NO
Specifies to use indexes when processing WHERE expressions
in the SPD Engine.
Product: Base SAS
Document: SAS 9.3 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 9.3 Data Sets: Reference
|
|
|
IN=
variable
Creates a Boolean variable that indicates whether
the data set contributed data to the current observation.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
INDEX=(index-specification-1 ...<
index-specification-n
> )
Defines an index for a new output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
IOBLOCKSIZE=
n
Specifies the size in bytes of a block of observations
to be used in an I/O operation.
Product: Base SAS
Document: SAS 9.3 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 9.3 Data Sets: Reference
|
|
|
LABEL='label'
Specifies a label for a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: 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 9.3 Scalable Performance Data Engine: 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 9.3 Data Sets: Reference
|
|
|
OBSBUF=
n
Determines the size of the view buffer for processing
a DATA step view.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
OUTREP=
format
Specifies
the data representation for the output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
Specifies the data representation for the output
SAS data set.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
|
|
|
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 9.3 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 9.3 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 9.3 Data Sets: 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 9.3 Companion for 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 9.3 Data Sets: Reference
|
|
|
PWREQ=YES | NO
Specifies whether to display a dialog box to enter
a SAS data set password.
Product: Base SAS
Document: SAS 9.3 Data Sets: 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 9.3 Data Sets: Reference
|
|
|
READBUFF=
integer
Specifies the number of rows to hold in memory for
input into SAS.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
|
|
|
RENAME=(old-name-1=new-name-1
< ...old-name-n=new-name-n
> )
Changes the name of a variable.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
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 9.3 Data Sets: Reference
|
|
|
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 9.3 Data Sets: Reference
|
|
|
REUSE=NO | YES
Specifies whether new observations can be written
to freed space in compressed SAS data sets.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
ROLE= FACT | DIMENSION
| DIM
Identifies the fact table for a star schema join.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
SGIO= YES| NO
Activates the Scatter and Gather I/O feature for
a data set.
Product: Base SAS
Document: SAS 9.3 Companion for Windows
|
|
|
SORTEDBY=
by-clause
</ collate-name
> | _NULL_
Specifies how a data set is currently sorted.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
SPILL=YES | NO
Specifies whether to create a spill file for non-sequential
processing of a DATA step view.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
STARTOBS=
n
Specifies the starting observation number in a user-defined
range of observations to be processed.
Product: Base SAS
Document: SAS 9.3 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 9.3 Scalable Performance Data Engine: 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 9.3 Scalable Performance Data Engine: Reference
|
|
|
TOBSNO=
n
Specifies the number of observations to send in
a client/server transfer.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
TYPE=
data-set-type
Specifies the data set type for a specially structured
SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
|
|
|
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 9.3 Scalable Performance Data Engine: 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 9.3 Companion for 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 9.3 Data Sets: Reference
|
|
|
WHERENOINDEX=(name1 name2...)
Specifies a list of indexes to exclude when making
WHERE expression evaluations.
Product: Base SAS
Document: SAS 9.3 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 9.3 Data Sets: 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 9.3 Data Sets: Reference
|
|
Name
|
Syntax and Description
|
|---|---|
|
AUTHID=
authorization-ID
Lets you qualify the specified table with an authorization
ID, user ID, or group ID.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
AUTOCOMMIT=YES | NO
Specifies whether to enable the DBMS autocommit
capability.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
AUTOCOMMIT=YES | NO
Determines whether the ACCESS engine commits (saves)
updates as soon as you submit them.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
|
|
|
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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_BADDATA_FILE=
filename
Specifies where to put records that failed to process
internally.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_CLIENT_DATAFILE=
path-and-data-filename
Specifies the client view of the data file that
contains DBMS data for bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_CODEPAGE=
numeric-code-page-ID
Identifies the code page that the DBMS engine uses
to convert SAS character data to the current database code page during
bulk load.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_DATAFILE=
path-and-data-filename
Identifies the file that contains control statements.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_DB2LDCT2='string'
Specifies a string in the LOAD utility control statement
between INTO TABLE and ().
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_DB2LDCT3='string'
Specifies a string in the LOAD utility control statement
after ().
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_DB2PRNLOG=YES | NO
Determines whether to write SYSPRINT output to the
SAS log.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_DB2TBLXST=YES | NO
Indicates whether the LOAD utility runs against
an existing table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_DBNAME='database-name'
Specifies the database name to use for bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_DEFAULT_DIR=<host-specific-directory-path>
Specifies where bulk load creates all intermediate
files.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_DELETE_DATAFILE=YES | NO
Specifies whether to delete only the data file or
all files that the SAS/ACCESS engine creates for the DBMS bulk-load
facility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_DELETE_ONLY_DATAFILE=YES | NO
Specifies whether to delete the data file that the
SAS/ACCESS engine creates for the DBMS bulk-load facility.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_DIRECT_PATH=YES | NO
Sets the Oracle SQL*Loader DIRECT option.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_ENCODING=
character-set-encoding
Specifies the character set encoding to use for
the external table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_ESCAPE='<any-single-character>'
Specifies the single character to use for C escape
sequences.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_EXECUTE_CMD=
command | script
Specifies the operating system command for segment
instances to run.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_EXECUTE_LOCATION=ALL | MASTER
| HOST [segment-hostname], number-of-segments | SEGMENT <segmentID> Specifies which segment instances runs the given
command.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_EXTERNAL_WEB=YES | NO
Specifies whether the external data set accesses
a dynamic data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_FORCE_NOT_NULL=YES | NO
Specifies how to process CSV column values.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_FORMAT=TEXT | CSV
Specifies the format of the external or web table
data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_HEADER=YES | NO
Indicates whether to skip or load the first record
in the input data file.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_HOST='hostname' [Aster nCluster]
BL_HOST='localhost' [Greenplum]
Specifies the host name or IP address of the server
where the external data file is stored.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_HOSTNAME=
hostname
Specifies the unqualified host name of the HP Neoview
machine.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_LOAD_REPLACE=YES | NO
Specifies whether DB2 appends or replaces rows during
bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_LOCATION=http://file-location
Specifies the location of a file on a Web server
for segment hosts to access.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_METHOD=CLILOAD
Specifies the bulk-load method to use for DB2.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_NULL='\N' | empty-value
Specifies the string that represents a null value.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_NUM_ROW_SEPS=<integer>
Specifies the number of newline characters to use
as the row separator for the load or extract data stream.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_OPTIONS='<
option…,option
> ' [DB2
under UNIX and PC Hosts, OLE DB, Oracle]
BL_OPTIONS='<<
option
> > <<
value> ...
'> [Aster nCluster, Netezza, Sybase IQ]
Passes options to the DBMS bulk-load facility, which
affects how it loads and processes data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_PATH='path'
Specifies the path to use for bulk loading.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_PORT=
<
port
>
Specifies the port number to use.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_PORT_MAX=
<
integer
>
Sets the highest available port number for concurrent
uploads.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_PORT_MIN=
<
integer
>
Sets the lowest available port number for concurrent
uploads.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_PROTOCOL='gpfdist' | 'file' | 'http'
Specifies the protocol to use.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_QUOTE="
Specifies the quotation character for CSV mode.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_RECOVERABLE=YES | NO
Determines whether the LOAD process is recoverable.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_REJECT_LIMIT=
number
Specifies the reject limit count.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_REJECT_TYPE=ROWS | PERCENT
Indicates whether the reject limit count is a number
of rows or a percentage of total rows.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_RETURN_WARNINGS_AS_ERRORS=YES |
NO
Specifies whether SQL*Loader (bulk-load) warnings
should surface in SAS through the SYSERR macro as warnings or as errors.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_SERVER_DATAFILE=
path-and-data-filename
Specifies the name and location of the data file
that the DBMS server instance sees.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_SQLLDR_PATH=
pathname
Specifies the location of the SQLLDR executable
file.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BL_STREAMS=
<
number
>
Specifies the value for the HP Neoview Transporter
parallel streams option.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_SYNCHRONOUS=YES | NO
Specifies how to process source file record sets.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_TENACITY=
number-of-seconds
Specifies how long the HP Neoview Transporter waits
before trying again.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BL_USE_PIPE=YES | NO
Specifies a named pipe for data transfer.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
BULKEXTRACT=YES | NO
Rapidly retrieves (fetches) large number of rows
from a data set.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BULKLOAD=YES | NO
Loads rows of data as one unit.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
BULKUNLOAD=YES | NO
Rapidly retrieves (fetches) large number of rows
from a data set.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
CAST=YES | NO
Specifies whether SAS or the Teradata DBMS server
should perform data conversions.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
COMMAND_TIMEOUT=
number-of-seconds
Specifies the number of seconds to wait before a
command times out.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
COMMAND_TIMEOUT=
number-of-seconds
Specifies the number of seconds to wait before a
command times out.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
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 9.3 Interface to PC Files: Reference
|
|
|
You can specify SAS/ACCESS data set options on a
SAS data set when you access PC files data with the LIBNAME Statement
Syntax for PC Files on Linux and UNIX.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
|
|
|
DB_ONE_CONNECT_PER_THREAD=YES | NO
Specifies whether to limit the number of connections
to the DBMS server for a threaded read.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: 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 9.3 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 9.3 Interface to PC Files: Reference
|
|
|
DBCONDITION=
"DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS
data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
DBCONDITION=
SQL-query-clause
Specifies criteria for subsetting and ordering data.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
|
|
|
DBCONSTRAINT='DBMS-SQL-clauses'
Provides table-level definitions to specify when
a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
DBCREATE_TABLE_OPTS=
'DBMS-SQL-clauses'
Specifies DBMS-specific syntax to add to the CREATE
TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
DBCREATE_TABLE_OPTS=
'SQL-clauses'
Specifies data source-specific syntax to add to
the CREATE TABLE statement.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
|
|
|
DBENCODING=
12–byte SAS encoding-value
Specifies the encoding character set to use in the
Microsoft Access database or in the Microsoft Excel workbook.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
|
|
|
DBFORCE=YES | NO
Specifies whether to force data truncation during
insert processing.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
DBFORCE= YES | NO
Specifies whether to force the truncation of data
during insert processing.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 Interface to PC Files: Reference
|
|
|
DBINDEX=YES | NO | <'>index-name<'>
Detects and verifies that indexes exist on a DBMS
table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
DBKEY=(<'>
column-1
<'>
<… <'>
column-n
<'>
> )
Specifies a key column to optimize DBMS retrieval.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
DBKEY=
<
('column-1' ... 'column-n')
>
Improves performance for a join with a large source
table and a small SAS data set (specifies a column to use as an index).
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 Interface to PC Files: 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 9.3 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 9.3 for Relational Databases: 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 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
DBNULL=
(< column-name-1 > =YES|NO < column-name-n > =YES|NO < _ALL_ > =YES|NO) Specifies whether NULL is a valid value for the
specified columns when a table is created.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 Interface to PC Files: Reference
|
|
|
DBPROMPT=YES | NO
Specifies whether SAS displays a window that prompts
you to enter DBMS connection information.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
DBSASLABEL=COMPAT | NONE
Specifies how the engine returns column labels.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 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 9.3 Interface to PC Files: 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 9.3 for Relational Databases: Reference
|
|
|
DBSLICEPARM=NONE | THREADED_APPS |
ALL
DBSLICEPARM=( NONE | THREADED_APPS
| ALL<
max-threads
> )
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 9.3 for Relational Databases: 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 9.3 for Relational Databases: Reference
|
|
|
DBTYPE=(<
column-name-1
> =<
data-source-type
> ...
< column-name-1 > =< 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 9.3 Interface to PC Files: Reference
|
|
|
DEGREE=ANY | 1
Determines whether DB2 uses parallelism.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
DIMENSION=YES | NO
Specifies whether the database creates dimension
tables or fact tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
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 9.3 for Relational Databases: Reference
|
|
|
DISTRIBUTED_BY='column-1 <... ,column-n>' | RANDOMLY DISTRIBUTED
Uses one or multiple columns to distribute table
rows across database segments.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: 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 9.3 for Relational Databases: 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 9.3 Interface to PC Files: 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 9.3 for Relational Databases: Reference
|
|
|
FETCH_IDENTITY=YES | NO
Returns the value of the last inserted identity
value.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
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 9.3 for Relational Databases: Reference
|
|
|
IN=
'database-name.tablespace-name'|'DATABASE database-name'
Lets you specify the database or table space in
which you want to create a new table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
INSERT_SQL=YES | NO
Determines the method to use to insert rows into
a data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
INSERT_SQL=YES | NO
Determines the method to use to insert rows into
a data source.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
|
|
|
INSERTBUFF=
positive-integer
Specifies the number of rows in a single DBMS insert.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
INSERTBUFF=
number-of-rows
Specifies the number of rows in a single insert.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 Interface to PC Files: Reference
|
|
|
KEYSET_SIZE=
number-of-rows
Specifies the number of rows in the cursor that
the keyset drives.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
LOCATION=
location-name
Lets you further specify exactly where a table resides.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
LOCKTABLE=EXCLUSIVE | SHARE
Places exclusive or shared locks on tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
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 9.3 for Relational Databases: Reference
|
|
|
ML_CHECKPOINT=
checkpoint-rate
Specifies the interval between checkpoint operations
in minutes.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 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 9.3 for Relational Databases: 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 9.3 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 9.3 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 9.3 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 9.3 Interface to PC Files: 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
ORHINTS=
'Oracle-hint'
Specifies Oracle hints to pass to Oracle from a
SAS statement or SQL procedure.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
PARTITION_KEY='column-name'
Specifies the column name to use as the partition
key for creating fact tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
PRESERVE_COL_NAMES=YES | NO
Preserves spaces, special characters, and case sensitivity
in DBMS column names when you create DBMS tables.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
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 9.3 for Relational Databases: Reference
|
|
|
QUERY_BAND=”pair-name=pair_value” FOR TRANSACTION;
Specifies whether to set a query band for the current
transaction.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
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 9.3 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 9.3 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 9.3 for Relational Databases: Reference
|
|
|
READBUFF=
integer
Specifies the number of rows of DBMS data to read
into the buffer.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
READBUFF=
<
number-of-rows
>
Specifies the number of rows of data to read into
the buffer.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: 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 9.3 Interface to PC Files: Reference
|
|
|
SCHEMA=
schema-name
Allows reading of such database objects as tables
and views in the specified schema.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 for Relational Databases: Reference
|
|
|
SESSIONS=
number-of-sessions
Specifies how many Teradata sessions to be logged
on when using FastLoad, FastExport, or Multiload.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
SET=YES | NO
Specifies whether duplicate rows are allowed when
creating a table.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
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 9.3 for Relational Databases: Reference
|
|
|
TEMPORAL_QUALIFIER=CURRENT VALIDTIME
| VALIDTIME AS OF PERIOD 'period' | SEQUENCED VALIDTIME | NONSEQUENCED VALIDTIME 'period'
TEMPORAL_QUALIFIER=CURRENT TRANSACTIONTIME
| TRANSACTIONTIME AS OF PERIOD 'period' | NONSEQUENCED TRANSACTIONTIME Specifies time-dimension criteria for retrieving
data from Teradata.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: 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 9.3 for Relational Databases: Reference
|
|
|
TPT=YES | NO
Specifies whether SAS uses the TPT API to load data
for Fastload, MultiLoad, or Multi-Statement insert requests.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_APPL_PHASE=YES | NO
Specifies whether a load process that is being restarted
has failed in the application phase.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_BUFFER_SIZE=
integer
Specifies the output buffer size in kilobytes when
SAS sends data to Teradata with Fastload or MultiLoad using the TPT
API.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_CHECKPOINT_DATA=
checkpoint_data_in_error_message
Specifies the checkpoint data to return to Teradata
when restarting a failed MultiLoad or Multi-Statement step that uses
the TPT API.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_DATA_ENCRYPTION=YES | NO
Specifies whether to fully encrypt SQL requests,
responses, and data when SAS sends data to Teradata for Fastload,
MultiLoad, or Multi-Statement insert that uses the TPT API.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_ERROR_TABLE_1=
valid_teradata_table_name
Specifies the name of the first error table for
SAS to use when using the TPT API with Fastload or MultiLoad.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_ERROR_TABLE_2=
valid_teradata_table_name
Specifies the name of the second error table for
SAS to use when using the TPT API with Fastload or MultiLoad.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_LOG_TABLE=
valid_teradata_table_name
Specifies the name of the restart log table for
SAS to use when using the TPT API with Fastload, MultiLoad, or Multi-Statement
insert.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_MAX_SESSIONS=
integer
Specifies the maximum number of sessions for Teradata
to use when using the TPT API with FastLoad, MultiLoad, or Multi-Statement
insert.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_MIN_SESSIONS=
integer
Specifies the minimum number of sessions for Teradata
to use when using the TPT API with FastLoad, MultiLoad, or Multi-Statement
insert.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_PACK=
integer
Specifies the number of statements to pack into
a Multi-Statement insert request when using the TPT API.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_PACKMAXIMUM=
YES | NO
Specifies whether to pack the maximum possible or
default number of statements into Multi-Statement insert requests
when using the TPT API.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_RESTART=YES | NO
Specifies that a failed Fastload, MultiLoad, or
Multi-Statement run that used the TPT API is being restarted.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_TRACE_LEVEL=
integer
Specifies the required tracing level for sending
data to Teradata and using the TPT API with Fastload, MultiLoad, or
Multi-Statement insert.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_TRACE_LEVEL_INF=
integer
Specifies the tracing level for the required infrastructure
for sending data to Teradata and using the TPT API with Fastload,
MultiLoad, or Multi-Statement insert.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_TRACE_OUTPUT=
integer
Specifies the name of the external file for SAS
to use for tracing when using the TPT API with Fastload, MultiLoad,
or Multi-Statement insert.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TPT_WORK_TABLE=
valid_teradata_table_name
Specifies the name of the work table for SAS to
use when using the TPT API with MultiLoad.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 for Relational Databases: Reference
|
|
|
TRAP151=YES | NO
Enables removal of columns that cannot be updated
from a FOR UPDATE OF clause so that update of columns can proceed
as normal.
Product: SAS/ACCESS
Document: SAS/ACCESS 9.3 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 9.3 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 9.3 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 9.3 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 9.3 for Relational Databases: 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 9.3 for Relational Databases: Reference
|
|
Name
|
Syntax and Description
|
|---|---|
|
BATCH=
0
| 1
| Y
| N
Specifies whether SAS uses SAP batch jobs for data
extracts.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
|
|
|
DBCONDITION= "DBMS-SQL-query-clause"
Specifies criteria for subsetting and ordering DBMS
data.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
|
|
|
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 Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
|
|
|
DBKEY= (<'>
column-1
<'>
<
... <'>column-n<'>
>)
Specifies a key column to optimize DBMS retrieval.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
|
|
|
DBMASTER=YES
Designates which is the larger table when you process
a join of tables from two different types of databases.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
|
|
|
NULLCHAR=
SAS
| YES
| NO
Indicates how missing SAS character values are handled
during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
|
|
|
NULLCHARVAL= 'character-string'
Defines the character string that replaces missing
SAS character values during insert, update, DBINDEX=, and DBKEY= processing.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
|
|
|
REREAD_EXPOSURE=
NO
| YES
Specifies whether the SAS/ACCESS engine behaves
like a random-access engine for the scope of the LIBNAME statement.
Product: SAS/ACCESS Interface to R/3
Document: SAS/ACCESS 4.4 Interface to R/3: User's Guide
|