Recitalconvert
Contents
Purpose
The recitalconvert utility can be used to convert Xbase files into Recital format or upgrade older Recital tables to the latest format and Recital indexes to use SYNCNUM optimization.
Syntax
$ recitalconvert <filetype> [<filename>]
See Also
CONVERT, Optimizing Indexes using SYNCNUM, SET COMPATIBLE, SET FILETYPE, SYNCNUM
Description
The recitalconvert utility is run from the Operating System prompt to convert Xbase files into Recital format or upgrade older Recital tables to the latest format.
Xbase binary files must be converted into Recital format before they can be used, unless they are being accessed using the Replaceable Database Drivers. ASCII format files can be used without conversion, but the conversion will correct the line feed format of the file to that of the new host platform. The following files can be converted:
Xbase Files
| File Contents | File Extension | Renamed extension (OpenVMS) | Renamed extension (UNIX/Linux) | Converted file extension |
|---|---|---|---|---|
| table | dbf | old_dbf | o_dbf | dbf |
| program | prg | old_prg | o_prg | prg |
| format | fmt | old_fmt | o_fmt | fmt |
| memory | mem | old_mem | o_mem | mem |
| report | frm | old_frm | o_frm | frm |
| report | frx | old_frx | o_frx | frm |
| text | txt | old_txt | o_txt | txt |
<filetype>
The <filetype> parameter can be any of the following:
| File Type | Description |
|---|---|
| all | All convertible files in the current directory |
| dbf | Tables and Memos |
| fmt | Screen Format files |
| frx | FoxPro Report Format files |
| mem | Memory files |
| prg | Program files |
| txt | Text files |
| frm | Report Format files |
| year2000 | Pre-8.0 Recital Tables |
| ver90 | Pre-9.0 Recital tables |
| largefile | Pre large file support Recital tables |
| index | Populate the indexes of the specified table(s) with SYNCNUM |
<filename>
The optional <filename> can be used to specify a single file or a group of files that match a pattern.
$ recitalconvert dbf conv*.dbf
ALL
If the <filetype> is all, a ’config.db’ file will automatically be created in the current directory containing the following compatibility commands:
Products
Recital
For server products, please see the CONVERT command.
