DB2 graphic QMF Version 8

IMPORT command

The IMPORT command copies data from a file into temporary storage or to the database.

Syntax

For a target object in the database:

>>-- IMPORT --- QUERY --- ObjectName FROM FileName ------------------------>
             +- PROC --+

>------------------------------------------------------------------------<<
  +- ( --- CONFIRM = YES/NO ---+
        +- COMMENT = Text ---+
        +- SHARE = YES/NO ---+


>>-- IMPORT FORM ObjectName FROM FileName --------------------------------->

>------------------------------------------------------------------------<<
  +- ( --- CONFIRM = YES/NO -------------+
        +- COMMENT = Text -------------+
        +- LANGUAGE = ENGLISH/SESSION -+
        +- SHARE = YES/NO -------------+
>>-- IMPORT TABLE ObjectName FROM FileName -------------------------------->
>------------------------------------------------------------------------<<
  +- ( --- CONFIRM = YES/NO ----------+
        +- COMMENT = Text ----------+
        +- ACTION = REPLACE/APPEND -+

For a temporary target object:

>>-- IMPORT --- QUERY --- FROM FileName ---------------------------------<<
             +- PROC --+
             +- FORM --+
             +- DATA --+
                +- LOBSFROM = path1;path2; -+

Parameters

Table 42. IMPORT Command Parameters
Parameter Description
ObjectName The name of the object to import into the database.
FileName The name of the file from which to import the object.
CONFIRM Specifies whether to display a confirmation dialog before replacing an existing object. If CONFIRM is not specified or is set to NO, the corresponding resource limit is used.
COMMENT Specifies a comment with the imported object. Enclose the text in quotes.
SHARE Specifies whether or not other users are allowed to use the imported object.
LANGUAGE Specifies whether a form is imported in English or in the current session language. A form that is imported in English can be run in any NLF session. A form that is imported in the session language can only be run in a session of the same language. The default value is provided by the DSQEC_FORM_LANG global variable.
ACTION Specifies whether or not to replace the entire database table or append data to the existing table.
LOBSFROM Specifies the location of the LOB.

Example

IMPORT QUERY FROM C:\Queries\query1.qry


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004