Specifies a quoted string of variable name and value pairs separated by a comma, or a placeholder string.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Alias: | PARAMETERS |
| Default: | none |
| Data source: | SAP HANA |
Table of Contents
specifies the variable name and value pair. More than one pair can be specified and must be separated by a comma.
specifies the variable name and value pair as a placeholder.
PARMSTRING="variable-name1=variable-value1",
<'PLACEHOLDER'=('variable-name2','variable-value2')"When you specify the variable name and value pairs, the SAS/ACCESS engine locates the variable input parameter in the SAP HANA metadata. The value is applied either as a WHERE clause for variables, or it generates and applies a PLACEHOLDER= string for passing the input parameters to the view execution. If the variable input parameter is not found in metadata, it is appended as part of a PLACEHOLDER= string to the generated SQL string.
If the user specifies a placeholder string, the string is passed directly to the SAP HANA query to be processed in SAP HANA.
Here are some syntax examples:
PARMSTRING = "parm_price=30"
PARMSTRING = "'PLACEHOLDER' = ('$$parm_product$$', 'Tablet')"
PARMSTRING = "PLACEHOLDER.'$$parm_category$$'=>'Notebooks'"
When a PARMSTRING= LIBNAME option and a PARMSTRING= data set option are both specified, the PLACEHOLDER= string becomes a combination of both of the parameters and is passed to SAP HANA. An input parameter can occur only once as a placeholder in the SQL statement. If a parameter appears in the LIBNAME option and the data set option, the SAS/ACCESS engine tries to resolve this by passing only a fragment from the data set option.
The PARMSTRING= LIBNAME option is applied to all column tables and column views in the library. It is not applied to row store objects.
The PARMSTRING= data set option is applied to the table or view that is specified.