The EXPORT command copies objects from the database or temporary storage to a file.
For a target object in the database:
>>-- EXPORT --- QUERY --- ObjectName TO FileName ------------------------<< +- PROC --+ +- ( CONFIRM = YES/NO -+ >>-- EXPORT FORM ObjectName TO FileName ----------------------------------> >------------------------------------------------------------------------<< +- ( --- CONFIRM = YES/NO -----------+ +- LANGUAGE = ENGLISH/SESSION -+ >>-- EXPORT TABLE ObjectName TO FileName ---------------------------------> +- ( --- CONFIRM = YES/NO -+ +- DATAFORMAT = IXF -+
For a temporary target object:
>>-- EXPORT --- QUERY --- TO FileName -----------------------------------<< +- PROC --+ +- ( CONFIRM = YES/NO -+ >>-- EXPORT FORM TO FileName --------------------------------------------<< +- ( --- CONFIRM = YES/NO -----------+ +- LANGUAGE = ENGLISH/SESSION -+ >>-- EXPORT DATA TO FileName --------------------------------------------<< +- ( --- CONFIRM = YES/NO -+ +- DATAFORMAT = QMF/IXF/TEXT/HTML/CSV -+ +- OUTPUTMODE = BINARY/CHARACTER/PC -+ +- LOBSINFILE = YES/NO -+ +- LOBSTO = path1;path2; -+ +- LOBFILE = basefile1;basefile2; -+ >>-- EXPORT REPORT TO FileName ------------------------------------------<< +- ( --- CONFIRM = YES/NO --+ +- DATAFORMAT = QMF/HTML/TEXT -+
Parameter | Description |
---|---|
ObjectName | The name of the object to export from the database. |
FileName | The name of the file to which to export the object. |
CONFIRM | Specifies whether or not to display a confirmation dialog before replacing an existing file. If CONFIRM is not specified or is NO, the corresponding resource limit is used. |
LANGUAGE | Specifies whether a form is exported in English or in the current session language. A form that is exported in English can be run in any NLF session. A form exported 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. |
DATAFORMAT | Specifies the file format of the exported data.
If you omit this parameter, the DSQQW_EXP_DT_FRMT global variable supplies
the format to be used.
The file format can be:
For Reports QMF format is not supported in the Windows environment. HTML format adds the <PRE> tag. TEXT is for a text-based file. |
OUTPUTMODE | Specifies the output format of the data. |
LOBSINFILE | Specifies whether or not LOBs are included in the exported data. |
LOBSTO | Specifies the location to save the LOBs. |
LOBSFILE | Specifies the base name of the exported LOBs. |
EXPORT QUERY USER1.QUERY TO C:\Queries\query1.qry