HP 3000 Manuals

ALLBASE/ISQL Reference Manual

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 XL 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 XL 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