HP 3000 Manuals

ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL

STORE 

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.  Name
                        qualification follows MPE/iX naming conventions.

                             FileName[/Lockword][.Group[.Account]]

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 MPE/iX using an editor.  ISQL processes only up to
       the first 72 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=>

MPE/iX 5.0 Documentation