HPlogo ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL: HP 3000 MPE/iX Computer Systems > Chapter 4 ISQL Commands

STORE

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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=>
Feedback to webmaster