Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > G > GATEWAY

EXPORT

Scroll Prev Top Next More

Specifies that you want to export an R:BASE table or view to an external file.

 

GATEWAY_Export

 

Options

 

filename

Specifies the name of the file to export to.

 

OPTION

Specifies an additional parameter for the output. Options listed may vary based upon selected format. You must Use the pipe "|" symbol to separate OPTION parameters if more than one parameter is used.

 

•ACTION

•ACTIVE_INDEX

•ADD_UTF8_BOM

•BLANK_IF_NULL

•BLANK_IF_ZERO

•COL_NAMES

•DATASET_FIELD_ORDER

•DETECT_FORMULA

•EXTRA_SHEETS

•FOOTER_TEXT

•FORMAT

•HEADER_TEXT

•HTML_PATERN

•LAYOUT

•MESSAGES

•NAMED_NUM

•NAMED_TEXT

•NO_UNICODE_CONVERSION

•PASSWORD

•PASSWORD_TO_OPEN

•QUALIFIER

•RAW_GEN

•REC_SEP

•ROWS_PER_FILE

•SEPARATOR

•SHEET_INDEX

•SHEET_NAME

•SHOW_PROGRESS

•SPECIFICATION_FILE_NAME

•STRUCTURE

•STYLE

•TAB_NAME

•TABLE_NAME

•TITLE

•WRAP_TEXT

 

SELECT clause

Specifies and limits rows of data using the SELECT command.

 

type

Specifies one of the following codes for accepted file formats:

 

Code

Details

DB

Paradox

DBF

DBASE

CSV

ASCII File, Delimiter Comma, Qualifier Double Quote

FIX

ASCII File, Fixed Width

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

JSON

JavaScript Object Notation

ODT

OpenOffice Text Document