Displays the value of a session option. This action is part of the Session Properties Action Set and is used to retrieve the current setting of various session-specific options.
| Parameter | Description |
|---|---|
| name | Specifies the name of a session option to display. This is a required parameter. The possible values are listed below, each with its specific description. |
| APPTAG | Displays the string that is included in the JSON log line of some CAS log messages on the CAS server. |
| AZURETENANTID | Displays the tenant ID for Azure storage. |
| BIGINTPROCESSING | Displays the status of integer processing in the session as 1 (enabled) or 0 (disabled). Alias: BIGINT |
| CASLIB | Displays the name of the active caslib. |
| CMPLIB | Displays the cmplib setting. |
| CMPOPT | Displays the code generation optimizations. |
| COLLATE | Displays the collating sequence for sorting. |
| DATASTEPFMTERR | Displays whether a DATA step generates an error when a variable format cannot be found. Alias: FMTERR |
| DATASTEPMERGENOBY | Displays whether no warning, a warning, or an error message is generated when a DATA step merge is run with no BY statement. |
| DATASTEPMSGSUMLEVEL | Displays the DATA step message summary level. When the DATA step runs on multiple threads, the same message can be generated on each thread. This parameter controls the summary level of duplicate messages. |
| DATASTEPREPLACETABLE | Displays whether a DATA step can replace an existing table. |
| DATASTEPVARLENCHK | Displays whether no warning, a warning, or an error message is generated when using APPEND and the source has longer strings than the destination. |
| DATESTYLE | Displays the date style setting. |
| DEBUGOPT | Displays the debugger options. |
| DEFAULTMEMORYFORMAT | Displays the default memory format for session tables. |
| DEFAULTTABLEREPLICATION | Displays the default new table replication factor. Alias: DEFAULTREP |
| DQLOCALE | Displays the default locale to use for data quality operations. |
| DQQKBREPOLOC | Displays the name of the caslib where QKBs are stored. |
| DQSETUPLOC | Displays the name of the default QKB to use for data quality operations. |
| EVENTDS | Displays event objects that define custom date events. |
| HISTORYLINELENGTH | Displays the maximum history line length. |
| INTERVALDS | Displays interval object pairs. |
| LOCALE | Displays the locale used for sorting and formatting. |
| LOGFLUSHTIME | Displays the log flush time. |
| MAXTABLEMEM | Displays the maximum table memory setting. |
| MAXCORESPERWORKER | Displays the maximum cores per worker. |
| MESSAGELEVEL | Displays the log message level. |
| METRICS | Displays the action metric setting. |
| NWORKERS | Displays the number of worker nodes associated with this session. |
| NLDECSEPARATOR | Displays the nldecseparator setting. |
| S2FORMATSEARCH | Displays the search path for user-defined format libraries that have been published to SingleStore for use by the EP. |
| SUBSETSESSIONCOPIES | Displays the number of backup copies of blocks for in-memory tables to create in subset sessions. |
| TIMEZONE | Displays the user local time zone. Refer to 'Time Zone Information and Time Zone Names' in the SAS System Options: Reference for more information about time zones. |
| TIMEOUT | Displays the session time-out. |
| TRANSFERSESSION | Displays whether this session is included when transferring state to a new server. |
| USEGPU | Displays whether work is offloaded to GPU. |
| YEARCUTOFF | Displays the year cutoff. |
This example shows how to retrieve the value of a session option. The specific example code is available in the linked documentation.
| 1 | // Code not provided in the HTML snippet. |