The IMPORT command copies data from a file into temporary storage or to the database.
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; -+
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. |
IMPORT QUERY FROM C:\Queries\query1.qry