PARAMETERS statement [DBISQL]

Description

Specifies parameters to a DBISQL command file.

Syntax

PARAMETERS parameter1, parameter2, ...

Examples

Example 1

The following DBISQL command file takes two parameters.

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

Usage

The PARAMETERS statement specifies how many parameters there are to a command file and also gives names to those parameters 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, DBISQL prompts for values of the missing parameters.

None.

Standards

Permissions

None.

See also