Environment Guide |
Virtual Machine |
 |
|
Environment Guide |
Virtual Machine |
|
This guide contains information that is specific to particular environments. There is a section for each platform and file interface describing the special features of PROIV in that environment and detailing any special settings required. Also included are sections on file system utilities and alternate keys.
Logical Database Name Mapping, describes how to define a logical database name and how to use a logical name in a file definition.
C-ISAM File Interface, describes the differences in PROIV use that arise when creating and accessing C-ISAM files as opposed to PROISAM files.
Reality File Interface contains the environment variables to set at the operating system level, file considerations, features not supported, how to use transaction management facilities, and how to define indexes for PROIV keys
SQL Environments covers the main features of the PROIV interface. How to set up the PROIV Virtual Machine in the Windows operating environment. PROIV logic statements and a process control option that supports the SQL interface. Recommendations for improving the performance of PROIV SQL applications, Oracle and MySQL files and file variables, ODBC data source setup restrictions, and troubleshooting.
Unix Environments Variables contains the environment variables to set at the operating system level. A description of the PROIV file handling system, PROISAM settings, an explanation of how PROIV cleans up shared memory, a description of the procedural language interface, and troubleshooting the PROIV interface.
PROIV Transaction Processing describes automatic commit scheduling based on PROIV function structure, plus automatic rollback under defined error conditions, and logic statements for explicit commit and rollback control, the advantages of making transactions fully isolated from each other.
File System Utilities describes the four file dependent utilities, how to run the utilities in a GUI environment, using command line options to run the utilities, multi-tasking, and the PROISAM-specific utilities.
Alternate Keys discusses defining primary keys, duplicate keys, and alternate keys.
Memory-Based Files explains the Memory-Based Files functionality.
C-ISAM Error Codes lists standard error numbers that may be issued to system variable @ERR, and suggests remedial action; also lists error codes and associated messages, whose error numbers can be found in @SYSERR.
Reality Error Codes lists the standard errors and suggested action.
Transaction Processing Errors lists runtime errors causing Rollback.
PROIV Workspace Management explains how to manage the workspace with the PROMEMORY AND PROMEMORYDIR environment variables, and how to use PROIV Function Runtime Statistics Report to maximise memory usage.
PROIV HyperCaching explains the HyperCaching functionality and how to configure it with Environment Variables.
Topic ID: 720068