Reality Environment Variables

Before PROIV is run, a number of Environment Variables must be set at the operating system level to specify the Reality database to be used. These variables and their values, along with a description of their use, are included in following table:

Name

Values and Description

REALDBASE

database

On Unix, specify the database name.

On Microsoft Windows, specify the Connection Name referenced in the Connection section of the WinSni.ini configuration file. The Connection Name can be either of the following:

  • The host name specified in your TCP/IP hosts file, Domain Name Service or Network Information Service (depending on your TCP/IP configuration).

  • A local alias for the remote host.

Refer to the Reality WinSni Configuration Editor for details about your Connection Name.

REALUSER

user,password

Specifies the Reality user name and password. Reality code processes the data as two fields separated by a ','.

REALACC

account,password

Specifies the Reality account name and password. Reality code processes the data as two fields separated by a ','.

REALNODATE

Date

A PROIV date represented as a number.  Default is 999999.

REALNODATE

 

Allows PROIV to handle null date fields in Reality data files.

In Reality, a date field holding ‘0’ means 31/12/1967, and PROIV automatically translates this and displays the correct value.

However, a null date in Reality means that the date has not been set. PROIV cannot handle this and must be informed how to treat a null date. REALNODATE enables the mapping and whatever value is chosen appears as the PROIV date represented by that value, but that date is written back as a null to Reality.

If REALNODATE is set to ‘0’, this means PROIV treats it as the PROIV ‘0’ date -  31/12/1799, but this has the effect that 31/12/1799 cannot be written to a Reality date field. In this scenario, whatever value is selected must also be put into PROIV value variable &#@NODATE, which can then be used to detect empty date fields, rather than comparing to ‘0’.

REALTP

'Y', 'y', '1' enables the variable, any other value disables it.

Enables the commit and rollback features of the Reality database via PROIV. All PROIV transactions are atomic operations on the Reality database when set.

Comment on this topic

Topic ID: 720071