EXTRACT

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

Scope

ISQL only.

ISQL SYNTAX

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

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 cex9.sqlm;



   Extract     6 sections from module CEX9.



   Number of modules extracted: 1.



   isql=>