The STORE command saves the contents of the command buffer in a
command file.
Scope
ISQL only.
ISQL Syntax
STO[RE]FileName [
R[EPLACE]
]
Parameters
FileName
identifies the file that will contain the contents of the
command buffer.
File name qualification follows HP-UX
conventions:
[PathName/]FileName
Unless you specify an absolute path name, ISQL assumes that any
path name you specify is relative to your current working
directory.
REPLACE
overwrites any existing file with the same name as FileName.
Description
You can also create command files from within ISQL with the EDIT
command or from HP-UX using an editor. ISQL processes only up
to the first 80 bytes of each line in the command file.
You can put commands in the command buffer with these ISQL
commands:
HOLD
RECALL FILE
RECALL HISTORY
In prompting mode, ISQL prompts you for a file name as follows:
isql=> STORE;
File name> FileName;
isql=>
If the file already exists, ISQL prompts you as to whether to
replace the existing file.
Example
isql=> RECALL FILE Monthly;
UPDATE STATISTICS FOR TABLE PurchDB.OrderItems; ...; UP
DATE STATISTICS FOR TABLE PurchDB.Inventory;
isql=> CHANGE /Inventory/Orders/;
UPDATE STATISTICS FOR TABLE PurchDB.OrderItems; ...; UP
DATE STATISTICS FOR TABLE PurchDB.Orders;
isql=> STORE Monthly REPLACE;
isql=>