1.1.1

A&|AIRLINE_FULL |BASIC_RATE
|DISTANCE_DISCOUNT |BUSINESS_LEVEL_FACTOR
|FIRSTCLASS_LEVEL_FACT&|ECONOMY_SE&|BUSINESS_S&|FIRSTCLASS&
-----------------------------------------------------------------------------------------------------------------------------------------------------------
NA|New Airline |0.2 |0.07
|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
AN|Another New Airline |0.2 |0.07
|0.6 |1.7
|20 |10 |5
4 rows selected
sqlf(PEERCLIENT)> rollback;
sqlf(PEERCLIENT)> select * from airlines;
A&|AIRLINE_FULL |BASIC_RATE
|DISTANCE_DISCOUNT |BUSINESS_LEVEL_FACTOR
|FIRSTCLASS_LEVEL_FACT&|ECONOMY_SE&|BUSINESS_S&|FIRSTCLASS&
-----------------------------------------------------------------------------------------------------------------------------------------------------------
NA|New Airline |0.2 |0.07
|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 445 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.
vFabric SQLFire User's Guide456
vFabric SQLFire Reference