Configuration Files

Recital products can be configured using Environment Variables and Recital SET COMMANDS.

System-wide Configuration Files

The following configuration files are installed in the <path>/conf directory:

recital.conf

Environment variables that apply to all Recital products.

db.conf

Environment variables that apply to Recital Terminal Developer and supersede ones in recital.conf. If you are upgrading from an earlier version of Recital Terminal Developer which had custom settings in the profile.db file, these can be added here.

dbserver.conf

Environment variables that apply to the Recital Server (RDS/UAS) and supersede ones in recital.conf. If you are upgrading from an earlier version of the Recital Server which had custom settings in the profile.uas file, these can be added here.

config.db

SET COMMANDS that apply to all Recital products. To allow different settings for the Recital Server (ISSERVER() = .T.) and Recital Terminal Developer (ISSERVER() = .F.), separate them in the IF block:

if isserver()
...
else
...
endif

If you are upgrading from an earlier version of Recital Terminal Developer or the Recital Server which had custom settings in their respective config.db files, these can be added here.

compat.db

SET FILETYPE and SET COMPATIBLE settings that apply to all Recital products. Similarly these can have different values for the Recital Server and Recital Terminal Developer if an 'IF ISSERVER(); ELSE; ENDIF' block is used. This combines the previous unixdeveloper/compat.db and uas/compat.db files.

Local configuration files

config.db and profile.db

Recital Terminal Developer will also pick up the settings from files named config.db (SET COMMANDS) or profile.db (ENVIRONMENT VARIABLES) in the session/application start directory.

sysodbc.ini

These files contain logical view definitions and are created and modified by the SQL CREATE VIEW command.

A view is a logical table that allows you to access data from other tables. A view itself contains no data.

// SQL CREATE VIEW program
EXEC SQL
OPEN DATABASE southwind;
EXEC SQL
CREATE VIEW overten AS SELECT * FROM order_details WHERE unitprice > 10;
// END

When the view is created, the view definition is written into the sysodbc.ini file in the current directory or the current database if one is active. If no sysodbc.ini file currently exists, it will be created.

// Resulting sysobdc.ini contents in southwind database directory
[overten]
select=SELECT * FROM order_details WHERE unitprice > 10;
// END

The data extracted from the view is the data current at the time of the SELECT statement, not at the time of the view creation.

// Extract data program
EXEC SQL
OPEN DATABASE southwind;
EXEC SQL
SELECT productid, unitprice FROM overten;
// END

The DROP VIEW command removes the view definition from this file. The view will be available until the DROP VIEW command is issued or the sysodbc.ini file is manually modified using a text editor.

// SQL CREATE VIEW program
EXEC SQL
OPEN DATABASE southwind;
EXEC SQL
DROP VIEW overten;
// END