User's Guide Part VI. SQL Anywhere Reference Chapter 43. Watcom-SQL StatementsTo read ISQL statements from a file.
READ filename [ parameters ]
ISQL.
None.
None.
The READ statement reads a sequence of ISQL statements from the named file. This file can contain any valid ISQL statement including other READ statements. READ statements can be nested to any depth. To find the command file, ISQL will first search 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, ISQL 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"). ISQL will then substitute 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 which 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, ISQL prompts for values for the missing parameters.
The following are examples of the READ statement.
READ status.rpt '160'
READ birthday.sql [>= '1988-1-1'] [<= '1988-1-30']