Reference Manual
   CHAPTER 9. SQL Statements     

PARAMETERS statement [ISQL]

Function 

To specify parameters to a Interactive SQL command file.

Syntax 

PARAMETERS parameter1, parameter2, ...

Permissions 

None.

Side effects 

None.

See also 

READ statement

Running command files

Description 

The PARAMETERS statement names the parameters for a command file, so that they can be referenced later in the command file.

Parameters are referenced by putting:

{parameter1}

into the file where you wish the named parameter to be substituted. 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, Interactive SQL prompts for values of the missing parameters.

Standards and compatibility 

• SQL/92     Vendor extension

• Sybase     Not applicable.

Example 

• The following Interactive SQL command file takes two parameters.

  PARAMETERS department_id, file ;
  SELECT emp_lname
  FROM employee
  WHERE dept_id = {department_id}
  >#{file}.dat;