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

EDIT

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

The EDIT command invokes the editor named in the SET EDITOR option for creating or updating a file.

Scope

ISQL Only

ISQL Syntax

ED [IT]

Example

   isql=> EDIT;

   HP32201A.07.17 EDIT/3000  WED,  JUL  15, 1987,  10:19 AM

   (C) HEWLETT-PACKARD CO.  1985

   /a

      1     UPDATE STATISTICS FOR TABLE PurchDB.SupplyPrice;

      2     UPDATE STATISTICS FOR TABLE PurchDB.Orders;

      3     \\

   /k Daily.SQL

   /e

   isql=> SET EDITOR TDP.PUB.SYS;

   isql=> EDIT;

   TDP/3000     (A.04.00)  HP36578 Editor (c) COPYRIGHT Hewlett-Packard Co. 1985

    HPSPELL (A.01.01)

            MON, AUG. 18, 1987,  3:18 PM (Day #230)

   /t daily.sql;list all

       1     UPDATE STATISTICS FOR TABLE PurchDB.SUPPLYPrice;

       2     UPDATE STATISTICS FOR TABLE PurchDB.Orders;

   /m 1



       1     UPDATE STATISTICS FOR TABLE PurchDB.SupplyPrice;

   changes:                                      rOrderItems:

       1     UPDATE STATISTICS FOR TABLE PurchDB.OrderItems:

   changes:

   /k Daily.sql

   Purge old DAILY.SQL?y

   /e

   isql=>
Feedback to webmaster