Difference between revisions of "BUILD"

Revision as of 10:41, 4 June 2009

Class

Table Basics

Purpose

Exports bridge files, tables and their associated files in ASCII format to allow them to be transferred to a binary incompatible platform

Syntax

BUILD <filename> [INTO <directory>]

See Also

BACKUP DATABASE, COPY, COPY DICTIONARY, COPY STRUCTURE, COPY STRUCTURE EXTENDED, CREATE, CREATE BRIDGE, CREATE DICTIONARY, CREATE FROM, INSTALL, MODIFY STRUCTURE, SET CLIPPER, SET FILETYPE

Description

The BUILD command exports tables and their associated memo, dictionary and multiple index files into ASCII format to allow them to be transferred to a binary incompatible format. The import on the target machine requires the use of the INSTALL command.

<filename>

The <filename> is the name of a '.xaf' file. This is a text file in the following format, assuming the files data1.dbf and data2.dbf are the tables to be converted:

dbf,data1.dbf

dbf,data2.dbf

The dictionary, memo and multiple index file information is picked up automatically.

The BUILD command creates a single '.xat' file with information about all the files being exported. The '.xat' file has the same name as <filename> and is specified in the INSTALL command on the target machine. A '.xds' file is created for each table specified, containing the table structure information. A '.xmd' file is created for each table that has a memo file and a '.xdd' file for each table's data. These files contain the information required to rebuild the files on the target machine.

Recital Bridges can also be transferred. The name of the bridge file should be specified in the '.xaf' file, e.g.

brg,cisamdemo.dbf

Note: although the default extension for bridge files is '.brg', many bridge files are given a '.dbf' extension to allow them to be opened with the USE command by specifying the basename only. This is the case for the cisamdemo.dbf C-ISAM bridge file included in the Linux and UNIX distributions.

The matching '.str' file and the target data files are automatically picked up. For the cisamdemo.dbf bridge, this means that the following files are included:

cisamdemo.str

cisamdemo.dat

cisamdemo.idx

INTO <directory>

If the optional INTO <directory> clause is used, the export files will be created in the specified directory. If the directory does not exist, it will be created.

Example

On source machine demo.xaf contains the following lines:

dbf,customer.rdb
dbf,accounts.rdb
dbf,state.rdb
dbf,product.rdb
brg,cisamdemo.dbf

build demo into ./transfer

On target machine, once files have been transferred

install demo from ./transfer

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer