Special Control Arguments

9.6.4 Special Control Arguments

Use the PAR_LST parameter to specify special control arguments and additional arguments to be passed into the R script.

Argument	Syntax and Description
`ore.drop`	Syntax `ore.drop: bool, true` (default) Description Controls the object type for the input data. If `true`, a onecolumn data.frame will be converted to a vector. If `false`, a one column data.frame will not be converted.
`ore.na.omit`	Syntax `ore.na.omit : bool, false` (default) Description Controls the handling of missing values in the input data. If `true`, rows or vector elements, depending on the `ore.drop` setting,containing missing values will be removed from the input data. If `false`, do not omit rows with missing values from the table. If all therows in an `rqRowEval` chunk contain missing values, the input data for that chunk will be an empty data.frame or vector.
`ore.png.*`	Syntax `ore.png.*: numeric or character` Description If `ore_graphics_flag` is `true`, additional parameters for the `png` graphics device driver. The naming convention for these arguments is to add an `ore.png`. prefix to the arguments of the `png` function. For example, if `ore.png.height` is supplied, argument `height` will be passed to the `png` function. If not set, standard default values for the `png` function are used.
`ore.characterAsFactor`	Syntax `ore.characterAsFactor: bool, false (default)` Description Controls the type that character and factor columns of the input table are treated as.If `true`, all character and factor columns are treated as factor type.If `false`, all character and factor columns are treated as character type. For functions `rqGroupEval2` and `rqRowEval2`, each partition will be only aware of factor levels in itself and will not be aware of levels in other partitions.
`ore_async_flag`	Syntax `ore_async_flag: bool, false` (default) Description If `true`, the job will be submitted asynchronously. If `false`, the job will be executed in synchronous mode.
`ore_graphics_flag`	Syntax `ore_graphics_flag:bool, false` (default) Description If `true`, the server will capture images rendered in the R script. If `false`, the server will not capture images rendered in the R script.
`ore_parallel_flag`	Syntax `ore_parallel_flag:bool, false` (default) Description If `true`, the R script will be run with data parallelism. Data parallelism is only applicable to `rqRowEval2`, `rqGroupEval2`, and `rqIndexEval2`. If `false`, the R script will not be run with data parallelism.
`ore_service_level`	Syntax `ore_service_level : string`, allowed values: '`LOW`'(default), '`MEDIUM`', '`HIGH`' Description Controls the different levels of performance and concurrency in Autonomous AI Database.
`timeout`	Syntax `timeout: int`, 1800 (default) Description The asynchronous timeout limit, expressed in seconds, must be used with the argument`ore_async_flag` set to `true`. Allowed values are in the range [1800, 43200].

Examples

Drop rows with missing values from input data:
```
par_lst => '{"ore_na_omit":true}'
```
Submit a job in asynchronous mode:
```
par_lst => '{"ore_async_flag":true}'
```

Use MEDIUM service level:

par_lst => '{"ore_service_level":"MEDIUM"}'

Use timeout argument:

par_lst => '{"ore_async_flag":true, "timeout": 4000}'

Parent topic: SQL API for Embedded R Execution with Autonomous AI Database