parameters  set connection

Chapter 2: Interactive SQL Commands

read

Description

Reads Interactive SQL statements from a file.

Syntax

read [ encoding encoding ] file_name [ parameters ]

encoding : identifier or string

Parameters

encoding

allows you to specify the encoding that is used to write the file. encoding can be used only with the ASCII format.

file_name

is the name of the file you are reading.

parameters

correspond to the parameters listed in the statement file.

identifier

is the identifier you are using to indicate the file you are reading.

string

is the string you are using to indicate the file you are reading.

Examples

Example 1

These are examples of the read statement:

READ status.rpt '160'

READ birthday.SQL [>= '1988-1-1'] [<= '1988-1-30']

Usage

Permissions

Any user can execute this command.





Copyright © 2005. Sybase Inc. All rights reserved. set connection

View this book as PDF