1.1

|0.6 |1.7
|20 |10 |5
US|Union Standard Airlines |0.19 |0.05
|0.4 |1.6
|20 |10 |5
AA|Amazonian Airways |0.18 |0.03
|0.5 |1.5
|20 |10 |5
3 rows selected
run
Treats the value of the string as a valid file name, and redirects sqlf processing to read from that file until it
ends or an exit command is executed.
Syntax
RUN
String
Description
Treats the value of the string as a valid file name, and redirects sqlf processing to read from that file until it
ends or an exit on page 433 command is executed. If the end of the file is reached without sqlf exiting, reading
continues from the previous input source once the end of the file is reached. Files can contain Run commands.
sqlf prints out the statements in the file as it executes them.
Any changes made to the sqlf environment by the file are visible in the environment when processing resumes.
Example
sqlf(PEERCLIENT)> run 'ToursDB_schema.sql';
set connection
Specifies which connection to make current when more than one connection is open.
Syntax
SET CONNECTION
Identifier
Description
Allows you to specify which connection to make current when you have more than one connection open. Use
the show on page 445 command to display open connections.
vFabric SQLFire User's Guide444
vFabric SQLFire Reference