Specifies whether the SAP HANA engine uses the defaults for variables and parameters that are specified in the metadata in SAP HANA.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Alias: | USE_PARAMETER_DEFAULT |
| Default: | none |
| Data source: | SAP HANA |
Table of Contents
specifies to look up metadata for variables and parameters. This enables you to apply defaults for variables in a WHERE clause, and defaults for input parameters using the PLACEHOLDER syntax.
specifies to not look up metadata for variables and parameters.
The default for the PARMDEFAULT= option is YES if the PARMSTRING= LIBNAME= or data set option is specified. The default is NO if no PARMSTRING= option is specified.
Applying the defaults requires additional queries to the metadata. It can be switched off to avoid making unnecessary queries.