output  read

Chapter 2: Interactive SQL Commands

parameters

Description

Specifies parameters to an Interactive SQL command file.

Syntax

parameters parameter1, parameter2, . . .

Examples

Example 1

This 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 execute this command.

See also

read





Copyright © 2005. Sybase Inc. All rights reserved. read

View this book as PDF