Difference between revisions of "Recitalconvert"

From Recital Documentation Wiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 
==Purpose==
 
==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.
+
The ''recitalconvert'' utility can be used to convert Xbase files into Recital format or upgrade older Recital tables to the latest format.  
  
  
Line 8: Line 8:
  
 
==See Also==
 
==See Also==
[[CONVERT]], [[Optimizing Indexes using SYNCNUM]], [[SET COMPATIBLE]], [[SET FILETYPE]], [[SYNCNUM]]
+
[[CONVERT]], [[SET COMPATIBLE]], [[SET FILETYPE]]
  
  
Line 68: Line 68:
 
|largefile||Pre large file support Recital tables
 
|largefile||Pre large file support Recital tables
 
|-
 
|-
|index||Populate the indexes of the specified table(s) with [[SYNCNUM]]
 
 
|}
 
|}
  
Line 93: Line 92:
 
==Products==
 
==Products==
 
Recital
 
Recital
 +
 
For server products, please see the [[CONVERT]] command.
 
For server products, please see the [[CONVERT]] command.
  

Latest revision as of 11:10, 5 October 2010

Purpose

The recitalconvert utility can be used to convert Xbase files into Recital format or upgrade older Recital tables to the latest format.


Syntax

$ recitalconvert <filetype> [<filename>]


See Also

CONVERT, SET COMPATIBLE, SET FILETYPE


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


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