HPlogo ALLBASE/ISQL Reference Manual: HP 9000 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 using the SET EDITOR option for creating or updating a file.

Scope

ISQL only.

ISQL SYNTAX

ED[IT] [FileName]

Parameters

FileName

identifies the file you want to edit. 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.

Example

   isql=> LIST SET EDITOR;

   ed[itor]          - /usr/bin/vi



   isql=> EDIT;

   ~

   ~

   ~

   UPDATE STATISTICS FOR TABLE PurchDB.SupplyPrice;

   UPDATE STATISTICS FOR TABLE PurchDB.Orders;

   :wq Daily

   "Daily" [New file] 2 lines, 94 characters

   isql=> SET EDITOR /usr/bin/ex;

   isql=> EDIT;

   :e Daily

   "Daily" 2 lines, 94 characters

   :1,$#

   1  UPDATE STATISTICS FOR TABLE PurchDB.SupplyPrice;

   2  UPDATE STATISTICS FOR TABLE PurchDB.Orders;

   :1,s/SupplyPrice/OrderItems/

   UPDATE STATISTICS FOR TABLE PurchDB.OrderItems:

   :wq

   "Daily" 2 lines, 94 characters

   isql=>
Feedback to webmaster