PARAMETERS Statement [Interactive SQL]

Specifies parameters to an Interactive SQL (dbisql) command file.

Quick Links:

Go to Examples

Go to Usage

Go to Standards

Go to Permissions

Syntax

PARAMETERS parameter1, parameter2, …

Examples

(back to top)

Usage

(back to top)

PARAMETERS specifies how many parameters there are to a command file and also names those parameters so that they can be referenced later in the command file.

Parameters are referenced by putting the named parameter into the command file where you want the parameter to be substituted:

{parameter1}

There must be no spaces between the braces and the parameter name.

If a command file is invoked with fewer than the required number of parameters, dbisql prompts for values of the missing parameters.

Standards

(back to top)

  • SQL—Vendor extension to ISO/ANSI SQL grammar.
  • SAP Sybase Database product—Not applicable.

Permissions

(back to top)

None

Related reference
READ Statement [Interactive SQL]