Predefined parameters for Batchrunner calls

Previous Next

You can pass the following predefined parameters in calls to the BatchRunner internal component.

NOTE: The call syntax is unexpected for a number of reasons:

Parameter values must precede parameter names in the SELECT output list, because each parameter name is passed as a column alias.

String values and booleans must be quoted under SELECT. Only number values must remain unquoted.

Parameter names must be double-quoted if they contain the special hyphen (-) character to prevent the SQL parser from interpreting the hyphen as a minus operator. Double-quoting aliases is always legal, but it is necessary if the alias contains a character with special status in SQL, such as a hyphen (‑) or a space ( ).

Example

The -quiet parameter is listed as:

Parameter

Value

-quiet

{ true | false }

 

A job method example using -quiet is:

INVOKE   BatchRunner.MyJob WITH
SELECT   customer_id     "customer_id"
,        'true'          "-quiet"
FROM     ...

The same call using RunJob() looks like this:

INVOKE   BatchRunner.RunJob WITH
SELECT   'MyJob'
,        customer_id     "customer_id"
,        'true'          "-quiet"
FROM     ...

 

 

collapse-colsep
collapse-create_err
collapse-create_mes
collapse-create_suc
collapse-data_directory
collapse-filename
collapse-logfile
collapse-nvl
collapse-quiet
collapse-returnstatus
collapse-string_delimiter
collapse-user_table
collapse-wlogfile