Property
|
Description
|
AllowSetManipulations
|
States whether manipulations are handled as set-oriented or not.
|
Application
|
Returns the name of the application
|
BatchLogLevel
|
Returns the current log level of batch jobs. Possible Values are: No Logging, Debug, Information, or Error.
|
ConceptualFile
|
Returns the name and location of the conceptual file that is in use, e.g.:
c:\progra~1\usd80\app\TRAVEL.con
|
Database
|
This is the name of the database, as used when communicating with the database.
|
DefaultDateFormat
|
Returns that date format that is used if no IO format is specified.
|
Encoding
|
Returns the text encoding used internally. Note that this includes text boxes like the SQL Command window.
|
EndUserMsgs
|
Returns Yes if the Rules Engine is running in end user mode, otherwise No.
|
Env
|
Returns the value of an environment variable. For example, to obtain the value of the TEMP environment variable:
SELECT RulesEngine.GetProperty('ENV TEMP')
|
ExternalEncoding
|
Returns the text encoding used when writing to an external file.
|
LockForeignKeys
|
States whether the parent record is locked when foreign keys are checked.
|
LockParentOnSeqno
|
States whether parent records are locked when child records are being entered.
|
MaxConstraintDepth
|
Returns the maximum number of recursions that may occur when constraints are checked.
|
MaxDriverConditions
|
States whether or not extra conditions are added to the main query.
|
NumberOfUpdateColumns
|
Returns the value of the "Number Of Update Columns" Deployment Configuration parameter.
|
OdbcDriver
|
Returns the full name of the current ODBC driver, e.g.:
USoft Remote Rules Services 8.0 (Unicode)
|
OsUserName
|
Returns the user name under which the Rules Engine process is running.
|
OsUserHomeDir
|
Returns the home folder of the user under which the Rules Engine process is running.
|
OsUserTempDir
|
Returns the temporary (temp) folder specified for the user under which the Rules Engine process is running.
|
Rdbms
|
Returns the RDBMS type. for example Oracle.
|
RdbmsName
|
Returns the full name of the RDBMS, e.g.:
SQL Server 2005
|
RdbmsVersion
|
Returns the version of the RDBMS, e.g.:
9.2.0.1.0
|
RecordFactsCacheSize
|
Returns the value of the RecordFactsCacheSize property, set as a deployment configuration setting in the USoft Authorizer.
|
RowsCommitted
|
This property returns the number of records committed during the last successful commit (as displayed in the commit message). The property is active until the next commit/rollback attempt. For example:
SELECT 'OK'
WHERE RulesEngine.GetProperty('RowsCommitted') = 1
|
ShowMiddlewareErrors
|
States whether Middleware errors are currently displayed.
|
ShowRDBMSErrors
|
States whether RDBMS errors are currently displayed.
|
SystemDir
|
Returns the System Directory: the folder under which this USoft instance is installed, e.g.:
c:\progra~1\usd80
|
TempTablesAtOwner
|
States whether temporary tables are currently created in the owner's schema.
|
TransactionMode
|
Returns either 'Immediate' or 'Batch', depending upon the transaction mode setting, e.g.:
SELECT RulesEngine.GetProperty('TransactionMode')
|
UniqueKeyCheck
|
States whether the Rules Engine performs unique key checks in the case of non-manual data entry.
|
UpdateSupertypeOnInsert
|
States whether inserting a subtype for an existing supertype is considered as an UPDATE on the whole constellation.
|
USoftLogDir
|
Returns the path to the USoft logging folder. All USoft log files are stored in this location by default.
|
USoftTempDir
|
Returns the path to the USoft temporary folder. All temporary files created and used by USoft are stored in this location.
|
Version
|
Returns the USoft version, e.g.:
8.0.2Q
|
WaitForLock
|
States the behavior of the application when lock statements are sent to the database. Possible values are: wait, nowait, or default.
|
