GENERATE VIEWS

Generates SQL commands to recreate one or more views in a DBEnvironment.

Scope

SQLGEN Only

SQLGEN Syntax

>> [GENERATE] VIEW[S] Schema File Name or '//' to STOP command >> SchemaFileName Do you wish to generate associated View Authority (n/y)? { N [O] Y [ES]} Owner Name >> OwnerName Do you wish to specify View Names for each Owner (n/y)? { N [O] Y [ES]} View Name for Owner OwnerName >> ViewName

Parameters

SchemaFileName: is the name of the schema file where SQLGEN places generated commands.
NO or YES: respond NO if you do not want to generate associated authorities; respond YES if you want to generate associated authorities.
OwnerName: is the name of the owner whose views you wish to generate.
NO or YES: respond NO to select all view names for the owner; respond YES to select certain view names for the owner.
ViewName: is the name of a view you wish to generate.

Description

GENERATE VIEWS builds CREATE VIEW commands to recreate one or more views in the DBEnvironment. You can also recreate associated authorities for the specified views.

Example

      >> generate views



      ALLBASE/SQL Command Generator for Views



      Schema File Name or '//' to STOP command >> partvsch



      Do you wish to generate associated View Authority (n/y)? y



      Please enter Owner Names. Type @ for all, ? for a list of

      Owner Names, or RETURN to quit.



      Owner Name >> purchdb

      Do you wish to specify View Names for each Owner (n/y)? y



      Enter View Names for Owner PURCHDB

      Type @ for all, ? for a list of View Names, or RETURN to quit.



      View Name for Owner PURCHDB >> vendorstatistics



      Generating CREATE VIEW PURCHDB.VENDORSTATISTICS



      Generating Authority for PURCHDB.VENDORSTATISTICS



      View Name for Owner PURCHDB >>   Return 



      Owner Name >>   Return 



      >>

Schema File Produced

       SET OWNER PURCHDB;

      CREATE VIEW PURCHDB.VENDORSTATISTICS

           (VENDORNUMBER,

            VENDORNAME,

            ORDERDATE,

            ORDERQUANTITY,

            TOTALPRICE)  AS

      SELECT PurchDB.Vendors.VendorNumber,PurchDB.Vendors.VendorName

      , OrderDate, OrderQty, OrderQty*PurchasePrice FROM

      PurchDB.Vendors, PurchDB.Orders, PurchDB.OrderItems WHERE

      PurchDB.Vendors.VendorNumber = PurchDB.Orders.VendorNumber AND

      PurchDB.Orders.OrderNumber = PurchDB.OrderItems.OrderNumber;



      GRANT SELECT

         ON PURCHDB.VENDORSTATISTICS TO PURCHMANAGERS;



      GRANT SELECT

         ON PURCHDB.VENDORSTATISTICS TO PURCHDBMAINT;



      GRANT SELECT

         ON PURCHDB.VENDORSTATISTICS TO TOM@ASH;



      GRANT SELECT,

            INSERT,

            DELETE,

            UPDATE

         ON PURCHDB.VENDORSTATISTICS TO DBEUSERS;