Prints the default values for SPD Server macro variables.
proc spdo lib=libref;
spdsmac;
SPD Macro Variables list/settings. SPDSACWH=NO Controls whether to use Where clause filtering for HADOOP processing. SPDSAUNQ=NO Controls appends to tables with unique indexes. SPDSBNEQ=NO Controls BYNOEQUALS for BY processing. SPDSBSRT=YES Controls Sorting for BY processing. SPDSCLJX=NO Controls whether SAS will consider doing an index join to a SPD cluster table index with an unknown number of values. SPDSCOMP=YES Controls Network Data Compression. SPDSCMPF=0 Number of bytes free in each compress block for later updates. Default is 0 bytes. SPDSDCMP=NO Controls Data Compression. SPDSEINT=YES Controls network interrupts for SQL pass-through. SPDSEOBS=0 Ending observation number. SPDSEV1T=1 EVAL1 method type(0=sync,1=async). SPDSEV2T=1 EVAL2 method type(0=sync,1=async). SPDSFSAV=NO Controls whether output files are deleted. SPDSHPRD=NO Controls whether to use parallel reads for HADOOP processing. SPDSIASY=NO Controls whether indexes are created in parallel. SPDSIPDB=NO Controls whether Implicit SQL Pass-Through errors appear in the SAS log. SPDSIRAT=0 Percentage of segments on which to perform pre-evaluation. SPDSNBIX=NO Controls use of indexes during a BY sort. SPDSNETP=4096 Network Packet Size. SPDSNIDX=NO Controls whether indexes are used during Where clause planning or by processing. SPDSRSSL=NO Controls SSL communication with the server. SPDSSADD=NO Controls whether record updates are synchronous. Important when using Unique indexes and duplicate values are detected. SPDSSIZE=0 File Partition size (in M units). SPDSSOBS=0 Starting observation number. SPDSSQLR=NO SQL reset options specified in implicit pass-through. SPDSSTAG=NO Controls whether to use tagged sorting. SPDSTCNT=0 Number of threads to use during Where clause evaluations. SPDSUSAV=NO Controls whether records with duplicate keys are saved in a SAS Data Set. SPDSUSDS= Name of the SAS Data Set which has the records with duplicate keys. SPDSVERB=NO Controls verbose listing of data set contents. SPDSWCST=NO Controls whether to use dynamic Where clause costing. SPDSWDEB=NO Controls whether WHERE clause planning tree is printed. SPDSWSEQ=NO Controls whether to override Where clause costing.