DB DATADIR

From Recital Documentation Wiki
Revision as of 14:25, 26 October 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Used to define a default data directory


See Also

COPY DATABASE, CREATE DATABASE, CREATE TABLE, Databases, dbexec, DISPLAY SCHEMAS, DROP DATABASE, DROP TABLE, GETENV(), LIST SCHEMAS, SET DATADIR, SET PATH, USE


Description

The DB_DATADIR environment variable is used to define the default data directory. Databases in Recital are implemented as directories containing files that correspond to the tables and associated files in the database. Operating System file protection can be applied individually to the files for added security. The directory is a sub-directory of the Recital data directory as set in DB_DATADIR. Databases are created using the SQL CREATE DATABASE command.


Example

// create_dat.prg
CREATE DATABASE hr;
USE hr;
// end of create_dat.prg
> ? getenv([DB_DATADIR])
/opt/recital/data
> do create_dat
> ? default()
/opt/recital/data/hr

Products

Recital, Recital Server