Data Set Options

About the Data Set Options for Relational Databases
Dictionary

ABCDEFHIKLMNOPQRSTUY

ANALYZE= Data Set Option
AUTHID= Data Set Option
AUTOCOMMIT= Data Set Option
BL_ACCOUNTNAME= Data Set Option
BL_ALLOW_READ_ACCESS= Data Set Option
BL_ALLOW_WRITE_ACCESS= Data Set Option
BL_API_BULKLOAD= Data Set Option
BL_APPLICATIONID= Data Set Option
BL_AWS_CONFIG_FILE= Data Set Option
BL_AWS_CREDENTIALS_FILE= Data Set Option
BL_AWS_PROFILE_NAME= Data Set Option
BL_AZURE_SAS= Data Set Option
BL_BADFILE= Data Set Option
BL_BUCKET= Data Set Option
BL_CLIENT_DATAFILE= Data Set Option
BL_CODEPAGE= Data Set Option
BL_COLUMN_DELIMITER= Data Set Option
BL_COMPRESS= Data Set Option
BL_CONFIG= Data Set Option
BL_CONTROL_FIELD_DELIMITER= Data Set Option
BL_CONTROL_QUOTATION_MARK= Data Set Option
BL_CONTROL_RECORD_DELIMITER= Data Set Option
BL_CONTROL= Data Set Option
BL_COPY_LOCATION= Data Set Option
BL_CPU_PARALLELISM= Data Set Option
BL_DATA_BUFFER_SIZE= Data Set Option
BL_DATAFILE_EXISTS= Data Set Option
BL_DATAFILE_PATH= Data Set Option
BL_DATAFILE= Data Set Option
BL_DATAFILE= Data Set Option: Teradata
BL_DB2CURSOR= Data Set Option
BL_DB2DATACLAS= Data Set Option
BL_DB2DEVT_PERM= Data Set Option
BL_DB2DEVT_TEMP= Data Set Option
BL_DB2DISC= Data Set Option
BL_DB2ERR= Data Set Option
BL_DB2IN= Data Set Option
BL_DB2LDCT1= Data Set Option
BL_DB2LDCT2= Data Set Option
BL_DB2LDCT3= Data Set Option
BL_DB2LDEXT= Data Set Option
BL_DB2MGMTCLAS= Data Set Option
BL_DB2MAP= Data Set Option
BL_DB2PRINT= Data Set Option
BL_DB2PRNLOG= Data Set Option
BL_DB2REC= Data Set Option
BL_DB2RECSP= Data Set Option
BL_DB2RSTRT= Data Set Option
BL_DB2SPC_PERM= Data Set Option
BL_DB2SPC_TEMP= Data Set Option
BL_DB2STORCLAS= Data Set Option
BL_DB2TBLXST= Data Set Option
BL_DB2UNITCOUNT= Data Set Option
BL_DB2UTID= Data Set Option
BL_DBACCESS_PATH= Data Set Option
BL_DBNAME= Data Set Option
BL_DEFAULT_DIR= Data Set Option
BL_DELETE_DATAFILE= Data Set Option
BL_DELETE_ONLY_DATAFILE= Data Set Option
BL_DELIMITER= Data Set Option
BL_DIRECT_PATH= Data Set Option
BL_DISCARDFILE= Data Set Option
BL_DISK_PARALLELISM= Data Set Option
BL_DNSSUFFIX= Data Set Option
BL_ENCKEY= Data Set Option
BL_ENCODING= Data Set Option
BL_ESCAPE= Data Set Option
BL_EXCEPTION= Data Set Option
BL_EXECUTE_CMD= Data Set Option
BL_EXECUTE_LOCATION= Data Set Option
BL_EXTERNAL_WEB= Data Set Option
BL_FILE_BADFILE= Data Set Option
BL_FILE_CONTROLFILE= Data Set Option
BL_FILE_DATAFILE= Data Set Option
BL_FILE_DEFAULT_DIR= Data Set Option
BL_FILE_DELETE_DATAFILE= Data Set Option
BL_FILESYSTEM= Data Set Option
BL_FOLDER= Data Set Option
BL_FORCE_NOT_NULL= Data Set Option
BL_FORMAT= Data Set Option
BL_FORMAT_OPT= Data Set Option
BL_HEADER= Data Set Option
BL_HOST= Data Set Option
BL_IAM_ASSUME_ROLE_ARN= Data Set Option
BL_IAM_ASSUME_ROLE_NAME= Data Set Option
BL_IAM_ROLE=   Data Set Option
BL_IDENTITY= Data Set Option
BL_IMPORT_BATCH_SIZE= Data Set Option
BL_IMPORT_OPTIONS= Data Set Option
BL_IMPORT_TABLE_LOCK= Data Set Option
BL_IMPORT_TYPE_CHECK= Data Set Option
BL_INDEX_OPTIONS= Data Set Option
BL_INDEXING_MODE= Data Set Option
BL_INFORMIXDIR= Data Set Option
BL_INTERNAL_STAGE= Data Set Option
BL_KEEPIDENTITY= Data Set Option
BL_KEEPNULLS= Data Set Option
BL_KEY= Data Set Option
BL_LOAD_METHOD= Data Set Option
BL_LOAD_REPLACE= Data Set Option
BL_LOCATION= Data Set Option
BL_LOG= Data Set Option
BL_LOGFILE= Data Set Option
BL_MAPFILE= Data Set Option
BL_MAXERRORS= Data Set Option
BL_METHOD= Data Set Option
BL_NULL= Data Set Option
BL_NUM_DATAFILES= Data Set Option
BL_NUM_READ_THREADS= Data Set Option
BL_OPTIONS= Data Set Option
BL_PARFILE= Data Set Option
BL_PATH= Data Set Option
BL_PORT= Data Set Option
BL_PORT_MAX= Data Set Option
BL_PORT_MIN= Data Set Option
BL_PRESERVE_BLANKS= Data Set Option
BL_PROTOCOL= Data Set Option
BL_PSQL_PATH= Data Set Option
BL_QUOTE= Data Set Option
BL_RECOVERABLE= Data Set Option
BL_REGION= Data Set Option
BL_REJECT_LIMIT= Data Set Option
BL_REJECT_TYPE= Data Set Option
BL_REMOTE_FILE= Data Set Option
BL_RETURN_WARNINGS_AS_ERRORS= Data Set Option
BL_ROW_DELIMITER= Data Set Option
BL_SECRET= Data Set Option
BL_SERVER_DATAFILE= Data Set Option
BL_SFTP_HOST= Data Set Option
BL_SFTP_OPTIONS= Data Set Option
BL_SFTP_USER= Data Set Option
BL_SFTP_WAIT_MILLISECONDS= Data Set Option
BL_SUPPRESS_NULLIF= Data Set Option
BL_TIMEOUT= Data Set Option
BL_TOKEN= Data Set Option
BL_USE_MANIFEST= Data Set Option
BL_USE_ESCAPE= Data Set Option
BL_USE_LOG= Data Set Option
BL_USE_PIPE= Data Set Option
BL_USE_SSL= Data Set Option
BL_WARNING_COUNT= Data Set Option
BL_WRITEBUFF= Data Set Option
BL_YB_PATH= Data Set Option
BUFFERS= Data Set Option Data Set Option
BULK_BUFFER= Data Set Option
BULKLOAD= Data Set Option
BULKUNLOAD= Data Set Option
BUSINESS_DATATYPE= Data Set Option
BUSINESS_TIMEFRAME= Data Set Option
CAST= Data Set Option
CAST_OVERHEAD_MAXPERCENT= Data Set Option
CHAR_AS_BINARY= Data Set Option
COLUMN_DELIMITER= Data Set Option
COMMAND_TIMEOUT= Data Set Option
CURSOR_TYPE= Data Set Option
DATETIME2= Data Set Option
DB_ONE_CONNECT_PER_THREAD= Data Set Option
DBCOMMIT= Data Set Option
DBCONDITION= Data Set Option
DBCONSTRAINT= Data Set Option
DBCREATE_TABLE_EXTERNAL= Data Set Option
DBCREATE_TABLE_LOCATION= Data Set Option
DBCREATE_TABLE_OPTS= Data Set Option
DBFORCE= Data Set Option
DBGEN_NAME= Data Set Option
DBINDEX= Data Set Option
DBKEY= Data Set Option
DBLABEL= Data Set Option
DBLINK= Data Set Option
DBLARGETABLE= Data Set Option
DBMAX_TEXT= Data Set Option
DBMAX_TEXT_TYPES= Data Set Option
DBNULL= Data Set Option
DBNULLKEYS= Data Set Option
DBNULLWHERE= Data Set Option
DBPROMPT= Data Set Option
DBSASLABEL= Data Set Option
DBSASTYPE= Data Set Option
DBSLICE= Data Set Option
DBSLICEPARM= Data Set Option
DBTYPE= Data Set Option
DEGREE= Data Set Option
DIMENSION= Data Set Option
DISTRIBUTE_ON= Data Set Option
DISTRIBUTED_BY= Data Set Option
ERRLIMIT= Data Set Option
ESCAPE_BACKSLASH= Data Set Option
FASTEXPORT= Data Set Option
FASTLOAD= Data Set Option
FETCH_IDENTITY= Data Set Option
FETCH_NUMERIC_TYPE= Data Set Option
HDFS_PRINCIPAL= Data Set Option
IGNORE_FEDSQL_OBJECTS= Data Set Option
IGNORE_READ_ONLY_COLUMNS= Data Set Option
IN= Data Set Option
INSERT_SQL= Data Set Option
INSERTBUFF= Data Set Option
KEYSET_SIZE= Data Set Option
LOCATION= Data Set Option
LOCKTABLE= Data Set Option
MBUFSIZE= Data Set Option
ML_CHECKPOINT= Data Set Option
ML_ERROR1= Data Set Option
ML_ERROR2= Data Set Option
ML_LOG= Data Set Option
ML_RESTART= Data Set Option
ML_WORK= Data Set Option
MODE= Data Set Option
MULTILOAD= Data Set Option
MULTISTMT= Data Set Option
NULLCHAR= Data Set Option
NULLCHARVAL= Data Set Option
OR_IDENTITY_COLS= Data Set Option
OR_PARTITION= Data Set Option
OR_UPD_NOWHERE= Data Set Option
ORHINTS= Data Set Option
OVERLAPS= Data Set Option
PARMDEFAULT= Data Set Option
PARMSTRING= Data Set Option
PARTITION_KEY= Data Set Option
PARTITIONED_BY= Data Set Option
PG_IDENTITY_COLS= Data Set Option
POST_COLUMN_OPTS= Data Set Option
POST_DML_STMT_OPTS= Data Set Option
POST_STMT_OPTS= Data Set Option
POST_TABLE_OPTS= Data Set Option
PRE_STMT_OPTS= Data Set Option
PRE_TABLE_OPTS= Data Set Option
PRESERVE_COL_NAMES= Data Set Option
QUALIFIER= Data Set Option
QUERY_BAND= Data Set Option
QUERY_TAG= Data Set Option
QUERY_TIMEOUT= Data Set Option
READBUFF= Data Set Option
READ_ISOLATION_LEVEL= Data Set Option
READ_LOCK_TYPE= Data Set Option
READ_METHOD= Data Set Option
READ_MODE= Data Set Option
READ_MODE_WAIT= Data Set Option
ROW_DELIMITER= Data Set Option
SASDATEFMT= Data Set Option
SCANSTRINGCOLUMNS= Data Set Option
SCHEMA= Data Set Option
SCRATCH_DB= Data Set Option
SEGMENT_NAME= Data Set Option
SESSIONS= Data Set Option
SET= Data Set Option
SLEEP= Data Set Option
SUB_CHAR= Data Set Option
SYSTEM_TIMEFRAME= Data Set Option
TABLE_TYPE= Data Set Option
TEMPORAL= Data Set Option
TEMPORAL_QUALIFIER= Data Set Option
TENACITY= Data Set Option
TPT= Data Set Option
TPT_APPL_PHASE= Data Set Option
TPT_BLOCK_SIZE= Data Set Option
TPT_BUFFER_SIZE= Data Set Option
TPT_CHECKPOINT_DATA= Data Set Option
TPT_DATA_ENCRYPTION= Data Set Option
TPT_ERROR_TABLE_1= Data Set Option
TPT_ERROR_TABLE_2= Data Set Option
TPT_LOG_TABLE= Data Set Option
TPT_MAX_SESSIONS= Data Set Option
TPT_MIN_SESSIONS= Data Set Option
TPT_PACK= Data Set Option
TPT_PACKMAXIMUM= Data Set Option
TPT_RESTART= Data Set Option
TPT_TRACE_LEVEL= Data Set Option
TPT_TRACE_LEVEL_INF= Data Set Option
TPT_TRACE_OUTPUT= Data Set Option
TPT_WORK_TABLE= Data Set Option
TRANSCODE_FAIL= Data Set Option
TRAP151= Data Set Option
UPDATE_ISOLATION_LEVEL= Data Set Option
UPDATE_LOCK_TYPE= Data Set Option
UPDATE_MODE_WAIT= Data Set Option
UPDATE_SQL= Data Set Option
UPDATEBUFF= Data Set Option
UPSERT= Data Set Option
UPSERT_CONDITION= Data Set Option
UPSERT_WHERE= Data Set Option
YB_JAVA_HOME= Data Set Option
Last updated: February 3, 2026