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.
Section links:
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.
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.
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.
Transaction Processing Errors lists runtime errors causing Rollback.
Memory Management Error Messages contains details of the error messages that are related to memory management issues.
Topic ID: 720068