|
|
|
SAVE
Syntax
S[AVE] filename;
Description
The SAVE statement saves the last statement in the history buffer in filename. The GET and START statements can then be used to read and execute the statement from a file.
If filename does not exist, ISQL creates it. If filename does exist, ISQL overwrites it with the contents of the last statement in the history buffer.
Example
ISQL> ! more test.SQL
test.sql: No such file or directory
ISQL> select customer_name, customer_city from customers;
CUSTOMER_NAME CUSTOMER_CITY
------------- -------------
Sports Cars Inc. Sewickley
Mighty Bulldozer Inc. Baldwin Park
Ship Shapers Inc. South Miami
Tower Construction Inc. Munising
Chemical Construction Inc. Joplin
Aerospace Enterprises Inc. Scottsdale
Medical Enterprises Inc. Denver
Rail Builders Inc. Claymont
.
.
.
ISQL> save test.sql
ISQL> ! ls -al test.sql
-rw-r--r-- 1 ADMIN 51 May 1 18:21 test.sql
ISQL> ! more test.sql
select customer_name, customer_city from customers
ISQL>
