Using the GATEWAY EXPORT option at the command line, now you can automate the entire task of providing desired data formats to your end-user and/or clients. No more limit on importing (using GATEWAY IMPORT) or exporting (using GATEWAY EXPORT) numerous records into and out of R:BASE 7.6 for Windows database.

Export Format Includes:

·Paradox (*.db)  
·dBBASE (*.dbf)  
·Comma Separated Values (*.csv)  
·HTM (*.htm, *.html)  
·MS Excel Spreadsheet (*.xls)  
·MS Excel Workbook (*.xls)  
·MS Word (*.doc)  
·Tab Delimited (*.tab)  
·SYLK Symbolic Link (*.slk)  
·DIF Data Interchange Format (*.dif)  
·Lotus 1-2-3 (*.wk1)  
·Quattro Pro (*.wq1)  
·SQL Script (*.sql)  
·XML (*.xml)  
·MS Windows Clipboard  
·Rich Text Format (*.rtf)  
·SPSS Format (*.sav)  
·Adobe Acrobat Portable Document Format (*.pdf)  
·LDAP Data Interchange Format (*.ldif)  

You can access File Gateway module either by clicking on "Open File Gateway to Import/Export Data" icon on the Main Window Toolbar or typing GATEWAY at the R> prompt or in a command file.

In this document we'll cover GATEWAY EXPORT command at the R> prompt or in a command file.


Syntax:

gateway


type

DB
Paradox
DBF
dBASE
CSV
Comma Separated Values
HTM
HTML
XLS
MS Excel Spreadsheet
XLSW
MS Excel Workbook
DOC
MS Word
TAB
ASCII File, Delimiter Tab, Qualifier None
SLK
SYLK Symbolic Link
DIF
DIF Data Interchange Format
WK1
Lotus 1-2-3
WQ1
QuattroPro
SQL
SQL Script
XML
XML
CLBR
MS Windows Clipboard
RTF
Rich Text Format
SAV
SPSS Format
PDF
Adobe Acrobat Portable Document Format
LDIF
LDAP Data Interchange Format
 
 

filename
Name and associated extension of target file with exported data


SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION
Extended parameters supported for each file format

·COL_NAMES  
·TAB_NAME  
·TITLE  
·HTML_PATERN  
·QUALIFIER  
·SEPARATOR  
·BLANK_IF_ZERO  
·REC_SEP  
·STYLE  
·SHOW_PROGRESS  
·MESSAGES  
·ACTION  
·SPECIFICATION_FILE_NAME - This property is used to load a prepared specification with all pre-defined settings for exporting. The export must be performed once using the graphic user interface "Export Wizard" and saved using the "Specifications.." button. The specifications will be stored in a file with the .RGW file extension.  
 
NOTES:
Use pipe | symbol to separate OPTION parameters if more than one option is used.

Options listed above may vary based upon selected format.


Exporting Data as Paradox (*.db) Format:

Syntax:

GATEWAY EXPORT DB filename.db SELECT clause OPTION SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.db
This parameter defines the file name of target file with exported data as Paradox format. File extension must be db.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW                                

Example:

GATEWAY EXPORT DB D:\TEMP\EMPLOYEE.DB SELECT * FROM EMPLOYEE OPTION SHOW_PROGRESS ON


NOTES:  
This option allows you to export data as Paradox format using BDE Engine. For use this option, you need to have BDE 32 bit version installed on your computer.


Exporting Data as dBASE (*.dbf) Format:

Syntax:

GATEWAY EXPORT DBF filename.dbf SELECT clause OPTION SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.dbf
This parameter defines the file name of target file with exported data as dBASE format. File extension must be dbf.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  

SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT DBF D:\TEMP\EMPLOYEE.DBF SELECT * FROM EMPLOYEE OPTION SHOW_PROGRESS ON

NOTES:
This option allows to export a data as dBASE format using BDE Engine. For use this option, you need to have BDE 32 bit version installed on your computer.


Exporting Data as Comma Separated Values (*.csv) Format:


Syntax:

GATEWAY EXPORT CSV filename.csv SELECT clause OPTION COL_NAMES |QUALIFIER symbol |SEPARATOR symbol |REC_SEP value |SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.csv
This parameter defines the file name of target file with exported data as Comma Separated Values format. File extension must be csv.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  

Available Parameters: ON  
OFF  

QUALIFIER  
Changing the value of this option you can define any qualifier for fields in the target Comma Separated Values text file.  

