Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Interactive SQL Online Help Interactive SQL Version 16.0 » Using DBISQL commands

parameters

Description

Specifies parameters to an Interactive SQL command file.

Syntax

parameters parameter1, parameter2, . . .

Examples

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

If you save this script in a file named test.sql, you can run it from Interactive SQL using the following command:

read test.SQL [100] [data]

Usage

Permissions

Any user can run this command.

Side effects

None.

See also

read