Difference between revisions of "Recitalconvert"

From Recital Documentation Wiki
Jump to: navigation, search
m (Dbconvert moved to Recitalconvert)
(No difference)

Revision as of 14:38, 16 December 2009

Class

Utilities


Purpose

The DBCONVERT 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

$ dbconvert <filetype> [<filename>]


See Also

CONVERT, Optimizing Indexes using SYNCNUM, SET COMPATIBLE, SET FILETYPE, SYNCNUM


Description

The dbconvert 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.


$ dbconvert 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 Terminal Developer For server products, please see the CONVERT command.