Table Action Set: Syntax
Provides actions for accessing and managing data
save Action
Saves a table to a caslib's data source.
| See: | Saving Tables and Exporting Data |
|---|---|
| Examples: | Save a Table |
| Save a SAS7BDAT File in a Caslib |
CASL Syntax
Summary: Input Tables
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametertable |
— |
specifies the table name, caslib, and other common parameters. |
Parameter Descriptions
caslib="string"
specifies the target caslib for the table.
compress=TRUE | FALSE
when set to True, applies data compression to the table.
| Default | FALSE |
|---|
copies=integer
specifies the number of redundant copies to make for the rows. Larger values provide greater fault tolerance for node failures but use more memory. Specifying 0 results in no fault tolerance in the event of a node failure.
| Minimum value | -1 |
|---|
dataSourceOptions={adls-parameters | bigquery-parameters | clouddex-parameters | db2-parameters | hadoop-parameters | hana-parameters | impala-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | postgres-parameters | redshift-parameters | sforce-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | teradata-parameters | vednfs-parameters | vepath-parameters | vertica-parameters | ves3-parameters | yellowbrick-parameters}
specifies data source options.
| Alias | options |
|---|
exportOptions={fileType="AUTO" | "BASESAS" | "CSV" | "DTA" | "EXCEL" | "JMP" | "ORC" | "SPSS" | "XLS", fileType-specific-parameters}
specifies the settings for saving a table to a data source.
| Alias | export |
|---|
The value that you specify for the fileType parameter determines the other parameters that apply.
* name="string"
specifies the table name.
permission="GROUPREAD" | "GROUPWRITE" | "GROUPWRITEPUBLICREAD" | "PRIVATE" | "PUBLICREAD" | "PUBLICWRITE" | integer
specifies the host access controls on the saved file. This parameter applies to servers that run Linux only. This parameter applies to saving SASHDAT and CSV files in PATH, and DNFS caslibs. For other data sources and file types, refer to the corresponding documentation.
replace=TRUE | FALSE
when set to True, an existing table with the same name is overwritten.
| Default | FALSE |
|---|
saveAttrs=TRUE | FALSE
when set to True, attributes are automatically saved in a file that is named table-name.ATTRS.sashdat. The file is saved in the same caslib that is used for saving the table. This parameter applies to path-based caslibs only.
| Default | FALSE |
|---|
* table={castable}
specifies the table name, caslib, and other common parameters.
For more information about specifying the table parameter, see the common castable parameter.
viewAsTable=TRUE | FALSE
when set to True and the table parameter identifies a view, the contents of the view are saved. By default, the definition of the view is saved.
| Default | FALSE |
|---|
Parameters for ADLS
accountName="string"
Azure storage account name
applicationId="string"
Application ID for Azure storage
dnsSuffix="string"
DNS Suffix for Azure storage
filesystem="string"
Azure storage file system
timeout=integer
Azure storage operation timeout value in seconds
| Default | 60 |
|---|---|
| Minimum value | 0 |
Parameters for BIGQUERY
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bulkload=TRUE | FALSE
when set to TRUE, data is written to Google BigQuery using the Go Loader.Run function.
| Default | FALSE |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=TRUE | FALSE
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
qualifier="string"
specifies an alternate project ID to be used in table references in SQL queries
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for CLOUDDEX
append=TRUE | FALSE
| Default | FALSE |
|---|
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
casTypes="ALL" | "BASIC"
ALL
specifies that data types include CHAR and VARCHAR for text. Numeric columns support INTEGER, 64-bit INTEGER, DATE, DATETIME, and TIME. BINARY and VARBINARY are also available.
BASIC
specifies that data types are limited to DOUBLE, CHAR, and VARCHAR.
catalog="string"
specifies the database catalog name.
charCreateMultiplier=double
| Default | 1 |
|---|---|
| Range | 1–5 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
domainCredsRequired=TRUE | FALSE
| Default | TRUE |
|---|
dropTableOnFailedSave=TRUE | FALSE
| Default | TRUE |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
ncharCreateMultiplier=double
| Default | 1 |
|---|---|
| Range | 1–5 |
ncharMultiplier=double
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|
pwd="string"
specifies the password.
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
traceFile="string"
specifies a name for the trace file.
traceFlags="string"
specifies flags to use for tracing the database connection.
uid="string"
specifies the user name.
useMaxCharLen=TRUE | FALSE
| Default | FALSE |
|---|
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for DB2
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for HADOOP
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
bulkLoad=TRUE | FALSE
Specifies whether Bulk Loading should be used for inserting rows.
| Default | TRUE |
|---|
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies the maximum length for STRING data type columns. For Hive, this parameter does not apply to CHAR or VARCHAR columns.
| Default | 32767 |
|---|---|
| Minimum value | 1 |
hdfsDatadir="string"
specifies the path to an HDFS directory that will be used to store the data when saving a Cloud Analytic Services table.
hdfsMetadir="string"
specifies the path to an HDFS directory that contains XML-based table definitions, called SASHDMD descriptors.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
insertbuff=integer
specifies the number of rows to insert in one write block.
loginTimeout=integer
Specifies the login time-out in seconds for connecting to the data source.
| Default | 30 |
|---|---|
| Minimum value | 0 |
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
platform="MAPRED" | "SPARK"
MAPRED
Specifies to run EP jobs on the Map Reduce platform.
SPARK
Specifies to run EP jobs on the Spark platform.
postTableOpts="string"
Specifies additional database-specific options to be placed after the table name in a CREATE TABLE statement.
preTableOpts="string"
Specifies additional database-specific options to be placed before the table name in a CREATE TABLE statement.
pwd="string"
specifies the password.
readbuff=integer
specifies the number of rows to read in one read block.
| Alias | ras row_array_size |
|---|
schema="string"
specifies the name of the Hive schema.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for HANA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
specifies connection options to use for connecting to the database.
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
Parameters for IMPALA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bulkload=TRUE | FALSE
| Default | FALSE |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for JDBC
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
login_timeout=integer
specifies the number of seconds to wait for a connection attempt before returning an error.
| Alias | loginTimeout |
|---|---|
| Minimum value | 0 |
pwd="string"
query_timeout=integer
specifies the number of seconds to wait for a query to finish executing before returning an error.
| Alias | queryTimeout |
|---|---|
| Minimum value | 0 |
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for MONGODB
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for MYSQL
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for ODBC
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for ORACLE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for POSTGRES
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for REDSHIFT
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
awsConfig="string"
specifies the AWS configuration file if different from the default.
blOptions="string"
specifies any additional COPY options that are added to the end of the COPY command.
bucket="string"
specifies the S3 bucket name (and subdirectory, if applicable) to write data files.
bulkload=TRUE | FALSE
when set to TRUE, data is written to Redshift using the COPY command.
| Default | FALSE |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress=TRUE | FALSE
when set to TRUE, use GZIP compression on data files.
| Default | FALSE |
|---|
conopts="string"
credentialsFile="string"
specifies the AWS credentials file to use.
credentialsProfile="string"
specifies the AWS profile name in the AWS credentials file to use if using an account with multiple profiles.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=TRUE | FALSE
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
escape=TRUE | FALSE
when set to TRUE, any restricted characters in string data are escaped to allow processing with COPY.
| Default | FALSE |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
key="string"
specifies the Amazon Web Services access key that is used with key-based access control.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
profile="string"
specifies the AWS profile to use if using an account with multiple profiles.
pwd="string"
region="string"
specifies the Amazon Web Services region that the Redshift server resides for bulk-load.
s3Config="string"
specifies an optional S3 configuration file
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
secret="string"
specifies the Amazon Web Services secret access key that is used with key-based access control.
token="string"
specifies a temporary token that is associated with the temporary credentials that you specify with the secret and key options.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
useSSL=TRUE | FALSE
when set to TRUE, create an SSL connection to S3 when transmitting data files.
| Default | FALSE |
|---|
Parameters for SFORCE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for SNOWFLAKE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
awsConfig="string"
specifies the AWS configuration file if different from the default.
blOptions="string"
specifies any additional COPY options that are added to the end of the COPY command.
bucket="string"
specifies the S3 bucket name (and subdirectory, if applicable) to write data files.
bulkload=TRUE | FALSE
when set to TRUE, data is written to Snowflake using the COPY INTO command.
| Default | FALSE |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress=TRUE | FALSE
when set to TRUE, use GZIP compression on data files.
| Default | FALSE |
|---|
conopts="string"
credentialsFile="string"
specifies the AWS credentials file to use.
credentialsProfile="string"
specifies the AWS profile name in the AWS credentials file to use if using an account with multiple profiles.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=TRUE | FALSE
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
escape=TRUE | FALSE
when set to TRUE, any restricted characters in string data are escaped to allow processing with COPY.
| Default | FALSE |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
key="string"
specifies the Amazon Web Services access key that is used with key-based access control.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
profile="string"
specifies the AWS profile to use if using an account with multiple profiles.
pwd="string"
region="string"
specifies the Amazon Web Services region that the Snowflake server resides for bulk-load.
s3Config="string"
specifies an optional S3 configuration file
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
secret="string"
specifies the Amazon Web Services secret access key that is used with key-based access control.
stage="string"
specifies the internal stage including path to use for bulk-load.
token="string"
specifies a temporary token that is associated with the temporary credentials that you specify with the secret and key options.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
useSSL=TRUE | FALSE
when set to TRUE, create an SSL connection to S3 when transmitting data files.
| Default | FALSE |
|---|
Parameters for SPARK
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
bulkLoad=TRUE | FALSE
Specifies whether Bulk Loading should be used for inserting rows.
| Default | TRUE |
|---|
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies the maximum length for STRING data type columns. For Hive, this parameter does not apply to CHAR or VARCHAR columns.
| Default | 1024 |
|---|---|
| Minimum value | 1 |
hdfsDatadir="string"
specifies the path to an HDFS directory that will be used to store the data when saving a Cloud Analytic Services table.
hdfsMetadir="string"
specifies the path to an HDFS directory that contains XML-based table definitions, called SASHDMD descriptors.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
insertbuff=integer
specifies the number of rows to insert in one write block.
loginTimeout=integer
Specifies the login time-out in seconds for connecting to the data source.
| Default | 30 |
|---|---|
| Minimum value | 0 |
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
postTableOpts="string"
Specifies additional database-specific options to be placed after the table name in a CREATE TABLE statement.
preTableOpts="string"
Specifies additional database-specific options to be placed before the table name in a CREATE TABLE statement.
pwd="string"
specifies the password.
readbuff=integer
specifies the number of rows to read in one read block.
| Alias | ras row_array_size |
|---|
schema="string"
specifies the name of the Hive schema.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for SPDE
alterPW="string"
specifies the password to use for Alter access.
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress="BINARY" | "CHAR" | "NO" | "YES"
BINARY
Binary SPDE Compression
CHAR
Char SPDE Compression
NO
No SPDE Compression
YES
Yes SPDE Compression
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
datapath="string"
specifies the path to place data files for created SPDE tables.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
encrypt="AES" | "NO" | "YES"
AES
AES SPDE Encryption
NO
No SPDE Encryption
YES
Proprietary SPDE Encryption
encryptionPassword="string"
specifies the passphrase used for an AES encrypted data set.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
label="string"
specifies a label to apply to the output data set.
masterPW="string"
specifies the master password to use for Read/Write/Alter access.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
mdfpath="string"
specifies the path where SPDE MDF are located.
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteBuffers=integer
specifies the number of write buffers to use for the pipeline write.
| Default | 10 |
|---|---|
| Range | 1–100 |
padCompress=integer
specifies the size of additional padding to allow for compressed SPDE tables. This enables subsequent updates to perform more efficiently.
partSize=64-bit-integer
specifies the partition size (in number of MBs) to use for created SPDE tables.
| Minimum value | 16 |
|---|
platform="MAPRED" | "SPARK"
MAPRED
Specifies to run EP jobs on the Map Reduce platform.
SPARK
Specifies to run EP jobs on the Spark platform.
pwd="string"
specifies the password.
readPW="string"
specifies the password to use for Read access.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
writePW="string"
specifies the password to use for Write access.
Parameters for SQLSERVER
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for TERADATA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
specifies connection options to use for connecting to the Teradata database.
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies a Teradata Max Text Size value in chars.
| Default | 32000 |
|---|---|
| Range | 1–32000 |
insertbuff=integer
specifies the number of rows to insert in one write block.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
specifies the password.
schema="string"
Unused
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for VEDNFS
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
Parameters for VEPATH
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
Parameters for VERTICA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for VES3
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
kmsContext="string"
specifies the AWS Key Management Services encryption context for the cryptographic operation.
kmsKeyId="string"
specifies the AWS Key Management Services ID.
sseHexKey="string"
specifies an encryption key in the form of a 64-digit hexadecimal value.
sseTextKey="string"
specifies a plain-text version of the key to use with server-side encryption.
Parameters for YELLOWBRICK
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for fileType="AUTO"
No parameters apply when you specify AUTO
Parameters for fileType="BASESAS"
compress="BINARY" | "CHAR" | "NO" | "YES"
when set to True, applies data compression to the table.
| Default | NO |
|---|
encoding="string"
specifies file encoding
encrypt="AES" | "AES2" | "NO" | "YES"
specifies whether to encrypt an output SAS data set
| Default | NO |
|---|
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
password="string"
specifies the password for a password-protected data set. Use this parameter if the data set is password-protected or uses SAS proprietary encryption.
pointobs=TRUE | FALSE
specifies whether SAS creates compressed data sets whose observations can be randomly accessed or sequentially accessed
| Default | TRUE |
|---|
read="string"
specifies the Read password for the SAS data set.
reuse=TRUE | FALSE
specifies whether new rows can be written to freed space in a compressed SAS data set
| Default | FALSE |
|---|
Parameters for fileType="CSV" | "DELIMITED"
addbom=TRUE | FALSE
when set to True, the file includes a byte-order mark (BOM) at the beginning of the file. The BOM can help programs such as Microsoft Excel to interpret national characters in text fields correctly. By default, the BOM is not added to the file.
| Default | FALSE |
|---|
Parameters for fileType="DTA"
No parameters apply when you specify DTA
Parameters for fileType="EXCEL"
range="string"
specifies a subset of the cells to import. For example, the range B2..E8 is the range address for a rectangular block of 12 cells, where the top left cell is B2 and the bottom right cell is E8.
sheet="string"
specifies the name of the worksheet to import.
Parameters for fileType="JMP"
No parameters apply when you specify JMP
Parameters for fileType="ORC"
compress="NO" | "YES" | "ZLIB"
when set to True, applies data compression to the table.
| Default | ZLIB |
|---|
Parameters for fileType="SPSS"
No parameters apply when you specify SPSS
Parameters for fileType="XLS"
range="string"
specifies a subset of the cells to import. For example, the range B2..E8 is the range address for a rectangular block of 12 cells, where the top left cell is B2 and the bottom right cell is E8.
sheet="string"
specifies the name of the worksheet to import.
save Action
Saves a table to a caslib's data source.
| See: | Saving Tables and Exporting Data |
|---|---|
| Examples: | Save a Table |
| Save a SAS7BDAT File in a Caslib |
Lua Syntax
Summary: Input Tables
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametertable |
— |
specifies the table name, caslib, and other common parameters. |
Parameter Descriptions
caslib="string"
specifies the target caslib for the table.
compress=true | false
when set to True, applies data compression to the table.
| Default | false |
|---|
copies=integer
specifies the number of redundant copies to make for the rows. Larger values provide greater fault tolerance for node failures but use more memory. Specifying 0 results in no fault tolerance in the event of a node failure.
| Minimum value | -1 |
|---|
dataSourceOptions={adls-parameters | bigquery-parameters | clouddex-parameters | db2-parameters | hadoop-parameters | hana-parameters | impala-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | postgres-parameters | redshift-parameters | sforce-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | teradata-parameters | vednfs-parameters | vepath-parameters | vertica-parameters | ves3-parameters | yellowbrick-parameters}
specifies data source options.
| Alias | options |
|---|
exportOptions={fileType="AUTO" | "BASESAS" | "CSV" | "DTA" | "EXCEL" | "JMP" | "ORC" | "SPSS" | "XLS", fileType-specific-parameters}
specifies the settings for saving a table to a data source.
| Alias | export |
|---|
The value that you specify for the fileType parameter determines the other parameters that apply.
* name="string"
specifies the table name.
permission="GROUPREAD" | "GROUPWRITE" | "GROUPWRITEPUBLICREAD" | "PRIVATE" | "PUBLICREAD" | "PUBLICWRITE" | integer
specifies the host access controls on the saved file. This parameter applies to servers that run Linux only. This parameter applies to saving SASHDAT and CSV files in PATH, and DNFS caslibs. For other data sources and file types, refer to the corresponding documentation.
replace=true | false
when set to True, an existing table with the same name is overwritten.
| Default | false |
|---|
saveAttrs=true | false
when set to True, attributes are automatically saved in a file that is named table-name.ATTRS.sashdat. The file is saved in the same caslib that is used for saving the table. This parameter applies to path-based caslibs only.
| Default | false |
|---|
* table={castable}
specifies the table name, caslib, and other common parameters.
For more information about specifying the table parameter, see the common castable parameter.
viewAsTable=true | false
when set to True and the table parameter identifies a view, the contents of the view are saved. By default, the definition of the view is saved.
| Default | false |
|---|
Parameters for ADLS
accountName="string"
Azure storage account name
applicationId="string"
Application ID for Azure storage
dnsSuffix="string"
DNS Suffix for Azure storage
filesystem="string"
Azure storage file system
timeout=integer
Azure storage operation timeout value in seconds
| Default | 60 |
|---|---|
| Minimum value | 0 |
Parameters for BIGQUERY
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bulkload=true | false
when set to TRUE, data is written to Google BigQuery using the Go Loader.Run function.
| Default | false |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=true | false
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
qualifier="string"
specifies an alternate project ID to be used in table references in SQL queries
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for CLOUDDEX
append=true | false
| Default | false |
|---|
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
casTypes="ALL" | "BASIC"
ALL
specifies that data types include CHAR and VARCHAR for text. Numeric columns support INTEGER, 64-bit INTEGER, DATE, DATETIME, and TIME. BINARY and VARBINARY are also available.
BASIC
specifies that data types are limited to DOUBLE, CHAR, and VARCHAR.
catalog="string"
specifies the database catalog name.
charCreateMultiplier=double
| Default | 1 |
|---|---|
| Range | 1–5 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
domainCredsRequired=true | false
| Default | TRUE |
|---|
dropTableOnFailedSave=true | false
| Default | TRUE |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
ncharCreateMultiplier=double
| Default | 1 |
|---|---|
| Range | 1–5 |
ncharMultiplier=double
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|
pwd="string"
specifies the password.
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
traceFile="string"
specifies a name for the trace file.
traceFlags="string"
specifies flags to use for tracing the database connection.
uid="string"
specifies the user name.
useMaxCharLen=true | false
| Default | false |
|---|
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for DB2
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for HADOOP
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
bulkLoad=true | false
Specifies whether Bulk Loading should be used for inserting rows.
| Default | TRUE |
|---|
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies the maximum length for STRING data type columns. For Hive, this parameter does not apply to CHAR or VARCHAR columns.
| Default | 32767 |
|---|---|
| Minimum value | 1 |
hdfsDatadir="string"
specifies the path to an HDFS directory that will be used to store the data when saving a Cloud Analytic Services table.
hdfsMetadir="string"
specifies the path to an HDFS directory that contains XML-based table definitions, called SASHDMD descriptors.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
insertbuff=integer
specifies the number of rows to insert in one write block.
loginTimeout=integer
Specifies the login time-out in seconds for connecting to the data source.
| Default | 30 |
|---|---|
| Minimum value | 0 |
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
platform="MAPRED" | "SPARK"
MAPRED
Specifies to run EP jobs on the Map Reduce platform.
SPARK
Specifies to run EP jobs on the Spark platform.
postTableOpts="string"
Specifies additional database-specific options to be placed after the table name in a CREATE TABLE statement.
preTableOpts="string"
Specifies additional database-specific options to be placed before the table name in a CREATE TABLE statement.
pwd="string"
specifies the password.
readbuff=integer
specifies the number of rows to read in one read block.
| Alias | ras row_array_size |
|---|
schema="string"
specifies the name of the Hive schema.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for HANA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
specifies connection options to use for connecting to the database.
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
Parameters for IMPALA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bulkload=true | false
| Default | false |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for JDBC
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
login_timeout=integer
specifies the number of seconds to wait for a connection attempt before returning an error.
| Alias | loginTimeout |
|---|---|
| Minimum value | 0 |
pwd="string"
query_timeout=integer
specifies the number of seconds to wait for a query to finish executing before returning an error.
| Alias | queryTimeout |
|---|---|
| Minimum value | 0 |
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for MONGODB
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for MYSQL
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for ODBC
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for ORACLE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for POSTGRES
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for REDSHIFT
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
awsConfig="string"
specifies the AWS configuration file if different from the default.
blOptions="string"
specifies any additional COPY options that are added to the end of the COPY command.
bucket="string"
specifies the S3 bucket name (and subdirectory, if applicable) to write data files.
bulkload=true | false
when set to TRUE, data is written to Redshift using the COPY command.
| Default | false |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress=true | false
when set to TRUE, use GZIP compression on data files.
| Default | false |
|---|
conopts="string"
credentialsFile="string"
specifies the AWS credentials file to use.
credentialsProfile="string"
specifies the AWS profile name in the AWS credentials file to use if using an account with multiple profiles.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=true | false
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
escape=true | false
when set to TRUE, any restricted characters in string data are escaped to allow processing with COPY.
| Default | false |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
key="string"
specifies the Amazon Web Services access key that is used with key-based access control.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
profile="string"
specifies the AWS profile to use if using an account with multiple profiles.
pwd="string"
region="string"
specifies the Amazon Web Services region that the Redshift server resides for bulk-load.
s3Config="string"
specifies an optional S3 configuration file
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
secret="string"
specifies the Amazon Web Services secret access key that is used with key-based access control.
token="string"
specifies a temporary token that is associated with the temporary credentials that you specify with the secret and key options.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
useSSL=true | false
when set to TRUE, create an SSL connection to S3 when transmitting data files.
| Default | false |
|---|
Parameters for SFORCE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for SNOWFLAKE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
awsConfig="string"
specifies the AWS configuration file if different from the default.
blOptions="string"
specifies any additional COPY options that are added to the end of the COPY command.
bucket="string"
specifies the S3 bucket name (and subdirectory, if applicable) to write data files.
bulkload=true | false
when set to TRUE, data is written to Snowflake using the COPY INTO command.
| Default | false |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress=true | false
when set to TRUE, use GZIP compression on data files.
| Default | false |
|---|
conopts="string"
credentialsFile="string"
specifies the AWS credentials file to use.
credentialsProfile="string"
specifies the AWS profile name in the AWS credentials file to use if using an account with multiple profiles.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=true | false
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
escape=true | false
when set to TRUE, any restricted characters in string data are escaped to allow processing with COPY.
| Default | false |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
key="string"
specifies the Amazon Web Services access key that is used with key-based access control.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
profile="string"
specifies the AWS profile to use if using an account with multiple profiles.
pwd="string"
region="string"
specifies the Amazon Web Services region that the Snowflake server resides for bulk-load.
s3Config="string"
specifies an optional S3 configuration file
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
secret="string"
specifies the Amazon Web Services secret access key that is used with key-based access control.
stage="string"
specifies the internal stage including path to use for bulk-load.
token="string"
specifies a temporary token that is associated with the temporary credentials that you specify with the secret and key options.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
useSSL=true | false
when set to TRUE, create an SSL connection to S3 when transmitting data files.
| Default | false |
|---|
Parameters for SPARK
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
bulkLoad=true | false
Specifies whether Bulk Loading should be used for inserting rows.
| Default | TRUE |
|---|
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies the maximum length for STRING data type columns. For Hive, this parameter does not apply to CHAR or VARCHAR columns.
| Default | 1024 |
|---|---|
| Minimum value | 1 |
hdfsDatadir="string"
specifies the path to an HDFS directory that will be used to store the data when saving a Cloud Analytic Services table.
hdfsMetadir="string"
specifies the path to an HDFS directory that contains XML-based table definitions, called SASHDMD descriptors.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
insertbuff=integer
specifies the number of rows to insert in one write block.
loginTimeout=integer
Specifies the login time-out in seconds for connecting to the data source.
| Default | 30 |
|---|---|
| Minimum value | 0 |
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
postTableOpts="string"
Specifies additional database-specific options to be placed after the table name in a CREATE TABLE statement.
preTableOpts="string"
Specifies additional database-specific options to be placed before the table name in a CREATE TABLE statement.
pwd="string"
specifies the password.
readbuff=integer
specifies the number of rows to read in one read block.
| Alias | ras row_array_size |
|---|
schema="string"
specifies the name of the Hive schema.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for SPDE
alterPW="string"
specifies the password to use for Alter access.
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress="BINARY" | "CHAR" | "NO" | "YES"
BINARY
Binary SPDE Compression
CHAR
Char SPDE Compression
NO
No SPDE Compression
YES
Yes SPDE Compression
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
datapath="string"
specifies the path to place data files for created SPDE tables.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
encrypt="AES" | "NO" | "YES"
AES
AES SPDE Encryption
NO
No SPDE Encryption
YES
Proprietary SPDE Encryption
encryptionPassword="string"
specifies the passphrase used for an AES encrypted data set.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
label="string"
specifies a label to apply to the output data set.
masterPW="string"
specifies the master password to use for Read/Write/Alter access.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
mdfpath="string"
specifies the path where SPDE MDF are located.
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteBuffers=integer
specifies the number of write buffers to use for the pipeline write.
| Default | 10 |
|---|---|
| Range | 1–100 |
padCompress=integer
specifies the size of additional padding to allow for compressed SPDE tables. This enables subsequent updates to perform more efficiently.
partSize=64-bit-integer
specifies the partition size (in number of MBs) to use for created SPDE tables.
| Minimum value | 16 |
|---|
platform="MAPRED" | "SPARK"
MAPRED
Specifies to run EP jobs on the Map Reduce platform.
SPARK
Specifies to run EP jobs on the Spark platform.
pwd="string"
specifies the password.
readPW="string"
specifies the password to use for Read access.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
writePW="string"
specifies the password to use for Write access.
Parameters for SQLSERVER
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for TERADATA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
specifies connection options to use for connecting to the Teradata database.
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies a Teradata Max Text Size value in chars.
| Default | 32000 |
|---|---|
| Range | 1–32000 |
insertbuff=integer
specifies the number of rows to insert in one write block.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
specifies the password.
schema="string"
Unused
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for VEDNFS
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
Parameters for VEPATH
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
Parameters for VERTICA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for VES3
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
kmsContext="string"
specifies the AWS Key Management Services encryption context for the cryptographic operation.
kmsKeyId="string"
specifies the AWS Key Management Services ID.
sseHexKey="string"
specifies an encryption key in the form of a 64-digit hexadecimal value.
sseTextKey="string"
specifies a plain-text version of the key to use with server-side encryption.
Parameters for YELLOWBRICK
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=true | false
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | false |
Parameters for fileType="AUTO"
No parameters apply when you specify AUTO
Parameters for fileType="BASESAS"
compress="BINARY" | "CHAR" | "NO" | "YES"
when set to True, applies data compression to the table.
| Default | NO |
|---|
encoding="string"
specifies file encoding
encrypt="AES" | "AES2" | "NO" | "YES"
specifies whether to encrypt an output SAS data set
| Default | NO |
|---|
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
password="string"
specifies the password for a password-protected data set. Use this parameter if the data set is password-protected or uses SAS proprietary encryption.
pointobs=true | false
specifies whether SAS creates compressed data sets whose observations can be randomly accessed or sequentially accessed
| Default | true |
|---|
read="string"
specifies the Read password for the SAS data set.
reuse=true | false
specifies whether new rows can be written to freed space in a compressed SAS data set
| Default | false |
|---|
Parameters for fileType="CSV" | "DELIMITED"
addbom=true | false
when set to True, the file includes a byte-order mark (BOM) at the beginning of the file. The BOM can help programs such as Microsoft Excel to interpret national characters in text fields correctly. By default, the BOM is not added to the file.
| Default | false |
|---|
Parameters for fileType="DTA"
No parameters apply when you specify DTA
Parameters for fileType="EXCEL"
range="string"
specifies a subset of the cells to import. For example, the range B2..E8 is the range address for a rectangular block of 12 cells, where the top left cell is B2 and the bottom right cell is E8.
sheet="string"
specifies the name of the worksheet to import.
Parameters for fileType="JMP"
No parameters apply when you specify JMP
Parameters for fileType="ORC"
compress="NO" | "YES" | "ZLIB"
when set to True, applies data compression to the table.
| Default | ZLIB |
|---|
Parameters for fileType="SPSS"
No parameters apply when you specify SPSS
Parameters for fileType="XLS"
range="string"
specifies a subset of the cells to import. For example, the range B2..E8 is the range address for a rectangular block of 12 cells, where the top left cell is B2 and the bottom right cell is E8.
sheet="string"
specifies the name of the worksheet to import.
save Action
Saves a table to a caslib's data source.
| See: | Saving Tables and Exporting Data |
|---|---|
| Examples: | Save a Table |
| Save a SAS7BDAT File in a Caslib |
Python Syntax
Summary: Input Tables
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametertable |
— |
specifies the table name, caslib, and other common parameters. |
Parameter Descriptions
caslib="string"
specifies the target caslib for the table.
compress=True | False
when set to True, applies data compression to the table.
| Default | False |
|---|
copies=integer
specifies the number of redundant copies to make for the rows. Larger values provide greater fault tolerance for node failures but use more memory. Specifying 0 results in no fault tolerance in the event of a node failure.
| Minimum value | -1 |
|---|
dataSourceOptions={adls-parameters | bigquery-parameters | clouddex-parameters | db2-parameters | hadoop-parameters | hana-parameters | impala-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | postgres-parameters | redshift-parameters | sforce-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | teradata-parameters | vednfs-parameters | vepath-parameters | vertica-parameters | ves3-parameters | yellowbrick-parameters}
specifies data source options.
| Alias | options |
|---|
exportOptions={"fileType":"AUTO" | "BASESAS" | "CSV" | "DTA" | "EXCEL" | "JMP" | "ORC" | "SPSS" | "XLS", fileType-specific-parameters}
specifies the settings for saving a table to a data source.
| Alias | export |
|---|
The value that you specify for the fileType parameter determines the other parameters that apply.
* name="string"
specifies the table name.
permission="GROUPREAD" | "GROUPWRITE" | "GROUPWRITEPUBLICREAD" | "PRIVATE" | "PUBLICREAD" | "PUBLICWRITE" | integer
specifies the host access controls on the saved file. This parameter applies to servers that run Linux only. This parameter applies to saving SASHDAT and CSV files in PATH, and DNFS caslibs. For other data sources and file types, refer to the corresponding documentation.
replace=True | False
when set to True, an existing table with the same name is overwritten.
| Default | False |
|---|
saveAttrs=True | False
when set to True, attributes are automatically saved in a file that is named table-name.ATTRS.sashdat. The file is saved in the same caslib that is used for saving the table. This parameter applies to path-based caslibs only.
| Default | False |
|---|
* table={castable}
specifies the table name, caslib, and other common parameters.
For more information about specifying the table parameter, see the common castable parameter.
viewAsTable=True | False
when set to True and the table parameter identifies a view, the contents of the view are saved. By default, the definition of the view is saved.
| Default | False |
|---|
Parameters for ADLS
accountName="string"
Azure storage account name
applicationId="string"
Application ID for Azure storage
dnsSuffix="string"
DNS Suffix for Azure storage
filesystem="string"
Azure storage file system
timeout=integer
Azure storage operation timeout value in seconds
| Default | 60 |
|---|---|
| Minimum value | 0 |
Parameters for BIGQUERY
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bulkload=True | False
when set to TRUE, data is written to Google BigQuery using the Go Loader.Run function.
| Default | False |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=True | False
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
qualifier="string"
specifies an alternate project ID to be used in table references in SQL queries
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for CLOUDDEX
append=True | False
| Default | False |
|---|
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
casTypes="ALL" | "BASIC"
ALL
specifies that data types include CHAR and VARCHAR for text. Numeric columns support INTEGER, 64-bit INTEGER, DATE, DATETIME, and TIME. BINARY and VARBINARY are also available.
BASIC
specifies that data types are limited to DOUBLE, CHAR, and VARCHAR.
catalog="string"
specifies the database catalog name.
charCreateMultiplier=double
| Default | 1 |
|---|---|
| Range | 1–5 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
domainCredsRequired=True | False
| Default | TRUE |
|---|
dropTableOnFailedSave=True | False
| Default | TRUE |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
ncharCreateMultiplier=double
| Default | 1 |
|---|---|
| Range | 1–5 |
ncharMultiplier=double
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|
pwd="string"
specifies the password.
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
traceFile="string"
specifies a name for the trace file.
traceFlags="string"
specifies flags to use for tracing the database connection.
uid="string"
specifies the user name.
useMaxCharLen=True | False
| Default | False |
|---|
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for DB2
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for HADOOP
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
bulkLoad=True | False
Specifies whether Bulk Loading should be used for inserting rows.
| Default | TRUE |
|---|
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies the maximum length for STRING data type columns. For Hive, this parameter does not apply to CHAR or VARCHAR columns.
| Default | 32767 |
|---|---|
| Minimum value | 1 |
hdfsDatadir="string"
specifies the path to an HDFS directory that will be used to store the data when saving a Cloud Analytic Services table.
hdfsMetadir="string"
specifies the path to an HDFS directory that contains XML-based table definitions, called SASHDMD descriptors.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
insertbuff=integer
specifies the number of rows to insert in one write block.
loginTimeout=integer
Specifies the login time-out in seconds for connecting to the data source.
| Default | 30 |
|---|---|
| Minimum value | 0 |
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
platform="MAPRED" | "SPARK"
MAPRED
Specifies to run EP jobs on the Map Reduce platform.
SPARK
Specifies to run EP jobs on the Spark platform.
postTableOpts="string"
Specifies additional database-specific options to be placed after the table name in a CREATE TABLE statement.
preTableOpts="string"
Specifies additional database-specific options to be placed before the table name in a CREATE TABLE statement.
pwd="string"
specifies the password.
readbuff=integer
specifies the number of rows to read in one read block.
| Alias | ras row_array_size |
|---|
schema="string"
specifies the name of the Hive schema.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for HANA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
specifies connection options to use for connecting to the database.
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
Parameters for IMPALA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bulkload=True | False
| Default | False |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for JDBC
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
login_timeout=integer
specifies the number of seconds to wait for a connection attempt before returning an error.
| Alias | loginTimeout |
|---|---|
| Minimum value | 0 |
pwd="string"
query_timeout=integer
specifies the number of seconds to wait for a query to finish executing before returning an error.
| Alias | queryTimeout |
|---|---|
| Minimum value | 0 |
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for MONGODB
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for MYSQL
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for ODBC
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for ORACLE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for POSTGRES
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for REDSHIFT
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
awsConfig="string"
specifies the AWS configuration file if different from the default.
blOptions="string"
specifies any additional COPY options that are added to the end of the COPY command.
bucket="string"
specifies the S3 bucket name (and subdirectory, if applicable) to write data files.
bulkload=True | False
when set to TRUE, data is written to Redshift using the COPY command.
| Default | False |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress=True | False
when set to TRUE, use GZIP compression on data files.
| Default | False |
|---|
conopts="string"
credentialsFile="string"
specifies the AWS credentials file to use.
credentialsProfile="string"
specifies the AWS profile name in the AWS credentials file to use if using an account with multiple profiles.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=True | False
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
escape=True | False
when set to TRUE, any restricted characters in string data are escaped to allow processing with COPY.
| Default | False |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
key="string"
specifies the Amazon Web Services access key that is used with key-based access control.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
profile="string"
specifies the AWS profile to use if using an account with multiple profiles.
pwd="string"
region="string"
specifies the Amazon Web Services region that the Redshift server resides for bulk-load.
s3Config="string"
specifies an optional S3 configuration file
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
secret="string"
specifies the Amazon Web Services secret access key that is used with key-based access control.
token="string"
specifies a temporary token that is associated with the temporary credentials that you specify with the secret and key options.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
useSSL=True | False
when set to TRUE, create an SSL connection to S3 when transmitting data files.
| Default | False |
|---|
Parameters for SFORCE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for SNOWFLAKE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
awsConfig="string"
specifies the AWS configuration file if different from the default.
blOptions="string"
specifies any additional COPY options that are added to the end of the COPY command.
bucket="string"
specifies the S3 bucket name (and subdirectory, if applicable) to write data files.
bulkload=True | False
when set to TRUE, data is written to Snowflake using the COPY INTO command.
| Default | False |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress=True | False
when set to TRUE, use GZIP compression on data files.
| Default | False |
|---|
conopts="string"
credentialsFile="string"
specifies the AWS credentials file to use.
credentialsProfile="string"
specifies the AWS profile name in the AWS credentials file to use if using an account with multiple profiles.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=True | False
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
escape=True | False
when set to TRUE, any restricted characters in string data are escaped to allow processing with COPY.
| Default | False |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
key="string"
specifies the Amazon Web Services access key that is used with key-based access control.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
profile="string"
specifies the AWS profile to use if using an account with multiple profiles.
pwd="string"
region="string"
specifies the Amazon Web Services region that the Snowflake server resides for bulk-load.
s3Config="string"
specifies an optional S3 configuration file
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
secret="string"
specifies the Amazon Web Services secret access key that is used with key-based access control.
stage="string"
specifies the internal stage including path to use for bulk-load.
token="string"
specifies a temporary token that is associated with the temporary credentials that you specify with the secret and key options.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
useSSL=True | False
when set to TRUE, create an SSL connection to S3 when transmitting data files.
| Default | False |
|---|
Parameters for SPARK
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
bulkLoad=True | False
Specifies whether Bulk Loading should be used for inserting rows.
| Default | TRUE |
|---|
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies the maximum length for STRING data type columns. For Hive, this parameter does not apply to CHAR or VARCHAR columns.
| Default | 1024 |
|---|---|
| Minimum value | 1 |
hdfsDatadir="string"
specifies the path to an HDFS directory that will be used to store the data when saving a Cloud Analytic Services table.
hdfsMetadir="string"
specifies the path to an HDFS directory that contains XML-based table definitions, called SASHDMD descriptors.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
insertbuff=integer
specifies the number of rows to insert in one write block.
loginTimeout=integer
Specifies the login time-out in seconds for connecting to the data source.
| Default | 30 |
|---|---|
| Minimum value | 0 |
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
postTableOpts="string"
Specifies additional database-specific options to be placed after the table name in a CREATE TABLE statement.
preTableOpts="string"
Specifies additional database-specific options to be placed before the table name in a CREATE TABLE statement.
pwd="string"
specifies the password.
readbuff=integer
specifies the number of rows to read in one read block.
| Alias | ras row_array_size |
|---|
schema="string"
specifies the name of the Hive schema.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for SPDE
alterPW="string"
specifies the password to use for Alter access.
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress="BINARY" | "CHAR" | "NO" | "YES"
BINARY
Binary SPDE Compression
CHAR
Char SPDE Compression
NO
No SPDE Compression
YES
Yes SPDE Compression
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
datapath="string"
specifies the path to place data files for created SPDE tables.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
encrypt="AES" | "NO" | "YES"
AES
AES SPDE Encryption
NO
No SPDE Encryption
YES
Proprietary SPDE Encryption
encryptionPassword="string"
specifies the passphrase used for an AES encrypted data set.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
label="string"
specifies a label to apply to the output data set.
masterPW="string"
specifies the master password to use for Read/Write/Alter access.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
mdfpath="string"
specifies the path where SPDE MDF are located.
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteBuffers=integer
specifies the number of write buffers to use for the pipeline write.
| Default | 10 |
|---|---|
| Range | 1–100 |
padCompress=integer
specifies the size of additional padding to allow for compressed SPDE tables. This enables subsequent updates to perform more efficiently.
partSize=64-bit-integer
specifies the partition size (in number of MBs) to use for created SPDE tables.
| Minimum value | 16 |
|---|
platform="MAPRED" | "SPARK"
MAPRED
Specifies to run EP jobs on the Map Reduce platform.
SPARK
Specifies to run EP jobs on the Spark platform.
pwd="string"
specifies the password.
readPW="string"
specifies the password to use for Read access.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
writePW="string"
specifies the password to use for Write access.
Parameters for SQLSERVER
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for TERADATA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
specifies connection options to use for connecting to the Teradata database.
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies a Teradata Max Text Size value in chars.
| Default | 32000 |
|---|---|
| Range | 1–32000 |
insertbuff=integer
specifies the number of rows to insert in one write block.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
specifies the password.
schema="string"
Unused
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for VEDNFS
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
Parameters for VEPATH
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
Parameters for VERTICA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for VES3
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
kmsContext="string"
specifies the AWS Key Management Services encryption context for the cryptographic operation.
kmsKeyId="string"
specifies the AWS Key Management Services ID.
sseHexKey="string"
specifies an encryption key in the form of a 64-digit hexadecimal value.
sseTextKey="string"
specifies a plain-text version of the key to use with server-side encryption.
Parameters for YELLOWBRICK
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=True | False
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | False |
Parameters for fileType="AUTO"
No parameters apply when you specify AUTO
Parameters for fileType="BASESAS"
"compress":"BINARY" | "CHAR" | "NO" | "YES"
when set to True, applies data compression to the table.
| Default | NO |
|---|
"encoding":"string"
specifies file encoding
"encrypt":"AES" | "AES2" | "NO" | "YES"
specifies whether to encrypt an output SAS data set
| Default | NO |
|---|
"encryptionPassword":"string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
"password":"string"
specifies the password for a password-protected data set. Use this parameter if the data set is password-protected or uses SAS proprietary encryption.
"pointobs":True | False
specifies whether SAS creates compressed data sets whose observations can be randomly accessed or sequentially accessed
| Default | True |
|---|
"read":"string"
specifies the Read password for the SAS data set.
"reuse":True | False
specifies whether new rows can be written to freed space in a compressed SAS data set
| Default | False |
|---|
Parameters for fileType="CSV" | "DELIMITED"
"addbom":True | False
when set to True, the file includes a byte-order mark (BOM) at the beginning of the file. The BOM can help programs such as Microsoft Excel to interpret national characters in text fields correctly. By default, the BOM is not added to the file.
| Default | False |
|---|
Parameters for fileType="DTA"
No parameters apply when you specify DTA
Parameters for fileType="EXCEL"
"range":"string"
specifies a subset of the cells to import. For example, the range B2..E8 is the range address for a rectangular block of 12 cells, where the top left cell is B2 and the bottom right cell is E8.
"sheet":"string"
specifies the name of the worksheet to import.
Parameters for fileType="JMP"
No parameters apply when you specify JMP
Parameters for fileType="ORC"
"compress":"NO" | "YES" | "ZLIB"
when set to True, applies data compression to the table.
| Default | ZLIB |
|---|
Parameters for fileType="SPSS"
No parameters apply when you specify SPSS
Parameters for fileType="XLS"
"range":"string"
specifies a subset of the cells to import. For example, the range B2..E8 is the range address for a rectangular block of 12 cells, where the top left cell is B2 and the bottom right cell is E8.
"sheet":"string"
specifies the name of the worksheet to import.
save Action
Saves a table to a caslib's data source.
| See: | Saving Tables and Exporting Data |
|---|---|
| Examples: | Save a Table |
| Save a SAS7BDAT File in a Caslib |
R Syntax
Summary: Input Tables
If a row includes a subparameter, you can specify the name, caslib, and so on in the subparameter. Otherwise, you can specify the name, caslib, and so on in the parameter.
|
Parameter |
Subparameter |
Description |
|---|---|---|
|
required parametertable |
— |
specifies the table name, caslib, and other common parameters. |
Parameter Descriptions
caslib="string"
specifies the target caslib for the table.
compress=TRUE | FALSE
when set to True, applies data compression to the table.
| Default | FALSE |
|---|
copies=integer
specifies the number of redundant copies to make for the rows. Larger values provide greater fault tolerance for node failures but use more memory. Specifying 0 results in no fault tolerance in the event of a node failure.
| Minimum value | -1 |
|---|
dataSourceOptions=list(adls-parameters | bigquery-parameters | clouddex-parameters | db2-parameters | hadoop-parameters | hana-parameters | impala-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | postgres-parameters | redshift-parameters | sforce-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | teradata-parameters | vednfs-parameters | vepath-parameters | vertica-parameters | ves3-parameters | yellowbrick-parameters)
specifies data source options.
| Alias | options |
|---|
exportOptions=list(fileType="AUTO" | "BASESAS" | "CSV" | "DTA" | "EXCEL" | "JMP" | "ORC" | "SPSS" | "XLS", fileType-specific-parameters)
specifies the settings for saving a table to a data source.
| Alias | export |
|---|
The value that you specify for the fileType parameter determines the other parameters that apply.
* name="string"
specifies the table name.
permission="GROUPREAD" | "GROUPWRITE" | "GROUPWRITEPUBLICREAD" | "PRIVATE" | "PUBLICREAD" | "PUBLICWRITE" | integer
specifies the host access controls on the saved file. This parameter applies to servers that run Linux only. This parameter applies to saving SASHDAT and CSV files in PATH, and DNFS caslibs. For other data sources and file types, refer to the corresponding documentation.
replace=TRUE | FALSE
when set to True, an existing table with the same name is overwritten.
| Default | FALSE |
|---|
saveAttrs=TRUE | FALSE
when set to True, attributes are automatically saved in a file that is named table-name.ATTRS.sashdat. The file is saved in the same caslib that is used for saving the table. This parameter applies to path-based caslibs only.
| Default | FALSE |
|---|
* table=list(castable)
specifies the table name, caslib, and other common parameters.
For more information about specifying the table parameter, see the common castable parameter.
viewAsTable=TRUE | FALSE
when set to True and the table parameter identifies a view, the contents of the view are saved. By default, the definition of the view is saved.
| Default | FALSE |
|---|
Parameters for ADLS
accountName="string"
Azure storage account name
applicationId="string"
Application ID for Azure storage
dnsSuffix="string"
DNS Suffix for Azure storage
filesystem="string"
Azure storage file system
timeout=integer
Azure storage operation timeout value in seconds
| Default | 60 |
|---|---|
| Minimum value | 0 |
Parameters for BIGQUERY
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bulkload=TRUE | FALSE
when set to TRUE, data is written to Google BigQuery using the Go Loader.Run function.
| Default | FALSE |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=TRUE | FALSE
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
qualifier="string"
specifies an alternate project ID to be used in table references in SQL queries
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for CLOUDDEX
append=TRUE | FALSE
| Default | FALSE |
|---|
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
casTypes="ALL" | "BASIC"
ALL
specifies that data types include CHAR and VARCHAR for text. Numeric columns support INTEGER, 64-bit INTEGER, DATE, DATETIME, and TIME. BINARY and VARBINARY are also available.
BASIC
specifies that data types are limited to DOUBLE, CHAR, and VARCHAR.
catalog="string"
specifies the database catalog name.
charCreateMultiplier=double
| Default | 1 |
|---|---|
| Range | 1–5 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
domainCredsRequired=TRUE | FALSE
| Default | TRUE |
|---|
dropTableOnFailedSave=TRUE | FALSE
| Default | TRUE |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
ncharCreateMultiplier=double
| Default | 1 |
|---|---|
| Range | 1–5 |
ncharMultiplier=double
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|
pwd="string"
specifies the password.
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
traceFile="string"
specifies a name for the trace file.
traceFlags="string"
specifies flags to use for tracing the database connection.
uid="string"
specifies the user name.
useMaxCharLen=TRUE | FALSE
| Default | FALSE |
|---|
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for DB2
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for HADOOP
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
bulkLoad=TRUE | FALSE
Specifies whether Bulk Loading should be used for inserting rows.
| Default | TRUE |
|---|
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies the maximum length for STRING data type columns. For Hive, this parameter does not apply to CHAR or VARCHAR columns.
| Default | 32767 |
|---|---|
| Minimum value | 1 |
hdfsDatadir="string"
specifies the path to an HDFS directory that will be used to store the data when saving a Cloud Analytic Services table.
hdfsMetadir="string"
specifies the path to an HDFS directory that contains XML-based table definitions, called SASHDMD descriptors.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
insertbuff=integer
specifies the number of rows to insert in one write block.
loginTimeout=integer
Specifies the login time-out in seconds for connecting to the data source.
| Default | 30 |
|---|---|
| Minimum value | 0 |
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
platform="MAPRED" | "SPARK"
MAPRED
Specifies to run EP jobs on the Map Reduce platform.
SPARK
Specifies to run EP jobs on the Spark platform.
postTableOpts="string"
Specifies additional database-specific options to be placed after the table name in a CREATE TABLE statement.
preTableOpts="string"
Specifies additional database-specific options to be placed before the table name in a CREATE TABLE statement.
pwd="string"
specifies the password.
readbuff=integer
specifies the number of rows to read in one read block.
| Alias | ras row_array_size |
|---|
schema="string"
specifies the name of the Hive schema.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for HANA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
specifies connection options to use for connecting to the database.
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
Parameters for IMPALA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bulkload=TRUE | FALSE
| Default | FALSE |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for JDBC
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
login_timeout=integer
specifies the number of seconds to wait for a connection attempt before returning an error.
| Alias | loginTimeout |
|---|---|
| Minimum value | 0 |
pwd="string"
query_timeout=integer
specifies the number of seconds to wait for a query to finish executing before returning an error.
| Alias | queryTimeout |
|---|---|
| Minimum value | 0 |
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for MONGODB
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for MYSQL
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for ODBC
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for ORACLE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for POSTGRES
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for REDSHIFT
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
awsConfig="string"
specifies the AWS configuration file if different from the default.
blOptions="string"
specifies any additional COPY options that are added to the end of the COPY command.
bucket="string"
specifies the S3 bucket name (and subdirectory, if applicable) to write data files.
bulkload=TRUE | FALSE
when set to TRUE, data is written to Redshift using the COPY command.
| Default | FALSE |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress=TRUE | FALSE
when set to TRUE, use GZIP compression on data files.
| Default | FALSE |
|---|
conopts="string"
credentialsFile="string"
specifies the AWS credentials file to use.
credentialsProfile="string"
specifies the AWS profile name in the AWS credentials file to use if using an account with multiple profiles.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=TRUE | FALSE
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
escape=TRUE | FALSE
when set to TRUE, any restricted characters in string data are escaped to allow processing with COPY.
| Default | FALSE |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
key="string"
specifies the Amazon Web Services access key that is used with key-based access control.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
profile="string"
specifies the AWS profile to use if using an account with multiple profiles.
pwd="string"
region="string"
specifies the Amazon Web Services region that the Redshift server resides for bulk-load.
s3Config="string"
specifies an optional S3 configuration file
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
secret="string"
specifies the Amazon Web Services secret access key that is used with key-based access control.
token="string"
specifies a temporary token that is associated with the temporary credentials that you specify with the secret and key options.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
useSSL=TRUE | FALSE
when set to TRUE, create an SSL connection to S3 when transmitting data files.
| Default | FALSE |
|---|
Parameters for SFORCE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for SNOWFLAKE
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
awsConfig="string"
specifies the AWS configuration file if different from the default.
blOptions="string"
specifies any additional COPY options that are added to the end of the COPY command.
bucket="string"
specifies the S3 bucket name (and subdirectory, if applicable) to write data files.
bulkload=TRUE | FALSE
when set to TRUE, data is written to Snowflake using the COPY INTO command.
| Default | FALSE |
|---|
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress=TRUE | FALSE
when set to TRUE, use GZIP compression on data files.
| Default | FALSE |
|---|
conopts="string"
credentialsFile="string"
specifies the AWS credentials file to use.
credentialsProfile="string"
specifies the AWS profile name in the AWS credentials file to use if using an account with multiple profiles.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
defaultDir="string"
specifies the default directory on the local node where data files are written. Defaults to SAS utility directory.
deleteDataFiles=TRUE | FALSE
when set to TRUE (the default), all local data files as well as S3 objects are deleted after the COPY command completes.
| Default | TRUE |
|---|
delimiter="string"
specifies a column delimiter for the data file. Either a single ASCII character or an octal sequence.
escape=TRUE | FALSE
when set to TRUE, any restricted characters in string data are escaped to allow processing with COPY.
| Default | FALSE |
|---|
insertbuff=integer
specifies the number of rows to insert in one write block.
key="string"
specifies the Amazon Web Services access key that is used with key-based access control.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
profile="string"
specifies the AWS profile to use if using an account with multiple profiles.
pwd="string"
region="string"
specifies the Amazon Web Services region that the Snowflake server resides for bulk-load.
s3Config="string"
specifies an optional S3 configuration file
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
secret="string"
specifies the Amazon Web Services secret access key that is used with key-based access control.
stage="string"
specifies the internal stage including path to use for bulk-load.
token="string"
specifies a temporary token that is associated with the temporary credentials that you specify with the secret and key options.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
useSSL=TRUE | FALSE
when set to TRUE, create an SSL connection to S3 when transmitting data files.
| Default | FALSE |
|---|
Parameters for SPARK
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
bulkLoad=TRUE | FALSE
Specifies whether Bulk Loading should be used for inserting rows.
| Default | TRUE |
|---|
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies the maximum length for STRING data type columns. For Hive, this parameter does not apply to CHAR or VARCHAR columns.
| Default | 1024 |
|---|---|
| Minimum value | 1 |
hdfsDatadir="string"
specifies the path to an HDFS directory that will be used to store the data when saving a Cloud Analytic Services table.
hdfsMetadir="string"
specifies the path to an HDFS directory that contains XML-based table definitions, called SASHDMD descriptors.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
insertbuff=integer
specifies the number of rows to insert in one write block.
loginTimeout=integer
Specifies the login time-out in seconds for connecting to the data source.
| Default | 30 |
|---|---|
| Minimum value | 0 |
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
postTableOpts="string"
Specifies additional database-specific options to be placed after the table name in a CREATE TABLE statement.
preTableOpts="string"
Specifies additional database-specific options to be placed before the table name in a CREATE TABLE statement.
pwd="string"
specifies the password.
readbuff=integer
specifies the number of rows to read in one read block.
| Alias | ras row_array_size |
|---|
schema="string"
specifies the name of the Hive schema.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for SPDE
alterPW="string"
specifies the password to use for Alter access.
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
compress="BINARY" | "CHAR" | "NO" | "YES"
BINARY
Binary SPDE Compression
CHAR
Char SPDE Compression
NO
No SPDE Compression
YES
Yes SPDE Compression
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
datapath="string"
specifies the path to place data files for created SPDE tables.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
encrypt="AES" | "NO" | "YES"
AES
AES SPDE Encryption
NO
No SPDE Encryption
YES
Proprietary SPDE Encryption
encryptionPassword="string"
specifies the passphrase used for an AES encrypted data set.
hdfsTempDir="string"
specifies the Hadoop HDFS directory to use to store temporary data.
| Alias | hdfs_tempdir |
|---|---|
| Default | "/tmp" |
label="string"
specifies a label to apply to the output data set.
masterPW="string"
specifies the master password to use for Read/Write/Alter access.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
mdfpath="string"
specifies the path where SPDE MDF are located.
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteBuffers=integer
specifies the number of write buffers to use for the pipeline write.
| Default | 10 |
|---|---|
| Range | 1–100 |
padCompress=integer
specifies the size of additional padding to allow for compressed SPDE tables. This enables subsequent updates to perform more efficiently.
partSize=64-bit-integer
specifies the partition size (in number of MBs) to use for created SPDE tables.
| Minimum value | 16 |
|---|
platform="MAPRED" | "SPARK"
MAPRED
Specifies to run EP jobs on the Map Reduce platform.
SPARK
Specifies to run EP jobs on the Spark platform.
pwd="string"
specifies the password.
readPW="string"
specifies the password to use for Read access.
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
writePW="string"
specifies the password to use for Write access.
Parameters for SQLSERVER
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for TERADATA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
bufferSize=64-bit-integer
specifies the incoming data buffer size, in bytes.
| Default | 1048576 |
|---|---|
| Minimum value | 0 |
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
specifies connection options to use for connecting to the Teradata database.
dataTransferMode="AUTO" | "PARALLEL" | "SERIAL"
AUTO
specifies to attempt a parallel load. If the parallel load does not succeed, then a serial load is performed.
PARALLEL
specifies to perform a parallel load using the SAS Embedded Process. If the parallel load cannot be performed, such as for network connectivity issues, then the load fails.
SERIAL
specifies to perform a serial load.
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
dbmaxText=integer
specifies a Teradata Max Text Size value in chars.
| Default | 32000 |
|---|---|
| Range | 1–32000 |
insertbuff=integer
specifies the number of rows to insert in one write block.
maxSaveThreads=integer
Specifies the maximum number of threads to use to save a table.
| Default | 0 |
|---|---|
| Minimum value | 0 |
ncharMultiplier=double
specifies a multiplier value to be used with multi-byte encoded character variables. Specify a value larger than the default to avoid character data truncation. Specify a value smaller than the default to conserve storage for data that doesn't require the maximum bytes. The byte lengths are calculated by multiplying the character length by the specified value.
| Default | 3 |
|---|---|
| Range | 1–5 |
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
specifies the password.
schema="string"
Unused
statusInterval=integer
specifies the interval for status messages to display to the console during a table load. When the specified number of incoming data buffers are added to the table, a message is displayed.
| Default | 0 |
|---|
uid="string"
specifies the user name.
Parameters for VEDNFS
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
Parameters for VEPATH
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
Parameters for VERTICA
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for VES3
encryptionDomain="string"
specifies the name for a collection of data that is stored with a common encryption password.
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
kmsContext="string"
specifies the AWS Key Management Services encryption context for the cryptographic operation.
kmsKeyId="string"
specifies the AWS Key Management Services ID.
sseHexKey="string"
specifies an encryption key in the form of a 64-digit hexadecimal value.
sseTextKey="string"
specifies a plain-text version of the key to use with server-side encryption.
Parameters for YELLOWBRICK
authenticationDomain="string"
specifies the authentication domain that is used to retrieve database credentials.
catalog="string"
specifies the database catalog name.
charMultiplier=double
specifies a multiplier value to expand single-byte encoded character variables to avoid character data truncation. The lengths are increased by multiplying the character length by the specified value.
| Default | 1 |
|---|---|
| Range | 1–5 |
conopts="string"
dbCreateTableOpts="string"
specifies database-specific CREATE TABLE options that will be appended to the generated CREATE TABLE statement.
insertbuff=integer
specifies the number of rows to insert in one write block.
numWriteNodes=integer
specifies the number of grid nodes that will connect to and write data to the DBMS during a Save action.
| Default | 1 |
|---|---|
| Range | 0–32767 |
pwd="string"
schema="string"
specifies the schema so that you can use to fully qualify objects in another database for SQL processing.
uid="string"
useNarrowCharacterTypes=TRUE | FALSE
when set to TRUE, the data connector creates narrow character types(CHAR and VARCHAR) during a Save action. The default of FALSE creates wide character types(NCHAR and NVARCHAR).
| Alias | useNCT useNarrowCharTypes |
|---|---|
| Default | FALSE |
Parameters for fileType="AUTO"
No parameters apply when you specify AUTO
Parameters for fileType="BASESAS"
compress="BINARY" | "CHAR" | "NO" | "YES"
when set to True, applies data compression to the table.
| Default | NO |
|---|
encoding="string"
specifies file encoding
encrypt="AES" | "AES2" | "NO" | "YES"
specifies whether to encrypt an output SAS data set
| Default | NO |
|---|
encryptionPassword="string" | binary-large-object
specifies a password for encrypting or decrypting stored data.
password="string"
specifies the password for a password-protected data set. Use this parameter if the data set is password-protected or uses SAS proprietary encryption.
pointobs=TRUE | FALSE
specifies whether SAS creates compressed data sets whose observations can be randomly accessed or sequentially accessed
| Default | TRUE |
|---|
read="string"
specifies the Read password for the SAS data set.
reuse=TRUE | FALSE
specifies whether new rows can be written to freed space in a compressed SAS data set
| Default | FALSE |
|---|
Parameters for fileType="CSV" | "DELIMITED"
addbom=TRUE | FALSE
when set to True, the file includes a byte-order mark (BOM) at the beginning of the file. The BOM can help programs such as Microsoft Excel to interpret national characters in text fields correctly. By default, the BOM is not added to the file.
| Default | FALSE |
|---|
Parameters for fileType="DTA"
No parameters apply when you specify DTA
Parameters for fileType="EXCEL"
range="string"
specifies a subset of the cells to import. For example, the range B2..E8 is the range address for a rectangular block of 12 cells, where the top left cell is B2 and the bottom right cell is E8.
sheet="string"
specifies the name of the worksheet to import.
Parameters for fileType="JMP"
No parameters apply when you specify JMP
Parameters for fileType="ORC"
compress="NO" | "YES" | "ZLIB"
when set to True, applies data compression to the table.
| Default | ZLIB |
|---|
Parameters for fileType="SPSS"
No parameters apply when you specify SPSS
Parameters for fileType="XLS"
range="string"
specifies a subset of the cells to import. For example, the range B2..E8 is the range address for a rectangular block of 12 cells, where the top left cell is B2 and the bottom right cell is E8.
sheet="string"
specifies the name of the worksheet to import.