HP 3000 Manuals

ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL

EXTRACT 
[REV BEG]

The EXTRACT command copies modules from a DBEnvironment into an
installable module file.

Scope 

ISQL only.

ISQL Syntax 

        {MODULE [Owner.]ModuleName [,...]                }
EXTRACT {SECTION [Owner.]ModuleName(SectionNumber) [,...]}
        {ALL MODULES                                     }

[NO SETOPTINFO] INTO FileName 

Parameters 

[Owner.]ModuleName      identifies the module containing sections to be
                        extracted.

SectionNumber           specifies the section contained in the module.

FileName                identifies the file containing the installable
                        modules.  If the file already exists, it is
                        overwritten.

Description 

   *   The EXTRACT command does not remove a module from the
       DBEnvironment.  It copies the module into an installable module
       file.

   *   The NO SETOPTINFO clause prevents access plans specified by the 
       SETOPT statement from being used by the sections placed in the
       installable module file.

   *   Modules are installed with the INSTALL command and deleted with
       the DROP MODULE statement.  Use the LIST INSTALL command to view
       the names of modules in an installable module file.

   *   Query the SYSTEM.SECTION view to identify the module name and
       section numbers.

Authorization 

You can execute this statement if you have DBA or OWNER authority for the
module.

Example 

     isql=> EXTRACT MODULE CEX9 INTO CEX9MOD; 

     Extract     6 sections from module PGMR1@ACCT3.CEX9.

     Number of modules extracted: 1.

     isql=>
[REV END]

MPE/iX 5.0 Documentation