Table and index file creation in Xbase formats.
SET FILETYPE TO [RECITAL | DBASE3 | DBASE4 | DB4 | FOXBASE | FOXPRO | FOXPLUS | CLIPPER | VFP]
COPY, CREATE, DB_FOXPLUSBUGS, DB_FOXPROKEYS, DB_SAMBA, EDITFIELD(), FILETYPE(), INDEXEXT(), SET CLIPPER, SET CLIPPER5, SET COMPATIBLE, SET EDITFIELD, SET FILECASE, SET INDEXEXT, SET MEMOEXT, SET PCEDIT, SET PCEXACT, SET PCFILTER, SET PCGRAPHICS, SET PCKEYS, SET PCLOCKING, SET PCPICTURE, SET PCSAYS, SET PCUNIQUE
The SET FILETYPE command is used to specify a Replaceable Database Driver (RDD) to invoke when creating new database and index files. After issuing a SET FILETYPE command, all database, index and memo files created will be in the native Xbase format specified.
The Recital DBMS supports dynamic RDDs that allow transparent read/write access to database, memo and index files created in other Xbase languages. Access to these files is independent of the SET FILETYPE command.
Regardless of the file type used, the Recital Applications Data Dictionary (ADD) may still be used. When an Xbase database file is opened, the Recital RDD will look in the current directory for a file of the same name, but with a ’.dbd’ extension. If this file exists, it will be attached and all ADD attributes will be applied to the table.
The SET COMPATIBLE command has no effect on the format of files created in Recital products.
By default SET FILETYPE uses native Recital file formats.
- The dynamic RDDs are not available in Recital products for OpenVMS.
- Access to other Xbase file formats via the RDDs requires extra system resources, due to the binary conversions required to access the data. This can result in performance degradation, particularly on large database files.
use state.rdb set filetype to clipper copy to state_pc use state_pc index on STATE to state_pc close
Recital Server, Recital (None OpenVMS)