Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

where nn is the sequence number of the parameter and <parameter value> is the actual value to be used. This parameter is the equivalent of the Condition Prompt dialog box.

Image Modified

The prompt parameter which is equivalent to a Conditions Prompt dialog box requesting the Sales Country "AU" would be:  QP01=AU

If you do not include this parameter, the query will be completed using the default value.

...

  • the first promptable/parameter value (QP01) set to AUSTRALIA.
  • the second promptable/parameter value (QP02) is not supplied so it would be set to its default.
  • the third promptable/parameter value (QP03) set to 10000.
  • If your promptable value contains a space, then enclose the parameter in quotes like this QP01="SOUTH AFRICA".
Note
Note: If the parameter value contains an embedded quote, such as QP01=O"PSM, then the parameter must be supplied in an input file.