The popular value is Quotes (") but you can define any custom character you wish.  

SEPARATOR  
Defines the separator of fields in target text file.  

The popular values are Semicolon (;), Comma (,), Space (#32) but you can define any other character if you wish.  
 
BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  

REC_SEP  
Defines the separator between lines in the target text file.  

The popular value is CRLF (#13#10) or CR(#13) but you can define any other custom string.  

Available Parameters: CR  
LF  
CRLF  

SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT CSV D:\TEMP\EMPLOYEE.CSV SELECT * FROM EMPLOYEE OPTION COL_NAMES ON |QUALIFIER " |SEPARATOR , |REC_SEP CRLF |SHOW_PROGRESS ON |ACTION OPENVIEW


Exporting Data as HTM (*.htm) Format:

Syntax:

GATEWAY EXPORT HTM filename.htm SELECT clause OPTION HTML_PATERN filespec |SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.htm
This parameter defines the file name of target file with exported data as HTML format. File extension must be either htm or html.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

HTML_PATERN  
In this option you can define your own pattern of html_file where you can customize any settings _ fonts, colors, metatags, scripts etc Using this option you can integrate the generated html_file into your own web_site.  

By default the HTML Pattern have a simple structure:  

<html>  
<head>  
<meta http_equiv="Content_Type"  
content="text/html; charset=windows_1251">  
<meta name="GENERATOR" content="RBG7 Gateway">  
<title>Data Exported by R:BASE 7.6 File Gateway</title>  
</head>  
<body bgcolor="#FFFFFF">  
</body>  
 
BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  

SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT HTM D:\TEMP\EMPLOYEE.HTML SELECT * FROM EMPLOYEE OPTION SHOW_PROGRESS ON |ACTION OPENVIEW
               
GATEWAY EXPORT HTM D:\TEMP\EMPLOYEE.HTML SELECT (EmpLName+','&EmpFName) AS Employee_List FROM EMPLOYEE OPTION ACTION OPENVIEW

Notes:
The generated data table will be inserted before </body> tag.


Exporting Data as MS Excel Spreadsheet (*.xls) Format:

Syntax:

GATEWAY EXPORT XLS filename.xls SELECT clause OPTION COL_NAMES value |SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.xls
This parameter defines the file name of target file with exported data as MS Excel Spreadsheet. File extension must be xls.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  

Available Parameters: ON  
OFF  

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT XLS D:\TEMP\EMPLOYEE.XLS SELECT * FROM EMPLOYEE OPTION COL_NAMES ON |SHOW_PROGRESS ON |ACTION OPENVIEW

Notes:
This option does not use the MS Excel application as OLE_server and is very quick.


Exporting Data as MS Excel Workbook (*.xls) Format:

Syntax:

GATEWAY EXPORT XLSW filename.xls SELECT clause OPTION COL_NAMES value |TAB_NAME value |STYLE value |SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.xls
This parameter defines the file name of target file with exported data as MS Excel Workbook. File extension must be xls.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  

Available Parameters: ON  
OFF  

TAB_NAME  
If defined, will be used as the label for the first tab on MS Excel Workbook.  

STYLE  
This option adds background color to exported data.  

Available Parameters: NORMAL  
PRICELIST  
MSMONEY  
BRICK  
DESERT  
EGGPLANT  
LILAC  
MAPLE  
MARINE  
ROSE  
SPRUCE  
WHEAT  
ZEBRA  
                           
BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT XLSW D:\TEMP\EMPLOYEE.XLS SELECT * FROM EMPLOYEE OPTION COL_NAMES ON |TAB_NAME EMPLOYEES |STYLE ZEBRA |SHOW_PROGRESS ON |ACTION OPENVIEW

Notes:
Use this option to export data as MS Excel Workbook file using the MS Excel application as OLE_server.

Export process using this type can take a lot of time with large record_sets. However, you have additional options; for example STYLE. If you don't need visual styles in the spreadsheet and want to export data only, you can use the XLS option, which generates the Excel spreadsheet very quickly.
 
When providing a file name to export to, you will be required to specify the complete path.


Exporting Data as MS Word Document (*.doc) Format:

Syntax:

GATEWAY EXPORT DOC filename.doc SELECT clause OPTION TITLE value |COL_NAMES value |SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.doc
This parameter defines the file name of target file with exported data as MS Word Document. File extension must be doc.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

TITLE  
If defined, will be the page header on each page of the document.  

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  

Available Parameters: ON  
OFF  

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT DOC D:\TEMP\EMPLOYEE.DOC SELECT * FROM EMPLOYEE OPTION TITLE Employee List |COL_NAMES ON |SHOW_PROGRESS ON |ACTION OPENVIEW

Notes:
This option uses MS Word application OLE_server to export data and create DOC file. To use this option, you need to have MS Word installed on your computer. Export process using this option can take a lot of time with large record_sets.

As a faster method we suggest that you use RTF option.


Exporting Data as Tab Separated Values (*.tab) Format:

Syntax:

GATEWAY EXPORT TAB filename.tab SELECT clause OPTION COL_NAMES value |QUALIFIER symbol |SEPARATOR symbol |REC_SEP value |SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.tab
This parameter defines the file name of target file with exported data as Tab Separated Values format. File extension must be tab.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  

Available Parameters: ON  
OFF  

QUALIFIER  
Changing the value of this option you can define any qualifier for fields in the target Tab Separated Values text file.  

The popular value is Quotes (") but you can define any custom character you wish.  
 
Use the word PIPE if you wish to use the pipe character as the qualifier.  

SEPARATOR  
Defines the separator of fields in target text file.  

The popular values are Semicolon (;), Comma (,), Space (#32), TAB (#9) but you can define any other character if you wish.  

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
REC_SEP  
Defines the separator between lines in the target text file.  

The popular value is CRLF (#13#10) or CR(#13) but you can define any other custom string.  

Available Parameters: CR  
LF  
CRLF  

SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT TAB D:\TEMP\EMPLOYEE.TAB SELECT * FROM EMPLOYEE OPTION COL_NAMES ON |QUALIFIER " |REC_SEP CRLF |SHOW_PROGRESS ON |ACTION OPENVIEW


Exporting Data as Symbolic Link (*.slk) Format:

Syntax:

GATEWAY EXPORT SLK filename.slk SELECT clause OPTION SHOW_PROGRESS value |MESSAGES value |ACTION action spec

filename.slk
This parameter defines the file name of target file with exported data as Symbolic Link format. File extension must be slk.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT SLK D:\TEMP\EMPLOYEE.SLK SELECT * FROM EMPLOYEE OPTION SHOW_PROGRESS ON |ACTION OPENVIEW


Exporting Data as Data Interchange (*.dif) Format:

Syntax:

GATEWAY EXPORT DIF filename.dif SELECT clause OPTION SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.dif
This parameter defines the file name of target file with exported data as Data Interchange Format. File extension must be dif.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT DIF D:\TEMP\EMPLOYEE.DIF SELECT * FROM EMPLOYEE OPTION SHOW_PROGRESS ON |ACTION OPENVIEW


Exporting Data as Lotus 1-2-3 (*.wk1) Format:

Syntax:

GATEWAY EXPORT WK1 filename.wk1 SELECT clause OPTION COL_NAMES value |SHOW_PROGRESS value |MESSAGES value |ACTION action spec

filename.wk1
This parameter defines the file name of target file with exported data as Lotus 1-2-3 Format. File extension must be wk1.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  

Available Parameters: ON  
OFF  

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT WK1 D:\TEMP\EMPLOYEE.WK1 SELECT * FROM EMPLOYEE OPTION COL_NAMES ON |SHOW_PROGRESS ON


Exporting Data as Quattro Pro (*.wq1) Format:

Syntax:

GATEWAY EXPORT WQ1 filename.wq1 SELECT clause OPTION COL_NAMES |SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.wq1
This parameter defines the file name of target file with exported data as Quattro Pro Format. File extension must be wq1.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  

Available Parameters: ON  
OFF  

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:
                  
GATEWAY EXPORT WQ1 D:\TEMP\EMPLOYEE.WQ1 SELECT * FROM EMPLOYEE OPTION COL_NAMES ON |SHOW_PROGRESS ON


Exporting Data as SQL Script (*.sql) Format:

Syntax:

GATEWAY EXPORT SQL filename.sql SELECT clause OPTION QUALIFIER symbol |SHOW_PROGRESS value |MESSAGES value |ACTION action

filename.sql
This parameter defines the file name of target file with exported data as SQL Script. File extension must be sql.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

   QUALIFIER
   Changing the value of this option you can define any qualifier for fields in the target SQL script file.
   The default value is single Quote (') but you can specify double Quotes (") if you wish.

Available Parameters: '  
              "
 
BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT SQL D:\TEMP\EMPLOYEE.SQL SELECT * FROM EMPLOYEE OPTION SHOW_PROGRESS ON

Notes:
Use this option to generate SQL script with dump of selected table data. Each record will include the INSERT INTO statements which you can execute in any SQL compliant database.


Exporting Data as XML (*.xml) Format:

Syntax:

GATEWAY EXPORT XML filename.xml SELECT clause OPTION SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.xml
This parameter defines the file name of target file with exported data as XML format. File extension must be xml.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT XML D:\TEMP\EMPLOYEE.XML SELECT * FROM EMPLOYEE OPTION SHOW_PROGRESS ON |ACTION OPENVIEW

NOTES:
Use this option to generate modern and universal XML format to exchange and transfer data between different sources. You can also view any data exported as XML format in MS Internet Explorer 5.0 (or higher) like a tree.


Exporting Data as MS Windows Clipboard Format:

Syntax:

GATEWAY EXPORT CLBR SELECT clause OPTION SHOW_PROGRESS value |MESSAGES value |ACTION value

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT CLBR SELECT * FROM EMPLOYEE OPTION SHOW_PROGRESS ON |ACTION OPENVIEW

Notes:
Use this option to generate exported data as MS Windows Clipboard Data.

ACTION OPENVIEW option will launch MS Clipbook Viewer. Then, you have to use Paste option to view all data.

Refer to MS Clipbook Viewer for more details and handling exported data.


Exporting Data as Rich Text (*.rtf) Format:

Syntax:

GATEWAY EXPORT RTF filename.rtf SELECT clause OPTION TITLE value |COL_NAMES value |SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.rtf
This parameter defines the file name of target file with exported data as Rich Text Format. File extension must be rtf.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.

OPTION

TITLE  
If defined, will be the page header on each page of the document.  

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  

Available Parameters: ON  
OFF  
 
BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process the some messages are available (with error messages, for example). Otherwise the export will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT RTF D:\TEMP\EMPLOYEE.RTF SELECT * FROM EMPLOYEE OPTION TITLE Employee List |COL_NAMES ON |SHOW_PROGRESS ON |ACTION OPENVIEW


Exporting Data as SPSS (*.sav) Format:

Syntax:

GATEWAY EXPORT SAV filename.sav SELECT clause OPTION SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.sav
This parameter defines the file name of target file with exported data as SPSS Format. File extension must be sav.

SELECT clause
Use the SELECT command to identify rows of data from a table or view.


Exporting Data as Adobe Acrobat Portable Document (*.pdf) Format:

Syntax:

GATEWAY EXPORT PDF filename.pdf SELECT clause OPTION COL_NAMES |SHOW_PROGRESS value |MESSAGES value |ACTION action spec

filename.pdf
This parameter defines the file name of target file with exported data as Adobe Acrobat Portable Document Format. File extension must be pdf.

OPTION

COL_NAMES  
If ON, will add a first row with column names. If OFF, will only export data.  

Available Parameters: ON  
OFF  

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.                 

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process the some messages are available (with error messages, for example). Otherwise the export will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT PDF D:\TEMP\EMPLOYEE.PDF SELECT * FROM EMPLOYEE OPTION COL_NAMES ON |SHOW_PROGRESS ON |ACTION OPENVIEW


Exporting Data as LDAP Data Interchange (*.ldif) Format:

Syntax:

GATEWAY EXPORT LDIF filename.dif SELECT clause OPTION SHOW_PROGRESS value |MESSAGES value |ACTION value

filename.dif
This parameter defines the file name of target file with exported data as LDAP Data Interchange Format. File extension must be dif.

OPTION

BLANK_IF_ZERO  
 
Available Parameters: ON  
OFF  
 
If ON, will export zero values as blank values. If OFF, will export zero values as zero values. The default is set to OFF.  
 
SHOW_PROGRESS  
Indicates whether to display status dialog during export process.  
 
Set SHOW_PROGRESS to ON if you wish to show an animated status dialog during the export process. Set SHOW_PROGRESS to OFF if you wish to export data without animated status dialog.  

Available Parameters: ON  
OFF  

MESSAGES  
If ON, during export process some messages will be displayed such as -ERROR- messages, if any. If OFF, the entire export process will be in "silent" mode.  

Available Parameters: ON  
OFF  

ACTION  
You can define the default action which will be processed after export is complete, for example, to open the target export file in view/edit mode or send this exported file by e_mail as attachment.  

Available Parameters: OPENVIEW  

Example:

GATEWAY EXPORT LDIF D:\TEMP\EMPLOYEE.DIF SELECT * FROM EMPLOYEE OPTION SHOW_PROGRESS ON |ACTION OPENVIEW