Specifies that you want to export an R:BASE table or view to an external file.
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 |
Paradox |
|
DBASE |
|
ASCII File, Delimiter Comma, Qualifier Double Quote |
|
ASCII File, Fixed Width |
|
HTML |
|
MS Excel Spreadsheet |
|
MS Excel Workbook |
|
MS Word |
|
ASCII File, Delimiter Tab, Qualifier None |
|
SYLK Symbolic Link |
|
DIF Data Interchange Format |
|
Lotus 1_2_3 |
|
QuattroPro |
|
SQL Script |
|
XML |
|
MS Windows Clipboard |
|
Rich Text Format |
|
SPSS Format |
|
Adobe Acrobat Portable Document Format |
|
LDAP Data Interchange Format |
|
JavaScript Object Notation |
|
OpenOffice Text Document |