FedSQL Statement Table Options

Overview of Statement Table Options
How Table Options Interact with Other Types of Options
FedSQL Statement Table Option Syntax
Understanding BULKLOAD Table Options
FedSQL Statement Table Options by Data Source

ABCDEGHILOPRSTUW

ALTER= Table Option
ASYNCINDEX= Table Option
BL_ALLOW_READ_ACCESS= Table Option
BL_COPY_LOCATION= Table Option
BL_CPU_PARALLELISM= Table Option
BL_DATA_BUFFER_SIZE= Table Option
BL_DEFAULT_DIR= Table Option
BL_DISK_PARALLELISM= Table Option
BL_ERRORS= Table Option
BL_EXCEPTION= Table Option
BL_INDEXING_MODE= Table Option
BL_LOAD= Table Option
BL_LOAD_REPLACE= Table Option
BL_LOG= Table Option
BL_LOGFILE= Table Option
BL_OPTIONS= Table Option
BL_PARALLEL Table Option
BL_PORT_MAX= Table Option
BL_PORT_MIN= Table Option
BL_RECOVERABLE= Table Option
BL_REMOTE_FILE= Table Option
BL_SKIP= Table Option
BL_SKIP_INDEX_MAINTENANCE= Table Option
BL_SKIP_UNUSABLE_INDEXES= Table Option
BL_WARNING_COUNT= Table Option
BLOCKSIZE= Table Option
BUFNO= Table Option
BUFSIZE= Table Option
BULKLOAD= Table Option
BULKOPTS= Table Option
COMPRESS= Table Option
CONFIG= Table Option
COPIES= Table Option
DATAFILE= Table Option
DBCREATE_INDEX_OPTS=
DBCREATE_TABLE_OPTS= Table Option
ENCODING= Table Option
ENCRYPT= Table Option
ENCRYPTKEY= Table Option
ENDOBS= Table Option
EXTENDOBSCOUNTER= Table Option
GP_DISTRIBUTED_BY= Table Option
HASH= Table Option
IDXNAME= Table Option
IDXWHERE= Table Option
IOBLOCKSIZE= Table Option
LABEL= Table Option
LOCKTABLE= Table Option
ORDERBY= Table Option
ORHINTS= Table Option
ORNUMERIC= Table Option
PADCOMPRESS= Table Option
PARTSIZE= Table Option
PARTITION= Table Option
PARTITION_KEY= Table Option
PASSWORD= Table Option
PERM= Table Option
PICKLIST= Table Option
POINTOBS= Table Option
PW= Table Option
READ= Table Option
REUSE= Table Option
SQUEEZE= Table Option
STARTOBS= Table Option
TABLE_TYPE=
TD_BUFFER_MODE= Table Option
TD_CHECKPOINT= Table Option
TD_DATA_ENCRYPTION= Table Option
TD_DROP_ERROR_TABLE= Table Option
TD_DROP_LOG_TABLE= Table Option
TD_DROP_WORK_TABLE= Table Option
TD_ERROR_LIMIT= Table Option
TD_ERROR_TABLE_1= Table Option
TD_ERROR_TABLE_2= Table Option
TD_LOG_MECH_TYPE= Table Option
TD_LOG_MECH_DATA= Table Option
TD_LOG_TABLE= Table Option
TD_LOGDB= Table Option
TD_MAX_SESSIONS= Table Option
TD_MIN_SESSIONS= Table Option
TD_NOTIFY_LEVEL= Table Option
TD_NOTIFY_METHOD= Table Option
TD_NOTIFY_STRING= Table Option
TD_PACK= Table Option
TD_PACK_MAXIMUM= Table Option
TD_PAUSE_ACQ= Table Option
TD_SESSION_QUERY_BAND= Table Option
TD_TENACITY_HOURS= Table Option
TD_TENACITY_SLEEP= Table Option
TD_TPT_OPER= Table Option
TD_TRACE_LEVEL= and TD_TRACE_LEVEL_INF= Table Options
TD_TRACE_OUTPUT= Table Option
TD_WORK_TABLE= Table Option
TD_WORKING_DB= Table Option
THREADNUM= Table Option
TYPE= Table Option
UCA= Table Option
UNIQUESAVE= Table Option
USER= Table Option
WHERENOINDEX= Table Option
WRITE= Table Option
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 23, 2017