READ statement [DBISQL]

Description

Reads dbisql statements from a file.

Syntax

READ filenameparameters ]

Examples

Example 1

Examples of the READ statement:

READ status.rpt '160'
READ birthday.sql [>= '1988-1-1'] [<= '1988-1-30']

Usage

The READ statement reads a sequence of dbisql statements from the named file. This file can contain any valid dbisql statement, including other READ statements, which can be nested to any depth. To find the command file, dbisql first searches the current directory, then the directories specified in the environment variable SQLPATH, then the directories specified in the environment variable PATH. If the named file has no file extension, dbisql also searches each directory for the same file name with the extension SQL.

Parameters can be listed after the name of the command file. These parameters correspond to the parameters named on the PARAMETERS statement at the beginning of the statement file (see PARAMETERS statement [DBISQL]). dbisql then substitutes the corresponding parameter wherever the source file contains:

{ parameter-name }

where parameter-name is the name of the appropriate parameter.

The parameters passed to a command file can be identifiers, numbers, quoted identifiers, or strings. When quotes are used around a parameter, the quotes are put into the text during the substitution. Parameters that are not identifiers, numbers, or strings (contain spaces or tabs) must be enclosed in square brackets ([ ]). This allows for arbitrary textual substitution in the command file.

If not enough parameters are passed to the command file, dbisql prompts for values for the missing parameters.


Encoding

The READ statement also supports an ENCODING clause, which lets you specify the encoding that is used to read the file. For more information, see “READ statement [Interactive SQL]” in SQL Anywhere Server – SQL Reference > Using SQL > SQL statements > SQL statements (P-Z).


Side effects

None

Standards

Permissions

None

See also

DEFAULT_ISQL_ENCODING option [DBISQL]

PARAMETERS statement [DBISQL]