Contents
| Homepage |
|
| Release Information |
|
| Prerequisites |
|
| Restrictions |
|
| New Features in Reality |
|
| Fault Resolutions |
|
| Third Party Products |
|
| Reality on the Web |
|
| MultiValue Compatibility |
|
| Document Directory |
|
| Other Documents |
|
| How to use the Online Documentation |
|
| Web servers |
|
| Troubleshooting |
|
| General Conventions |
|
| Glossary |
|
| Installation Guides |
|
| Reality on UNIX |
|
| Overview |
|
| Product overview |
|
| How to use the contents of the ISO Image/DVD for installation |
|
| Prerequisites |
|
| Reality |
|
| UNIX-Connect |
|
| Online Documentation |
|
| Information You Must Supply |
|
| Set-up before Installation |
|
| General |
|
| Solaris Systems |
|
| AIX Systems |
|
| Linux Systems |
|
| Resilience Features |
|
| Installation |
|
| Overview |
|
| Preliminary |
|
| Loading the Reality software |
|
| Installing UNIX-Connect |
|
| Building the Reality executable |
|
| Installing the Online Documentation |
|
| Set-up after Installation |
|
| Installing the software keys |
|
| Running realstart |
|
| Creating a database |
|
| Configuring a database |
|
| Configuring resilience features |
|
| Making the new version live |
|
| Troubleshooting |
|
| Error Numbers |
|
| Example Messages |
|
| Upgrading from an Earlier Release |
|
| Software Upgrade |
|
| SYS-UPDATE |
|
| Changing Lower- to Upper-Case Dates |
|
| Upgrading FailSafe |
|
| Installing Database Overlays |
|
| Remote Tape Server |
|
| Running Multiple Versions of Reality |
|
| Troubleshooting |
|
| Installing Updates |
|
| Reality on Windows |
|
| Overview |
|
| Prerequisites |
|
| Hardware |
|
| Software |
|
| Memory |
|
| Online Documentation |
|
| Information You Must Supply |
|
| Set-up before Installation |
|
| Installation |
|
| Loading the Reality Software |
|
| Installing the Online Documentation |
|
| Set-up after Installation |
|
| Setting up a firewall |
|
| Creating a database |
|
| Configuring a database |
|
| Configuring resilience features |
|
| Troubleshooting |
|
| Upgrading from an Earlier Release |
|
| Software Upgrade |
|
| SYS-UPDATE Details |
|
| Changing Lower- to Upper-Case Dates |
|
| Upgrading FailSafe |
|
| Installing Database Overlays |
|
| Remote Tape Server |
|
| Running Multiple Versions of Reality |
|
| Installing an Update |
|
| netadmin Utility |
|
| Session Manager Options |
|
| Specifying Defaults |
|
| Reality External Components |
|
| Overview |
|
| Terms and Abbreviations |
|
| Product Overview |
|
| Contents of the Installation CD |
|
| Starting the Installation |
|
| Upgrading to a New Version |
|
| Removing the External Components |
|
| PCSNI |
|
| Prerequisites |
|
| Installation |
|
| Set-up After Installation |
|
| RealEdit |
|
| Prerequisites |
|
| Installing RealEdit |
|
| Set-up After Installation |
|
| JReal |
|
| Prerequisites |
|
| Installation |
|
| Set-up After Installation |
|
| RealSQL-ODBC Driver |
|
| Prerequisites |
|
| Installation |
|
| Set-up After Installation |
|
| RealSQL-JDBC Driver |
|
| Prerequisites |
|
| Installation |
|
| Set-up After Installation |
|
| RealWeb |
|
| Prerequisites |
|
| Information You Must Supply |
|
| Set-up Before Installation |
|
| Installation |
|
| Set-up After Installation |
|
| Upgrading to a New Version |
|
| Remote Tape Server |
|
| Prerequisites |
|
| Installing the Remote Tape Server |
|
| Upgrading to a New Version |
|
| Reality Web Services |
|
| Prerequisites |
|
| Set-up Before Installation |
|
| Installation |
|
| Set-up After Installation |
|
| Remote Basic ActiveX Control |
|
| Prerequisites |
|
| Installation |
|
| Set-up After Installation |
|
| Setting Environment Variables |
|
| Transferring a Database |
|
| Introduction |
|
| Procedure on the Source System |
|
| Source Database on Reality Host Platforms (UNIX or Windows) |
|
| Source Database on Series 18/19 Reality Proprietary Hardware |
|
| Procedure on the Destination System |
|
| Accessing an ISO/DVD Deliverable |
|
| User's Reference |
|
| General |
|
| General Conventions |
|
| New Features in Reality |
|
| Restrictions |
|
| Introduction to Reality |
|
| Overview |
|
| Multiple databases |
|
| Reality files on foreign databases |
|
| SQL-View |
|
| SQL Access |
|
| External interfaces |
|
| Multiple versions |
|
| Database types: partition and filestore |
|
| System configuration |
|
| Database management utilities |
|
| Operational facilities |
|
| Optional facilities |
|
| Entering and Operating in a Reality Database |
|
| Entering Reality on a UNIX host |
|
| Entering Reality on a Windows host |
|
| Reality user-id and account |
|
| Operating at TCL |
|
| Database Structure |
|
| File Structure |
|
| Two-level User File Structure |
|
| File-specifier |
|
| Dictionaries, Data Sections and Indexes |
|
| SYSTEM Dictionary |
|
| Master Dictionaries |
|
| File Dictionaries |
|
| Data Sections |
|
| Index Sections |
|
| Security |
|
| Database Security |
|
| Host System Security |
|
| Database Management Facilities |
|
| Terminal Control Language |
|
| English Retrieval Language |
|
| DataBasic Programming Language |
|
| Proc: The Stored Procedure Language |
|
| TCL Macros |
|
| Editors |
|
| Operating Facilities |
|
| Spooler |
|
| Save and Restore Utilities |
|
| Magnetic Tape Unit Operation Utilities |
|
| Terminal Independent Process Handler |
|
| File Triggers |
|
| Case Sensitivity |
|
| MultiValue Compatible Databases |
|
| Data Case-insensitivity |
|
| Keyword Case-insensitivity |
|
| Item-id Case-insensitivity |
|
| File and Item Structures |
|
| File Structure |
|
| Groups |
|
| Frame Size |
|
| Item Structure |
|
| Direct Item |
|
| Indirect Item |
|
| Character-oriented Item |
|
| Attributes |
|
| Values |
|
| Subvalues |
|
| Example of Character-oriented Item |
|
| Account Definition Item |
|
| Synonym Account Definition Item |
|
| Remote Account Definition Item |
|
| LOGON Item |
|
| File Definition Item |
|
| File Synonym Definition Item |
|
| Single Level Dictionary File |
|
| Remote File Synonym Definition Item |
|
| Implicitly Specified Remote System |
|
| Implicitly Specified Local System |
|
| Command Definition Items |
|
| Overview |
|
| TCL-I Command Definition Items |
|
| TCL-II Command Definition Items |
|
| English Command Definition Items |
|
| Cataloged DataBasic Program Definition Items |
|
| Proc Definition Items |
|
| TCL Macros |
|
| Command Synonym Definition Items |
|
| Connective, Modifier, and Relational Operators |
|
| Data Level Descriptor |
|
| Single Level Dictionary Files |
|
| Data Definition Item |
|
| Index Definition Item |
|
| Data Item |
|
| File and File Index Management |
|
| Introduction to File and File Index Management |
|
| Reality File Types |
|
| Creating a File |
|
| Deleting Files and Items |
|
| Copying an Item |
|
| Reformatting Data |
|
| Searching for an Item-id |
|
| Searching for a String |
|
| Listing Files in an Account |
|
| Listing/Sorting Items in a File |
|
| Moving and Renaming Files |
|
| File Hashing Statistics |
|
| Comparing Items |
|
| Managing Indexes |
|
| Optimising File Size (Partition Database only) |
|
| Creating Files |
|
| Indexing |
|
| Accessing Indexes |
|
| TCL Commands for Managing Indexing |
|
| Indexes in the Database File Structure |
|
| Sizing Files and Indexes |
|
| Files |
|
| Indexes |
|
| Automatic File Sizing |
|
| Creating an Automatically Sized File |
|
| Converting an Existing File to use Automatic File Sizing |
|
| Expanding and Contracting Manually |
|
| Other Automatic File Sizing Tasks |
|
| Manual Resizing |
|
| Changing the Modulo of a File |
|
| Using CREATE-FILE for Resizing |
|
| Using Reallocation Parameters |
|
| Dynamic Resizing (Partition Database Only) |
|
| Resizing System Files |
|
| Changing the Modulo of a Dictionary |
|
| Changing the Modulo of an Index |
|
| Selecting the Modulo for a File |
|
| Selecting the Modulo for an Index |
|
| Hyper Files |
|
| Example of Creating a Hyper File |
|
| TCL and General User Commands |
|
| Introduction to the Terminal Control Language |
|
| Command Definition Items |
|
| Synonym Command Definition Items |
|
| Further Information |
|
| TCL Input Processing |
|
| TCL-I Commands |
|
| TCL-II Commands |
|
| English Commands |
|
| Item-List-Generating Commands |
|
| Cataloged DataBasic Programs |
|
| TCL Macros |
|
| Procs |
|
| General Procedures |
|
| Use of the Return Key |
|
| Continuation Character |
|
| Typeahead |
|
| Screen Control |
|
| Editing Functions |
|
| TCL Stacker |
|
| Customising the Master Dictionary |
|
| Command Synonym Definition Items |
|
| Adding Commands |
|
| TCL Macros |
|
| Types of Macro |
|
| Creating Macros |
|
| Executing Macros |
|
| COMMENT Command |
|
| DISPLAY Command |
|
| PROMPT Command |
|
| REM Command |
|
| Command Reference |
|
| . (Dot - TCL Stacker Recall command) |
|
| ADDD |
|
| ADDX |
|
| AFS-CLEAR command |
|
| AFS-SET command |
|
| ALLOW-TANDEM |
|
| BLOCK-PRINT |
|
| BLOCK-TERM |
|
| BTX |
|
| CAPTURE |
|
| CASE |
|
| CHARGE-TO |
|
| CHARGES |
|
| CLEAR-FILE |
|
| CLEAR-MSG |
|
| CLEAR-OPTION |
|
| COMP |
|
| COMPARE |
|
| COPY |
|
| CP |
|
| CREATE-FILE |
|
| CREATE-INDEX |
|
| CT |
|
| DATAPRODUCTS |
|
| DATE-FORMAT |
|
| DEFINE-INDEX |
|
| DEL-LANG |
|
| DELETE |
|
| DELETE-FILE |
|
| DELETE-INDEX |
|
| DIR-VIEW |
|
| DIVD |
|
| DIVX |
|
| DLOG |
|
| DO |
|
| DTX |
|
| DV.SEARCH |
|
| EDITDBCONFIG |
|
| ENCRYPT-SET |
|
| FDB-CLEAR |
|
| FDB-SET |
|
| FDB-SHOW |
|
| FIELDREAD |
|
| FIND |
|
| GET-INDEX |
|
| HASH-TEST |
|
| HUSH |
|
| HYPER-ADD |
|
| HYPER-ADD-INDEX |
|
| HYPER-CREATE |
|
| HYPER-CREATE-INDEX |
|
| HYPER-EDIT |
|
| HYPER-LIST |
|
| HYPER-RECONCILE |
|
| HYPER-REMOVE |
|
| HYPER-REMOVE-INDEX |
|
| HYPER-VALIDATE |
|
| HYPER-VERIFY-INDEX |
|
| ICOUNT |
|
| IDATE-WINDOW |
|
| ISELECT |
|
| ISTAT |
|
| LIST4 |
|
| LISTDB |
|
| LISTDFILES |
|
| LISTF2/3/4 |
|
| LISTFILES |
|
| LIST-DBASE-INDEXES |
|
| LIST-INDEXES |
|
| LISTQFILES |
|
| LISTVERBS |
|
| LOAD-ALPHA |
|
| LOAD-COLL |
|
| LOAD-FR |
|
| LOAD-LANG |
|
| LOGTO |
|
| LOOP-ON |
|
| MAN |
|
| MESSAGE and MSG |
|
| MOVE |
|
| MOVE-FILE |
|
| MULD |
|
| MULX |
|
| NEWLISTVERBS |
|
| NOHUSH |
|
| OFF |
|
| P |
|
| PASSWORD |
|
| PD |
|
| PEEK |
|
| PFSEARCH |
|
| POKE |
|
| PRINT-ERR |
|
| PRINTRONIX |
|
| RCEDIT |
|
| RENAME-FILE |
|
| RESET-ALPHA |
|
| RSZ.AUTO |
|
| RUNOFF |
|
| SEARCH |
|
| SELECT-INDEX |
|
| SET80 and SET132 |
|
| SET-ALPHA |
|
| SET-COLL |
|
| SET-DEC |
|
| SET-ENVIRONMENT |
|
| SET-FILE |
|
| SET-LANG |
|
| SET-MONEY |
|
| SET-OPTION |
|
| SET-STACK |
|
| SET-THOUS |
|
| SHOW-MODULI |
|
| SLEEP |
|
| SORT2/3/4 |
|
| SQL-VIEW |
|
| SUBD |
|
| SUBX |
|
| SYS |
|
| TANDEM |
|
| TERM |
|
| TIME |
|
| TYPEAHEAD-OFF and ON |
|
| U2-CHANGE |
|
| U2-RBASIC |
|
| U2-SET |
|
| USER |
|
| U2-VIEW |
|
| VERIFY-INDEX |
|
| WHO |
|
| XDT |
|
| XTB |
|
| XTD |
|
| Decimal, Hexadecimal, and ASCII Table |
|
| About this Section |
|
| Contents |
|
| References |
|
| Conventions |
|
| Overview of Printing and the Spooler |
|
| Introducing the Spooler |
|
| Spooler Maintenance |
|
| Printer Control |
|
| Print Job Assignment (Print Reports) |
|
| Assignment Table |
|
| Print Jobs |
|
| Job-id |
|
| PRINT.JOB.CONTROL file |
|
| Job file |
|
| Putting Jobs on Hold |
|
| Formqueues |
|
| Creating a Formqueue |
|
| Public and Private Formqueues |
|
| Banners |
|
| Despoolers |
|
| Creating a Despooler Definition |
|
| Starting a Despooler |
|
| Multiple Despoolers and Formqueues |
|
| Checking for Despooler Errors |
|
| Monitoring Despoolers |
|
| Resolving Despooler Problems |
|
| Output Devices |
|
| System Printer |
|
| Private Printer |
|
| Reality Port |
|
| Network Printer |
|
| Tape Device |
|
| Despooling to a File |
|
| Printer Interface Scripts (UNIX Host Only) |
|
| Remote Spooling |
|
| Setting Up |
|
| Operation |
|
| Alternative to Remote Spooling |
|
| Network Printing |
|
| Printer Sharing |
|
| Printer Sharing using npu (UNIX only) |
|
| Printer Control Features |
|
| Printer Independence |
|
| Prologues and Epilogues |
|
| Procedure for Setting Up Printers |
|
| Using Printers |
|
| Windows |
|
| UNIX |
|
| Examples |
|
| Example of Setting Up Multiple Formqueues and Despoolers |
|
| Setting Up the Despoolers |
|
| Setting Up the Formqueues |
|
| Transaction Handling/Logging |
|
| Transaction Handling |
|
| Transaction Logging |
|
| General Spooler Procedures |
|
| BUILD.DESPOOLERS - Creating Port and Tape Despooler Records |
|
| BUILD.PRINTERS - Building Despoolers and Formqueues |
|
| DESPOOLER.DETAIL - Listing All Despoolers on a Database |
|
| DSPMON - Managing Despoolers |
|
| PORT-DESPOOL - Despooling Print Jobs to a Port |
|
| RESET.DESPOOLER - Resetting the Despooler System |
|
| SP-ASSIGN - Assigning Print Report Characteristics |
|
| SP-CLOSE - Closing A Print Job |
|
| SP-COPY - Copying Print Jobs to Another Job File |
|
| SP-DESC - Entering/Displaying a Print Job Description |
|
| SP-EJECT - Ejecting Blank Pages from a Printer |
|
| SP-FIX - Cleaning Up Print Jobs After a Program Crash |
|
| SP-FORMQUEUE - Listing All Print Jobs in a Formqueue |
|
| SP-LOOK - Displaying the Current Spooler Assignment |
|
| SP-TAPEOUT- Transferring Print Jobs from Tape to a Formqueue |
|
| SP-STATUS and Related Procedures |
|
| SP-STATUS |
|
| Action Code 1 Create Queue and SP-CREATE |
|
| SP-CREATE with RealityX 3.1 Syntax |
|
| Action Codes 2 and 3 (SP-FORM and SP-TYPE) |
|
| Action Code 4 Change Device and SP-DEVICE |
|
| SP-DEVICE with RealityX 3.1 Syntax |
|
| Action Code 5 Change Page Skip and SP-SKIP |
|
| Action Code 6 List Print Jobs and SP-JOBS |
|
| Action Code 7 Delete Queue and SP-FQDELETE |
|
| Action Code 8 Change Translation and SP-TRANSLATE |
|
| Action Code 9 Start Despooler and START-DESPOOLER |
|
| Action Code 10 Stop Despooler and STOP-DESPOOLER |
|
| Action Code 11 Toggle FQ/ sys q's |
|
| Action Code 12 Despooler List and SP-DESPOOLERS |
|
| SP-JOBS and Related Procedures |
|
| SP-JOBS |
|
| Action Code 1 Switch All Jobs and SP-MOVEQ |
|
| Action Code 2 Switch One Job and SP-SWITCH |
|
| Action Code 3 Change Options and SP-OPTS |
|
| Action Code 4 Change #Copies and SP-COPIES |
|
| Action Code 5 Delete Job and SP-DELETE |
|
| Action Code 6 Stop Printing and SP-STOP |
|
| Action Code 7 Resume Printing and SP-RESUME |
|
| Action Code 8 Edit Print Job and SP-EDIT |
|
| Action Code 9 Suspend Printing and SP-SUSPEND |
|
| Action Code 10 Top Priority and SP-PRIORITY |
|
| Action Code 11 SP-STATUS and SP-STATUS |
|
| Action Code 12 Kill Printing and SP-KILL |
|
| Action Code 13 Align Printer and SP-ALIGN |
|
| Action Code 14 Clear Queue and SP-CLEAR |
|
| Action Code 15 FQ/System Jobs |
|
| Action Code 16 Display Detail and SP-DETAIL |
|
| Action Code 17 Reset Selection |
|
| Action Code 18 Change Job File |
|
| Action Code 19 Re-queue Hold File and SP-QUEUEHOLD |
|
| SP-SUMMARY and Related Procedures |
|
| SP-SUMMARY |
|
| Action Code 1 Switch View |
|
| Action Code 2 SP-STATUS and SPSTATUS |
|
| Action Code 3 SP-JOBS and SP-JOBS |
|
| Action Code 4 Reset Selection |
|
| Spooling System Maintenance |
|
| SPM Command: Spooler Maintenance |
|
| FORM.QUEUES File Maintenance |
|
| FORM.QUEUES File Maintenance Menu (FQM) |
|
| Option 1 - Queue Type |
|
| Option 2 - Page Skip |
|
| Option 3 - Print Banner |
|
| Option 4 - Tape Block Size |
|
| Option 5 - Tape Density |
|
| Option 6 - Tape Label Type |
|
| Option 7 - Printer Page Width |
|
| Option 8 - Printer Page Length |
|
| Option 9 - Number of Lines to Skip at Top of Page |
|
| Option 10 - Default Job File |
|
| Option 11 - Formqueue Description |
|
| Option 12 - Prologue Item-id |
|
| Option 13 - Epilogue Item-id |
|
| Option 14 - Control Program |
|
| Option 15 - Private Queue Reference |
|
| Option 16 - Assigned Despoolers |
|
| DESPOOLER.CONTROL File Maintenance |
|
| Despooler Maintenance Menu |
|
| Option 1 - Device Type |
|
| Option 2 - Device Name |
|
| Option 3 - Printer Independence Item-id |
|
| Option 4 - Translation Table Number |
|
| Option 5 - Prologue Item-id |
|
| Option 6 - Device Description |
|
| Option 7 - Device Location |
|
| Option 8 - Assigned Formqueues |
|
| Option 9 - Permanent or Shared |
|
| Option 10 - Printer Hold Time |
|
| Option 11 - Despooler Sleep Time |
|
| PRINTER COMMAND STRING Maintenance |
|
| PCS Maintenance Menu |
|
| Creating a PCS |
|
| Option 1 - Building a PCS Using the Editor |
|
| Option 2 - Building a PCS Using the Screen Editor |
|
| Option 3 - Processing the PCS Source Definition |
|
| Option 4 - Producing the PCS Output |
|
| Status Conditions and Values |
|
| Status Conditions |
|
| Status Values in Numeric Order |
|
| SPOOL.JOBS Dictionary Items |
|
| List of Dictionary Items |
|
| Spooler File Formats |
|
| PRINT.JOB.CONTROL File |
|
| FORM.QUEUES File |
|
| DESPOOLER.CONTROL File |
|
| Checking for Spooler Errors |
|
| Save and Restore |
|
| Overview of Save and Restore |
|
| Logical Saves |
|
| Physical Saves |
|
| tlmenu |
|
| Restore Procedures |
|
| Restoring a Database |
|
| Restoring Accounts |
|
| Restoring Files and Items |
|
| Restoring Files onto a Foreign Database |
|
| Notes on Save and Restore |
|
| Reality Files on Foreign Databases |
|
| Excluding Accounts/Files from Backup |
|
| Transferring Data between Different Versions of Reality |
|
| Error Messages |
|
| ACCOUNT-SAVE |
|
| FILE-SAVE |
|
| F-S |
|
| IMG.SAVE |
|
| IMG.VERIFY |
|
| M-A-S |
|
| realdump |
|
| SAVE |
|
| SAVE-IMAGE |
|
| VERIFY-IMAGE |
|
| VERIFY-SAVE |
|
| OLD-SAVE Commands |
|
| OLD-ACCOUNT-SAVE |
|
| OLD-FILE-SAVE |
|
| OLD-SAVE |
|
| ACCOUNT-RESTORE |
|
| IMG.LOAD |
|
| LOAD-IMAGE |
|
| MOUNT-IMAGE |
|
| M-A-R |
|
| realload |
|
| SEL-RESTORE |
|
| Multideck Save/Restore Utility (dbsave) |
|
| Purpose |
|
| Syntax |
|
| Options |
|
| Restrictions |
|
| Files |
|
| Main Menu |
|
| Multideck Calibration |
|
| Calibrate System |
|
| Calibrate Account |
|
| Multideck System Save |
|
| Multideck System Restore |
|
| Configuration File |
|
| Example |
|
| Tape Operation and Commands |
|
| Summary of Tape Unit Commands by Category |
|
| Overview of Tape Operations |
|
| Precautions When Using Tape |
|
| Attaching a Tape Unit |
|
| Tape Unit Numbers |
|
| Data Channels |
|
| Detaching a Tape Unit |
|
| Multiple Tape Units |
|
| Sequencing of Tape Units |
|
| Error Messages |
|
| Remote Tape |
|
| Tape Images |
|
| Data Encryption |
|
| Record Size |
|
| Tape Labels |
|
| Paper Label Details |
|
| Data Label Formats |
|
| Label Suppression |
|
| ASSIGN |
|
| CHECK |
|
| CLEAR-ASSIGN |
|
| DISCTOTAPE |
|
| SPACE |
|
| TAPETODISC |
|
| T-ATT |
|
| T-BCK |
|
| T-CHK |
|
| T-COPY |
|
| T-DET |
|
| T-DEVICE |
|
| T-DUMP and ST-DUMP |
|
| T-ERASE |
|
| T-FWD |
|
| T-LOAD |
|
| T-RDLBL |
|
| T-READ |
|
| T-RETENSION |
|
| T-REW |
|
| T-STACKER |
|
| T-STATUS |
|
| T-UNLOAD |
|
| T-VERIFY |
|
| T-WEOF |
|
| Using TIPH |
|
| Introduction |
|
| TIPH Output |
|
| TIPH Input |
|
| PH-HISTORY File |
|
| PH-ALLOCATE |
|
| PH-DELETE |
|
| PH-KILL |
|
| PH-LINES |
|
| PH-MONITOR |
|
| PH-START |
|
| PH-STATUS |
|
| About this Section |
|
| Contents |
|
| References |
|
| Conventions |
|
| An Overview of Reality Administration |
|
| Introduction |
|
| Types of Database |
|
| Administration in the Host System Environment |
|
| Administration in Reality |
|
| Introduction to the Reality Environment |
|
| System Accounts |
|
| SYSMAN Account |
|
| SYSPROG Account |
|
| SYSFILES Account |
|
| ACC file |
|
| BASIC-DUMPS File |
|
| BLOCK-CONVERT File |
|
| ERRMSG File |
|
| FEATURES File |
|
| NEWAC File |
|
| PH-HISTORY File |
|
| POINTER-FILE |
|
| PROCLIB File |
|
| SERVICE-LOG File |
|
| TCL.LOG File |
|
| USER.LOG File |
|
| GLOBAL.MD Account |
|
| BASIC.CONVERSION Account |
|
| DENAT Account |
|
| Training Accounts |
|
| Licences |
|
| User Licences |
|
| Optional Features |
|
| Installing Software Keys |
|
| Reserved Licences |
|
| Database Configuration |
|
| Licence Expiry |
|
| Administration from Reality |
|
| Securing the Database by using SSM and GSSM |
|
| Introduction |
|
| Network profiles |
|
| User profiles |
|
| Security profiles |
|
| Environments |
|
| Data encryption |
|
| Password definitions |
|
| User-based Security |
|
| User profile |
|
| User passwords |
|
| Security profile |
|
| Assignment of security profiles to user profiles |
|
| Location-based Security |
|
| Physical Location Identifier (PLId) |
|
| Network Profile |
|
| PLId Formats |
|
| Partial PLId |
|
| Consistent Circuit Identifier (CCI) |
|
| Using the SSM Command |
|
| SSM Option 1 - Define Network Profiles |
|
| SSM Option 2 - Define User Profiles |
|
| SSM Option 3 - Define Security Profiles |
|
| SSM Option 4 - Define Environment Settings |
|
| Environment Settings |
|
| SSM Option 5 - Encryption Key Maintenance |
|
| SSM Option 6 - Define Password Definitions |
|
| Using the GSSM Command |
|
| Setting up Security for External Access |
|
| RealWeb |
|
| Web Services |
|
| RealEdit |
|
| SQL for Reality |
|
| Securing the Security System |
|
| Overview |
|
| SYSMAN Account |
|
| SYSTEM File |
|
| System Debugger |
|
| Database Account Management |
|
| Introduction to Accounts |
|
| What is an Account? |
|
| What are Accounts for? |
|
| What Happens at Logon? |
|
| User-ids, Locations and Accounts |
|
| The Account Master Dictionary and Command Definition Items |
|
| POINTER-FILE |
|
| Other Items in MD |
|
| File Lock Codes |
|
| Access to Files |
|
| English Definition Items and Command Synonyms |
|
| Creating Accounts |
|
| Deleting Accounts |
|
| Renaming Accounts |
|
| More Information |
|
| Retrieval and Update Lock Codes and Keys |
|
| Entering Lock Codes and Keys |
|
| Account and User Locks and Keys |
|
| File Locks |
|
| Code Comparison |
|
| Lock and Key |
|
| Sample Update and Retrieval Lock Codes |
|
| Logon Processor |
|
| Logon Prompt |
|
| First Logon Message: 'LOGON' in ERRMSG |
|
| Welcome Message: '335' in ERRMSG |
|
| Editing Logon Prompt and Message |
|
| Logon Control Programs |
|
| User Logon Program |
|
| Global Logon Program |
|
| Account Logon Program |
|
| TCL-inhibit Program |
|
| Controlling Logons |
|
| Monitoring Database Users |
|
| Locks and the Locking Systems |
|
| Read/update Locks (Group Locks) |
|
| Item Locks |
|
| Item Deadlock Detection |
|
| Execution Locks |
|
| Monitoring and Maintaining Locks |
|
| Data Encryption |
|
| Configuring Reality to use Data Encryption |
|
| Encryption Keys |
|
| Encrypted Files |
|
| Giving Users Access to Encrypted Files |
|
| Copying Encrypted Data to another Host |
|
| Notes |
|
| File Triggers |
|
| How to Associate a Trigger with a File |
|
| Commands that might run Triggers |
|
| File Statistics Reports |
|
| Contents of the Report |
|
| STAT-FILE File |
|
| Group Format Errors |
|
| Reporting System Usage |
|
| USER.LOG |
|
| Account Statistics |
|
| Command Logging |
|
| Maintaining ACC File |
|
| Determining Free Space Availability |
|
| Improving Database Efficiency |
|
| Database Setup |
|
| Create/Update Proc |
|
| Database Start-up Proc |
|
| Miscellaneous Commands |
|
| %FULL |
|
| AFS-CONTRACT |
|
| AFS-ENABLE |
|
| AFS-EXPAND |
|
| AFS-HOLD |
|
| AFS-SELECT |
|
| AFS-TRIM |
|
| ACCOUNT-FILE-STATS |
|
| ALL-FILE-STATS |
|
| ANALYZE |
|
| BREAK |
|
| BREAK-KEY-OFF |
|
| BREAK-KEY-ON |
|
| CLAIM |
|
| CLEAR-BASIC-LOCKS |
|
| CLEAR-ITEM-LOCKS |
|
| CONVERT-FILE |
|
| CREATE-ACCOUNT |
|
| Creating a local account |
|
| Creating a remote account |
|
| Creating a synonym account |
|
| CREATE-TRIGGER |
|
| CSV-COPY |
|
| CUSTOMER.IDENT |
|
| DBUPDATE |
|
| DEFINE-ENVIRONMENT |
|
| DELETE-ACCOUNT |
|
| DELETE-TRIGGER |
|
| ENABLE |
|
| ENABLE-LOGONS |
|
| EVFU-SETUP |
|
| INHIBIT-LOGONS |
|
| LIST-ALL-TRIGGERS |
|
| LIST-EXECUTION-LOCKS |
|
| LIST FEATURES |
|
| LIST-FILE-STATS |
|
| LIST-GROUP-LOCKS |
|
| LIST-ITEM-LOCKS |
|
| LIST-LOCKS |
|
| LISTPF |
|
| LISTPROCS |
|
| LIST-$STAT-FILE* |
|
| LIST-TRIGGERS |
|
| LISTU |
|
| LISTU.SUMMARY |
|
| LOAD-REK |
|
| LOGOFF |
|
| LOGOFF-ALL |
|
| LOGON |
|
| MAKE-SPECIAL |
|
| CSV view |
|
| ENV view |
|
| FILE view |
|
| GFB and LFB views |
|
| ILOCKS view |
|
| INDEX views |
|
| LICENCE view |
|
| NET-LOGON |
|
| OPTIMUM-FRAME-SIZE |
|
| OPTIMUM-MODULO |
|
| POVF |
|
| RESIZE-FILE |
|
| SAVE-REK |
|
| SET-ADMIN-KEY |
|
| SET-PRIORITY |
|
| SET-PRIV |
|
| SETUP-ACCOUNT |
|
| SHOW-ITEM-LOCKS |
|
| SHUTDOWN |
|
| SIZE-MONITOR |
|
| SLS |
|
| START-AUDIT-LOG |
|
| START-SUPPORT-LOG |
|
| STOP-AUDIT-LOG |
|
| STOP-SUPPORT-LOG |
|
| SYSINFO |
|
| SYS-UPDATE |
|
| TIDYPF |
|
| UPDATE-ACCOUNT |
|
| UPDATE-ALL-ACCOUNTS |
|
| UPDATE-SERVICE-LOG |
|
| VERIFY-SYSTEM |
|
| WHAT |
|
| WHERE |
|
| Reality on the Host |
|
| Reality in the Host Environment |
|
| Overview |
|
| Differences between UNIX and Windows |
|
| Reality Software |
|
| The realman Directory |
|
| Defining the Live Version |
|
| Reality Executables Directory |
|
| Database Structure |
|
| DataBase Types |
|
| Database Directory |
|
| Reality/Host Integration |
|
| System Security |
|
| Administration from the Host |
|
| Starting and Stopping Reality |
|
| Automatic Startup |
|
| Manual Startup |
|
| Automatic Shutdown |
|
| Manual Shutdown |
|
| Creating and Removing a Database |
|
| Creating a Database |
|
| Enlarging a Database |
|
| Removing a Database |
|
| Locking and Unlocking a Database |
|
| Locking a Database |
|
| Unlocking a Database |
|
| Improving Database Efficiency |
|
| Monitoring File Size |
|
| Dynamic Resizing of Files |
|
| Resizing System Files |
|
| Checking a Database for Errors |
|
| Checking the Database Automatically at Startup |
|
| Database Setup |
|
| Host Utilities |
|
| chkdev |
|
| install_fix |
|
| Install_Key |
|
| installkeys |
|
| Install_rt |
|
| Install_SN |
|
| killreal |
|
| lockdbase |
|
| mkdbase |
|
| mkdbase Menu Interface |
|
| mkdbase Command Line Interface |
|
| realfstab File |
|
| perror |
|
| realdbck |
|
| reality |
|
| realresize |
|
| realrts |
|
| realserv |
|
| realstart |
|
| realusers |
|
| rmdbase |
|
| show_key |
|
| sizemon |
|
| unlockdbase |
|
| Reality Configuration on the Host |
|
| User-Ids |
|
| Starting Reality Automatically |
|
| Password Integration (UNIX only) |
|
| Environment Variables - UNIX |
|
| Reality Version |
|
| Database, User-id and Account |
|
| Environment Variables - Windows |
|
| Database Configuration Parameters |
|
| AllowLogonPlease |
|
| AutoFileSize |
|
| ClearTempDir |
|
| CompressTapeImage |
|
| DataCaseControl |
|
| DateFormat |
|
| DbStart |
|
| DefaultSystemPrinterType |
|
| DeferCloseMax |
|
| DeferCloseLevel |
|
| ForceFreeSpaceUpd |
|
| ForcePasswordCheck |
|
| FrameSize |
|
| FSCheckpointPath |
|
| HashType |
|
| IDateWindow |
|
| IIDCaseControl |
|
| ItemLockTimeOut |
|
| ListAllItemLocks |
|
| MaxPortNum |
|
| NumConnections |
|
| NumDataSects |
|
| NumIndexSects |
|
| NumItemLocks |
|
| NumPseudoPorts |
|
| PasswordLength |
|
| PlidByPeer |
|
| PortRange |
|
| RealDbCk |
|
| RealIdleDespoolerSleep |
|
| ShareModulo |
|
| ShareSize |
|
| shmsz |
|
| SkipLogonProc |
|
| SuppressPasswordLogging |
|
| TempDir |
|
| Tape Definitions |
|
| Remote Tape Device Definitions |
|
| Data Encryption |
|
| Tape Images |
|
| Typical Configuration |
|
| Examples |
|
| Daemon Log Rotation |
|
| SYS Security Files |
|
| PLId to Port Mapping |
|
| Setting Up the Devices File |
|
| PLId and Port Specifications |
|
| Keywords |
|
| Examples |
|
| Checking the Devices File for Errors |
|
| Reserved Licences |
|
| Setting Up the Number of Reserved Licences |
|
| Setting Up Privileged Ports |
|
| Reality Break Character |
|
| Setting Up and Releasing Reality Private Printers (UNIX only) |
|
| Converting to a Private Printer |
|
| Setting Up Printer Security |
|
| Starting the Printer |
|
| Restoring a System Printer |
|
| Allocating TIPH Ports (UNIX only) |
|
| Backup and Recovery on the Host |
|
| Introduction |
|
| UNIX Back-up and Recovery Utilities |
|
| Databases Based on Host Files |
|
| Partition Databases using Multiple Partitions |
|
| Backup Procedures |
|
| Recovery Procedures |
|
| Networking |
|
| Routing Information |
|
| Network Security Features |
|
| Setting-up Remote Logon |
|
| Setting-up Remote File Access |
|
| Setting-up Interprocess Communication |
|
| Setting-up Network Printing |
|
| Setting-up Network Logon |
|
| Location-Based Security |
|
| Log Files |
|
| Network Error Messages |
|
| Windows Network Administration Utility |
|
| Destination Hosts |
|
| Alternative Hosts |
|
| Listening Entries |
|
| Remote Databases |
|
| Local Databases |
|
| Session Manager Options |
|
| Setting up Defaults |
|
| System Alerts |
|
| Configuring System Alerts |
|
| Raising System Alerts |
|
| realevent |
|
| ALERT command |
|
| Database Isolation |
|
| Creating instances |
|
| Deleting instances |
|
| Updating the instance software |
|
| Administering a Reality instance |
|
| realbind |
|
| realclone |
|
| realroot |
|
| Dealing with System Problems |
|
| General Guidelines |
|
| Training Users to Report Problems |
|
| Common User Problems and Solutions |
|
| Abnormal Termination |
|
| Need to Add Space to an Existing Database |
|
| Terminal Related Problems |
|
| Incorrect Terminal Operation (UNIX) |
|
| No Keystroke Echo |
|
| Keyboard Inoperative |
|
| Terminal Inoperative |
|
| Tape Errors |
|
| Parity Errors on Tape |
|
| Cannot Attach to Tape Image Device |
|
| Terminal/PC Locked |
|
| Permission Denied Message (UNIX Only) |
|
| Unable to Logon |
|
| Unable to Start Reality |
|
| Ethernet Problems on a UNIX Host |
|
| Hashes Returned when Reading from a File |
|
| Proc or TCL Macro Fails |
|
| Documentation Problems |
|
| Networking Problems |
|
| Problems following Solaris Upgrade |
|
| Serious Problems |
|
| Serial Numbers |
|
| Problems with One Terminal |
|
| Reality on Windows Fails to Start |
|
| Aborts and Core Dumps |
|
| Log Files |
|
| Error Numbers |
|
| Example Messages |
|
| System Debugger |
|
| MultiValue Compatibility |
|
| File Modifiers |
|
| Tape Images (Pseudo-floppy) |
|
| FLOPPYTOTAPE |
|
| TAPETOFLOPPY |
|
| SP-ASSIGN |
|
| ACCOUNT-RESTORE |
|
| VERIFY-SAVE |
|
| MIGRATE.ACCOUNT |
|
| TCL Commands Listed by Category |
|
| English Reference |
|
| Contents |
|
| Introducing English |
|
| English Sentences |
|
| Dictionaries and Data Definition Items |
|
| Terminology Changes |
|
| Data Definition Item |
|
| Attribute 8 Codes |
|
| Attribute 7 Codes |
|
| File Specifier/Dynamic Q-pointer |
|
| Values and Value Strings |
|
| References |
|
| Conventions |
|
| Introduction to English |
|
| Overview |
|
| The Inquiry Language |
|
| The Dictionary |
|
| Summary of English Features |
|
| The English Sentence |
|
| Sentence Structure |
|
| Optional Clauses |
|
| Outline Syntax |
|
| Syntax Elements |
|
| Macros |
|
| USING Clause |
|
| Options |
|
| Print Limiters |
|
| Example of an English Sentence |
|
| General Rules for English Sentences |
|
| Entering a Sentence |
|
| Line Continuation |
|
| Action by the System |
|
| Generating English Reports |
|
| Reserved Words and Symbols |
|
| English Commands |
|
| Frequently Used Commands |
|
| Other Commands |
|
| Modifying Files |
|
| Generating Implicit Lists |
|
| File Specifiers and Modifiers |
|
| File Specifiers |
|
| File Modifiers |
|
| Syntax |
|
| Syntax Elements |
|
| Default to Master Dictionary |
|
| Example |
|
| Item Lists |
|
| Types of Item List |
|
| Explicit Item-id List |
|
| Implicit Item-id List |
|
| Item-id Selection Clause |
|
| Value Strings |
|
| Relational Operators |
|
| Logical Connectives |
|
| BETWEEN Connective |
|
| Examples |
|
| Selection Criteria |
|
| Sort Criteria |
|
| Single Value Sort Connectives |
|
| Multivalue Sort Connectives |
|
| Subvalue Sort Connectives |
|
| Default Sort Order |
|
| Sort Order of Left-aligned Data |
|
| Sort Order of Right-aligned Data |
|
| Multiple Key Sort |
|
| Sorting Single Valued Attributes |
|
| Sorting Multivalued Attributes |
|
| Sorting Subvalued Attributes |
|
| Output Specification |
|
| TOTAL, MIN and MAX Connectives |
|
| BREAK-ON Connective |
|
| Controlling and Dependent Attributes |
|
| Format Specification |
|
| HEADING and FOOTING Modifiers |
|
| GRAND-TOTAL Modifier |
|
| Combining TOTAL, GRAND-TOTAL, and BREAK-ON |
|
| Subtotals and Cumulative Total with DET-SUPP |
|
| USING Clause |
|
| Options for Commands |
|
| Throwaway Connectives |
|
| Indexing |
|
| Using SELECT-INDEX and ISELECT |
|
| Implicit Use of Indexes by English |
|
| Rules for Implicit Use of an Index |
|
| Examples of Implicit Use of Indexes |
|
| English Commands |
|
| BSELECT, BSSELECT |
|
| CHECK-SUM |
|
| COUNT |
|
| EDELETE |
|
| EESEARCH |
|
| ESEARCH |
|
| GENML, SGENML |
|
| I-DUMP |
|
| LIST |
|
| LISTCONN |
|
| LISTDICTS |
|
| LIST-ITEM |
|
| LIST-LABEL |
|
| LIST-SPREAD |
|
| LIST-TABLE |
|
| REFORMAT |
|
| S-DUMP |
|
| SELECT |
|
| SORT |
|
| SORT-ITEM |
|
| SORT-LABEL |
|
| SORT-SPREAD |
|
| SORT-TABLE |
|
| SSELECT |
|
| STAT |
|
| SUM |
|
| List Processing Commands |
|
| Introduction |
|
| Overview |
|
| List Generating Commands |
|
| List Processing Commands |
|
| Types of List |
|
| Active List |
|
| Saved List in POINTER-FILE |
|
| Default List (List with No Name) |
|
| Examples |
|
| AND-ITEMS |
|
| AND-LISTS |
|
| CLEAR-LIST |
|
| COPY-LIST |
|
| DELETE-LIST |
|
| EDIT-LIST |
|
| FORM-LIST |
|
| GET-LIST |
|
| NEW-GET-LIST |
|
| NEW-SAVE-LIST |
|
| NEW-SORT-LIST |
|
| NSELECT |
|
| OR-ITEMS |
|
| OR-LISTS |
|
| QSELECT |
|
| SAVE-LIST |
|
| SORT-LIST |
|
| XOR-ITEMS |
|
| XOR-LISTS |
|
| XSELECT |
|
| File and Data Definition Items |
|
| Database File Hierarchy |
|
| Creating a File |
|
| General Procedure |
|
| Creating a Data Section |
|
| Examples |
|
| File Definition Item |
|
| Sublists - V Code |
|
| Data Definition Item |
|
| Column Headings |
|
| S D/CODE |
|
| Default Output Specification |
|
| X D/CODE |
|
| Data Definition Item Examples |
|
| Special Attribute Mark Counts |
|
| A/AMC = 0 Item-id |
|
| A/AMC = 9998 Line Count/NI Operand |
|
| A/AMC = 9999 Item Size/NL Operand |
|
| Predefined Data Definition Items |
|
| Dynamic Data Definition Item |
|
| Conversion Codes |
|
| Attribute 8 Versus Attribute 7 Processing |
|
| Data Formats |
|
| Attribute 8 (Pre-processor) |
|
| Attribute 7 (Input/output Processor) |
|
| Input Conversions |
|
| Multiple Codes |
|
| Processing Stages |
|
| Detail Line Processing |
|
| Selection Processing |
|
| Sort Processing |
|
| TOTAL Connective Processing |
|
| BREAK-ON Connective Processing |
|
| Processing Code Summary |
|
| A Code - Algebraic Functions |
|
| Overview |
|
| Summary of A and AE Formats |
|
| Operators |
|
| Arithmetic Operators |
|
| Relational Operators |
|
| Logical Operators |
|
| Concatenation Operator |
|
| Summary of Operands |
|
| Operand Attribute Number (AMC) |
|
| Operand Attribute Name |
|
| Operand Literals |
|
| Operand System Parameters |
|
| Operand Special Functions |
|
| Integer Function |
|
| Remainder Function |
|
| Summation Function |
|
| Substring Function |
|
| Format Codes |
|
| IF Statement |
|
| Multivalues |
|
| A Code Example |
|
| B64 Code - Base64 Encode/Decode |
|
| C Code - Concatenation |
|
| CALL Code - Call Subroutine |
|
| D Code - Date Conversion |
|
| D1 and D2 Codes - Controlling and Dependent Attributes |
|
| F Code - Mathematical Functions |
|
| Overview |
|
| Overview of Operators |
|
| Order of Operations |
|
| The Pushdown Stack |
|
| Push Operators |
|
| Arithmetic Operators |
|
| Miscellaneous Operators |
|
| Relational Operators |
|
| Logical Operators |
|
| Scaler |
|
| Multivalues |
|
| The S Operator |
|
| Format Codes |
|
| Examples of Stack Operations |
|
| F Code Examples |
|
| G Code - Group Extraction |
|
| L Code - Length |
|
| MC Codes - Mask Character |
|
| Overview |
|
| Changing Case |
|
| Extracting Characters |
|
| Replacing Characters |
|
| Converting Character Codes |
|
| Converting Numeric Values |
|
| MD Code - Mask Decimal without Alignment |
|
| MK Code - Mask Metric |
|
| ML and MR Codes - Mask Decimal with Alignment |
|
| Overview |
|
| Decimal Precision and Scaling |
|
| Suppressing Leading Zeros |
|
| Specifying the Thousands Separator |
|
| Specifying the Credit Indicator |
|
| Specifying a Currency Symbol |
|
| Specifying a Format Mask |
|
| Examples |
|
| MP Code - Masked Packed Decimal |
|
| MT Code - Mask Time |
|
| P Code - Pattern Matching |
|
| R Code - Range Check |
|
| S Code - Substitution |
|
| S Code - SOUNDEX |
|
| T Code - Text Extraction |
|
| Tfile Code - Translation |
|
| U Code - User Exit |
|
| XT Code - Generate HTML |
|
| English Macros |
|
| General Rules for Macros |
|
| USING Clause |
|
| Call to Another Macro |
|
| Macro Names |
|
| Comment Lines |
|
| Macro to Replace a Default Output Specification |
|
| Creating a Macro |
|
| Macro Examples |
|
| MultiValue Compatibility |
|
| B Conversion Code - Call Subroutine |
|
| Division using A and F Conversion Codes |
|
| Date Format |
|
| Changing Case |
|
| Predefined Data Definition Items |
|
| DataBasic Reference |
|
| Introduction to DataBasic |
|
| Compilation |
|
| Cataloging |
|
| DataBasic Elements |
|
| Program Elements |
|
| Multi-statement Line |
|
| Line Continuation |
|
| Identifiers |
|
| Statement Labels |
|
| Reserved Words |
|
| Comments |
|
| Blank Spaces and Lines |
|
| Program Storage |
|
| Naming a Program |
|
| Subroutines and External Functions |
|
| Internal Subroutine |
|
| External Subroutine |
|
| External Function |
|
| Including Common Code |
|
| Literals, Symbols and Variables |
|
| Numeric Literals |
|
| String Literals |
|
| Symbols |
|
| Variables |
|
| Assignments |
|
| Arithmetic Expressions |
|
| Precedence |
|
| Parentheses |
|
| Strings in Arithmetic Expressions |
|
| Examples |
|
| String Expressions and Concatenation |
|
| Substring Expression |
|
| Concatenation |
|
| Examples |
|
| Substring Extraction |
|
| Substring Assignment |
|
| Relational Expressions |
|
| Relational Operators |
|
| Arithmetic Relations |
|
| String Relations |
|
| MATCH{ES} |
|
| MATCHFIELD |
|
| Logical Expressions |
|
| Bitwise Logical Functions |
|
| Assignment Operators |
|
| External Object Operators |
|
| Using the THEN/ELSE and ON ERROR Clauses |
|
| Syntax of THEN/ELSE |
|
| Syntax of ON ERROR Clause |
|
| Statements using THEN/ELSE |
|
| Statements using ON ERROR |
|
| Examples |
|
| Format Strings |
|
| Syntax |
|
| Operation |
|
| Examples of Format Strings |
|
| Conversions |
|
| Output Conversions |
|
| Input Conversions |
|
| Date Output Conversions |
|
| External to Internal Date Conversion |
|
| Mask Character Conversions |
|
| User Exit Conversions |
|
| TCL Commands that Modify Conversions |
|
| Execution and Item Locks |
|
| Arrays |
|
| Dimensioned Arrays |
|
| Syntax |
|
| Dimensioning an Array |
|
| Accessing Array Elements |
|
| Using MATWRITE{U} and MATREAD{U} |
|
| Writing a Matrix to Disk |
|
| Dynamic Arrays |
|
| Syntax |
|
| Element Delimiters |
|
| Data Extraction and Replacement |
|
| Data Insertion and Deletion |
|
| Manipulating the contents of Dynamic Arrays |
|
| Dynamic Array Examples |
|
| Program Examples |
|
| Data Extraction Examples |
|
| Data Replacement Examples |
|
| Rules for Dynamic Array References |
|
| Dynamic Arrays vs. Dimensioned Arrays |
|
| Dynamic Arrays |
|
| Dimensioned Arrays |
|
| Rules of Usage |
|
| Using Indexes |
|
| Statements and Intrinsic Functions |
|
| Statements and Functions by Category |
|
| $CHAIN Statement |
|
| $DEFINE Statement |
|
| $IFDEF Statement |
|
| $IFNDEF Statement |
|
| $OPTIONS Statement |
|
| $UNDEFINE Statement |
|
| @ Function |
|
| Special Methods (DataBasic Objects) |
|
| %Admin |
|
| %Array |
|
| %Connect |
|
| %Decode |
|
| %Encode |
|
| %Enum |
|
| %GetError |
|
| %GetErrorNum |
|
| %Import |
|
| %Is |
|
| %Length |
|
| %New |
|
| %Null |
|
| %ObjMgr |
|
| %Set |
|
| %Static |
|
| %Template |
|
| %This |
|
| %ToJSON |
|
| %ToMV |
|
| %ToXML |
|
| %Type |
|
| %TypeOf |
|
| ABORT Statement |
|
| ABS Function |
|
| ABSS Function |
|
| ACCEPT Statement |
|
| ACCESS Function |
|
| ACCESS Statement |
|
| ADDS Function |
|
| ALPHA Function |
|
| ANDS Function |
|
| ASCII Function |
|
| ASSIGN Statement |
|
| BASIC.DUMP Statement |
|
| BCC Function |
|
| BITAND Function |
|
| BITCHANGE Function |
|
| BITCHECK Function |
|
| BITLOAD Function |
|
| BITNAND Function |
|
| BITNOR Function |
|
| BITNOT Function |
|
| BITOR Function |
|
| BITRESET Function |
|
| BITSET Function |
|
| BITXNOR Function |
|
| BITXOR Function |
|
| BREAK Statement |
|
| CALL Statement |
|
| CASE Statement |
|
| CASING Statement |
|
| CATS Function |
|
| CHAIN Statement |
|
| CHANGE Function |
|
| CHAR Function |
|
| CHARS Function |
|
| CHECKSUM Function |
|
| CLEAR Statement |
|
| CLEARDATA Statement |
|
| CLEARFILE Statement |
|
| CLEARSELECT Statement |
|
| CLOSE Statement |
|
| CLOSESEQ Statement |
|
| COLLECTDATA Statement |
|
| COL1/COL2 Functions |
|
| COMMON Statement |
|
| COMPARE Function |
|
| COMPARE Statement |
|
| CONNECT Statement |
|
| CONVERT Function |
|
| CONVERT Statement |
|
| COS Function |
|
| COUNT Function |
|
| COUNTS Function |
|
| CRC Function |
|
| CRT Statement |
|
| DATA Statement |
|
| DATE Function |
|
| DCOUNT Function |
|
| DEBUG Statement |
|
| DECRYPT Function |
|
| DEFFUN Statement |
|
| DEL Statement |
|
| DELETE Function |
|
| DELETE Statement |
|
| DELETELIST Statement |
|
| DELETESEQ Statement |
|
| DELIM.POS Function |
|
| DIMENSION Statement |
|
| DISCONNECT Statement |
|
| DIVS Function |
|
| DOWNCASE Function |
|
| DQUOTE Function |
|
| DTX Function |
|
| EBCDIC Function |
|
| ECHO Statement |
|
| ENCRYPT Function |
|
| EM_ADD_ATTACHMENT Function (DataBasic Email API) |
|
| EM_ADD_ATTACHMENT_ITEM Function (DataBasic Email API) |
|
| EM_ADD_DELIVERY_DETAILS Function (DataBasic Email API) |
|
| EM_ADD_HTML_TEXT Function (DataBasic Email API) |
|
| EM_ADD_PLAIN_TEXT Function (DataBasic Email API) |
|
| EM_DEFINE_CONFIG Function (DataBasic Email API) |
|
| EM_ENABLE_DEBUG Function (DataBasic Email API) |
|
| EM_SEND_EMAIL Function (DataBasic Email API) |
|
| EM_START_EMAIL Function (DataBasic Email API) |
|
| END Statement |
|
| ENTER Statement |
|
| EQS Function |
|
| EQUATE Statement |
|
| EXP Function |
|
| EXTRACT Function |
|
| FIELD Function |
|
| FIELDS Function |
|
| FILEINFO Function |
|
| FILEPATH Function |
|
| FIND Statement |
|
| FINDSTR Statement |
|
| FLUSH Statement |
|
| FMT Function |
|
| FOLD Function |
|
| FOOTING Statement |
|
| FOR Statement |
|
| FUNCTION Statement |
|
| GES Function |
|
| GETLIST Statement |
|
| GETMSG Function |
|
| GOSUB Statement |
|
| GOTO Statement |
|
| GROUP Function |
|
| GROUPSTORE Statement |
|
| HEADING Statement |
|
| ICONV Function |
|
| ICONVS Function |
|
| IF Statement |
|
| IFS Function |
|
| IN Statement |
|
| INCLUDE Statement |
|
| INDEX Function |
|
| INPUT Statement |
|
| INPUT CTRL Statement |
|
| INPUT@ Statement |
|
| INPUTCLEAR Statement |
|
| INPUTERROR Statement |
|
| INPUTNULL Statement |
|
| INPUTTRAP Statement |
|
| INS Statement |
|
| INSERT Function |
|
| INT Function |
|
| LEN Function |
|
| LENS Function |
|
| LES Function |
|
| LET Statement |
|
| LIMIT.INDEX Statement |
|
| LN Function |
|
| LOCATE Statement |
|
| LOCK Statement |
|
| LOOP Statement |
|
| LOWER Function |
|
| MAT Statement |
|
| MATBUILD Statement |
|
| MATCHFIELD Function |
|
| MATPARSE Statement |
|
| MATREAD Statement |
|
| MATREADU Statement |
|
| MATWRITE Statement |
|
| MATWRITEU Statement |
|
| MAXIMUM Function |
|
| MINIMUM Function |
|
| MOD Function |
|
| MODS Function |
|
| MULS Function |
|
| NEGS Function |
|
| NES Function |
|
| NEXT Statement |
|
| NOT Function |
|
| NOTS Function |
|
| NULL Statement |
|
| NUM Function |
|
| NUMS Function |
|
| OCONV Function |
|
| OCONVS Function |
|
| ON GOSUB Statement |
|
| ON GOTO Statement |
|
| OPEN Statement |
|
| OPENSEQ Statement |
|
| ORS Function |
|
| PAGE Statement |
|
| PAUSE Statement |
|
| PERFORM Statement |
|
| POSITION Statement |
|
| PRECISION Statement |
|
| PRINT Statement |
|
| PRINTER Statement |
|
| PRINTERR Statement |
|
| PROCREAD Statement |
|
| PROCWRITE Statement |
|
| PROGRAM Statement |
|
| PROMPT Statement |
|
| PTR Function |
|
| PWR Function |
|
| RAISE Function |
|
| READ Statement |
|
| READBLK Statement |
|
| READLIST Statement |
|
| READNEXT Statement |
|
| READPREV Statement |
|
| READSEQ Statement |
|
| READT Statement |
|
| READU Statement |
|
| READV Statement |
|
| READVU Statement |
|
| RECEIVE Statement |
|
| RECORDLOCKED Function |
|
| RECWAIT Statement |
|
| RELEASE Statement |
|
| REM Function |
|
| REM Statement |
|
| REMOVE Statement |
|
| REMOVE.POS Function |
|
| REMOVE.POS Statement |
|
| REPEAT Statement |
|
| REPLACE Function |
|
| RETURN Statement |
|
| REWIND Statement |
|
| RND Function |
|
| ROUND Function |
|
| RQM Statement |
|
| RTNDATA Statement |
|
| SEEK Statement |
|
| SELECT, SELECTE Statements |
|
| SELECTINFO Function |
|
| SEND Statement |
|
| SENTENCE Function |
|
| SEQ Function |
|
| SEQS Function |
|
| SIN Function |
|
| SLEEP Statement |
|
| SORT Function |
|
| SOUNDEX Function |
|
| SPACE Function |
|
| SPACES Function |
|
| SPLICE Function |
|
| SPOOLER Function |
|
| SQRT Function |
|
| SQUOTE Function |
|
| STOP Statement |
|
| STR Function |
|
| STRS Function |
|
| SUBROUTINE Statement |
|
| SUBS Function |
|
| SUM Function |
|
| SUMMATION Function |
|
| SYSTEM Function |
|
| SYSTEM Statement |
|
| TAN Function |
|
| TIME Function |
|
| TIMEDATE Function |
|
| TRANSABORT Statement |
|
| TRANSEND Statement |
|
| TRANSQUERY Function |
|
| TRANSTART Statement |
|
| TRIM/TRIMB/TRIMF Functions |
|
| TRUNC Function |
|
| UNASSIGNED Function |
|
| UNLOCK Statement |
|
| UNTIL Statement |
|
| UPCASE Function |
|
| VARTYPE Function |
|
| VARVAL Function |
|
| VARVALSET Statement |
|
| VARVALTYPE Function |
|
| WAKE Statement |
|
| WEOF Statement |
|
| WEOFSEQ Statement |
|
| WHILE Statement |
|
| WRITE Statement |
|
| WRITEBLK Statement |
|
| WRITELIST Statement |
|
| WRITESEQ Statement |
|
| WRITET Statement |
|
| WRITEU Statement |
|
| WRITEV Statement |
|
| WRITEVU Statement |
|
| XTD Function |
|
| Related TCL Commands |
|
| BASIC |
|
| BLIST |
|
| BREF |
|
| BVERIFY |
|
| CATALOG |
|
| CLEAR-BASIC-LOCKS |
|
| COMPILE |
|
| DB |
|
| DEBUG |
|
| DECAT |
|
| DELETE-CATALOG, DECATALOG |
|
| ECOPY |
|
| END |
|
| LOAD-BNF |
|
| NC.LIST |
|
| NC.RESET |
|
| PRINT-CATALOG |
|
| RUN |
|
| Programming in DataBasic |
|
| Programming Hints |
|
| Using System Delimiters |
|
| Cursor Positioning |
|
| Opening Files |
|
| Repeating Operations |
|
| Unknown Number of Values |
|
| Modifying a Program |
|
| Running a DataBasic Program in a Proc |
|
| Interprocess Communication |
|
| Sequential File Access |
|
| Embedded Basic Subroutines |
|
| How to Write an Embedded Basic Subroutine |
|
| Embedded Basic Examples |
|
| Debugging Embedded Basic Subroutines |
|
| How to Associate a Trigger with a File |
|
| Triggers Dos and Don'ts |
|
| Efficiency Guidelines |
|
| Internal Storage |
|
| Numeric Operations |
|
| Dynamic Arrays |
|
| File Open and Close |
|
| File Input and Output |
|
| Locking |
|
| PERFORM |
|
| Efficient Use of Subroutines and External Functions |
|
| Miscellaneous |
|
| Using the DataBasic Profiler |
|
| Programming Examples |
|
| INV-INQ Program Example |
|
| Area Program Example |
|
| Profits Program Example |
|
| Program Example Using Transactions |
|
| Program Examples using Interprocess Communication |
|
| ORDER Client/Server |
|
| FPUT Client/FGET Server |
|
| PERFORM Client/Server |
|
| TCP Client/Server |
|
| TCP Ping |
|
| TCP Email |
|
| DataBasic Development Program Example |
|
| DataBasic Real-time Run Program Example |
|
| DataBasic Email API Program Example |
|
| DataBasic Debugger |
|
| Overview |
|
| Entering the Debugger |
|
| Variables |
|
| Symbol Table |
|
| Enabling and Disabling the Debugger |
|
| Summary of Debugger Commands |
|
| $ |
|
| / |
|
| ? |
|
| ?M |
|
| @ |
|
| A |
|
| AT |
|
| B |
|
| CP |
|
| CS |
|
| D |
|
| DCC |
|
| DE{BUG} |
|
| DPC |
|
| DUMP |
|
| E |
|
| END |
|
| G |
|
| K |
|
| L |
|
| LD |
|
| LP |
|
| M |
|
| MA |
|
| MD |
|
| ME |
|
| MO |
|
| MR |
|
| MX |
|
| N |
|
| OFF |
|
| P |
|
| PC |
|
| S |
|
| SL |
|
| T |
|
| U |
|
| V |
|
| W |
|
| WF |
|
| WS |
|
| X |
|
| Z |
|
| DataBasic Objects |
|
| How to use Java Objects in DataBasic |
|
| How to use .NET Objects in DataBasic |
|
| How to use Internal Objects in DataBasic |
|
| Connection Objects |
|
| Object Data |
|
| Calling Object Methods |
|
| Calling Special Methods |
|
| Type Casting |
|
| Object Duplication |
|
| Object Comparison |
|
| Object Deletion |
|
| DBO Configuration File |
|
| DBO Errors and the DataBasic Debugger |
|
| Language Server Optimisation |
|
| DataBasic Special Methods |
|
| DataBasic Email API |
|
| EM_DEFINE_CONFIG |
|
| EM_START_EMAIL |
|
| EM_ADD_DELIVERY_DETAILS |
|
| EM_ADD_ATTACHMENT |
|
| EM_ADD_ATTACHMENT_ITEM |
|
| EM_ADD_AUTH_DETAILS |
|
| EM_ADD_HTML_TEXT |
|
| EM_ADD_PLAIN_TEXT |
|
| EM_SEND_EMAIL |
|
| EM_ENABLE_DEBUG |
|
| DataBasic Application Dump |
|
| DISP.DB.DUMPS program |
|
| RELOG.DB.DUMPS program |
|
| DataBasic Exception Handler |
|
| Define Exception Handler - ECATCH |
|
| Remove Exception Handler - ECLEARCATCH |
|
| Generate User Exception - ETHROW |
|
| Pass Exception Back to Earlier Code Level - ERETHROW |
|
| Pass Exception to DataBasic Debugger - EDEBUG |
|
| Get Exception Number - EXCEPT.NUM() |
|
| Get Exception Message - EXCEPT.MSG() |
|
| Get Exception Code Level Return Stack - EXCEPT.STK() |
|
| Exception Handler Defined in this Code Level - ECATCH.LOC() |
|
| Total Number of Exception Handlers Defined - ECATCH.ACTIVE() |
|
| DataBasic Exception Handler - Example of Usage |
|
| MultiValue Compatibility |
|
| Features that Depend on the Compatibility Mode |
|
| Reality Features with Additional Functionality |
|
| Additional Features |
|
| DataBasic Elements |
|
| Statement Labels |
|
| Predefined Symbols |
|
| Substring Extraction |
|
| Item Locks |
|
| Boolean Compiler Directives |
|
| $OPTIONS Statement |
|
| @ function |
|
| ASSIGNED Function |
|
| CHANGE Statement |
|
| CLEARINPUT Statement |
|
| CREATE Statement |
|
| DELETE Statement |
|
| DELETESEQ Statement |
|
| DISPLAY Statement |
|
| DIV Function |
|
| DQUOTE Statement |
|
| EQUATE Statement |
|
| EREPLACE Function |
|
| EXECUTE Statement |
|
| FIELD Function |
|
| FORMLIST Statement |
|
| GROUP Function |
|
| LEFT Function |
|
| MATPARSE Statement |
|
| MSLEEP Statement |
|
| OPENSEQ Statement |
|
| OUT Statement |
|
| QUOTE Function |
|
| READLIST Statement |
|
| READNEXT Statement |
|
| READPREV Statement |
|
| REMOVE Statement |
|
| RIGHT Function |
|
| SADD Function |
|
| SELECT Statement |
|
| SQUOTE Statement |
|
| SSUB Function |
|
| STATUS Function |
|
| SWAP Function |
|
| SYSTEM and REAL.SYSTEM Functions |
|
| TCLREAD Statement |
|
| TRANS Function |
|
| WRITE Statements |
|
| Compatibility Switch Matrix |
|
| Terminal Types |
|
| User Exit Conversions |
|
| Redefining User Exits |
|
| File I/O and IPC Error Codes |
|
| File I/O Error Codes |
|
| IPC Error Codes |
|
| Printer Independent Functions |
|
| Introduction to Printer Independence |
|
| Printer Independent Functions |
|
| Function Classes |
|
| Using Alternative Compilers |
|
| TCP Parameters |
|
| Port Numbers |
|
| Options |
|
| About this Section |
|
| Contents |
|
| Related Documents |
|
| Abbreviations |
|
| Conventions |
|
| Proc Features |
|
| Structure of a Proc |
|
| PQ and PQN Procs |
|
| Linking Procs |
|
| Labels |
|
| Multiple Commands |
|
| Comment Commands |
|
| Executing a Proc |
|
| Input/Output Buffers |
|
| Primary Input Buffer |
|
| Secondary Input Buffer |
|
| Active Input Buffer |
|
| Primary Output Buffer |
|
| Secondary Output Buffer |
|
| Active Output Buffer |
|
| Parameters and Pointers |
|
| Notes on Output Buffers |
|
| File Buffers (PQN) |
|
| Select Registers (PQN) |
|
| Buffer Referencing (PQN) |
|
| Buffer Reference Symbols |
|
| Direct Referencing |
|
| Indirect Referencing |
|
| Item Locks |
|
| Programming Efficiency |
|
| GO vs. GO F and GO B |
|
| Grouping Commands |
|
| Compiling a Proc |
|
| Chaining Procs |
|
| Structuring Procs |
|
| Proc Tips |
|
| TIME and DATE |
|
| English Statements |
|
| Executing TCL and English Commands |
|
| Validating Dates and Times |
|
| How to READV in Proc |
|
| MCDX/MCXD |
|
| P Option |
|
| Concatenation |
|
| Hold File Numbers |
|
| System Procs |
|
| Listing Procs |
|
| SYSTEM Function |
|
| PQN Proc Commands |
|
| Summary of PQN Proc Commands |
|
| Input Buffer Operations |
|
| Output Buffer Operations |
|
| Data Movement Operations |
|
| Input/Output Operations |
|
| Jump and Branch Operations |
|
| Conditional Operations |
|
| File Operations |
|
| Arithmetic Calculations |
|
| Processing |
|
| Debugging a Proc |
|
| Exiting a Proc |
|
| ( ) |
|
| [ ] |
|
| + |
|
| - |
|
| A |
|
| B |
|
| BO |
|
| C |
|
| D |
|
| F |
|
| F; |
|
| F-CLEAR |
|
| F-DELETE |
|
| F-FREE |
|
| F-KLOSE |
|
| F-OPEN |
|
| F-READ |
|
| F-UREAD |
|
| F-WRITE |
|
| FB |
|
| G (also GO or GOTO) |
|
| GO B |
|
| GO F |
|
| GOSUB |
|
| H |
|
| IBH |
|
| IBN |
|
| IBP |
|
| IF |
|
| IF (Multivalued) |
|
| IF (with Mask) |
|
| IF E |
|
| IF S |
|
| IFN |
|
| IH |
|
| IN |
|
| IP |
|
| IT |
|
| L |
|
| M |
|
| MS |
|
| MV |
|
| MVA |
|
| MVD |
|
| O |
|
| P |
|
| PROMPT command |
|
| RI |
|
| RO |
|
| RSUB |
|
| RTN |
|
| S |
|
| STOFF |
|
| STON |
|
| SYSTEM Function |
|
| T |
|
| TR |
|
| U |
|
| X |
|
| TCL Commands Related to Proc |
|
| GO |
|
| PQ-COMPILE |
|
| PQ-RESELECT |
|
| PQ-SELECT |
|
| TRACE |
|
| UCOMPILE |
|
| Differences between PQ and PQN Proc |
|
| PQ vs. PQN Procs |
|
| Summary of Command Differences |
|
| Proc Examples |
|
| Date Conversion |
|
| Creating a Control File |
|
| DataBasic Programming Aid |
|
| Transaction Handling |
|
| MultiValue Compatibility |
|
| Select Lists |
|
| Item Locks |
|
| Editors |
|
| About this Section |
|
| Contents |
|
| Related Documents |
|
| Conventions |
|
| The Line Editor |
|
| Overview |
|
| Operation of the Editor |
|
| Entering the Editor: EDIT Command |
|
| Typing System Delimiters |
|
| Item Locking |
|
| Creating Null Attributes |
|
| Recovering Deleted Items: RECOVER-FD Command |
|
| Search Strings |
|
| String Delimiters |
|
| Wildcard Character |
|
| Case Sensitivity |
|
| Column-dependent Matching |
|
| Editor Commands |
|
| Command Format |
|
| Summary of Editor Commands |
|
| BACKSPACE Key |
|
| TAB Key |
|
| RETURN Key |
|
| / Command |
|
| ^ Command |
|
| n Command |
|
| = (Toggle Search Case-sensitivity) |
|
| ? |
|
| ?? |
|
| ?I |
|
| ?L |
|
| ?P |
|
| ?R |
|
| ?S |
|
| A (Again) |
|
| AP (Append) |
|
| AR (Replace Again) |
|
| B (Bottom) |
|
| C (Column Ruler) |
|
| CA (Concatenate) |
|
| CD (Change Delimiter) |
|
| CI (Case-insensitive Search) |
|
| CS (Case-sensitive Search) |
|
| DE (Delete) |
|
| EX (Exit) |
|
| F (Flip) |
|
| FD (File Delete) |
|
| FI (File) |
|
| FS (File Save) |
|
| G (Goto) |
|
| H (Hexadecimal) |
|
| I (Insert) |
|
| J (Join) |
|
| K (Unlock Item) |
|
| L (List) |
|
| L (Locate) |
|
| ME (Merge) |
|
| ML - Lower case |
|
| MU - Upper case |
|
| N (Next) |
|
| P (Prestore) |
|
| PD (Prestore Display) |
|
| PP (Print Prestore) |
|
| Q |
|
| R (Replace) |
|
| S (Suppress line numbers) |
|
| S? |
|
| SP (Split) |
|
| T (Top) |
|
| TB (Tab) |
|
| TR (Truncate) |
|
| U (Up) |
|
| W (Window) |
|
| X |
|
| XF |
|
| Z (Zone) |
|
| Summary of Editor Messages |
|
| About this Section |
|
| Contents |
|
| Related Documents |
|
| Conventions |
|
| Introduction to the Screen Editor |
|
| Overview |
|
| Operation of the Screen Editor |
|
| Entering the Screen Editor: SEDIT Verb |
|
| Mode of Operation |
|
| Screen Editor Help |
|
| Typing System Delimiters |
|
| PC Operation |
|
| Item Locking |
|
| Delay Between Filing and Writing Items to the Disk |
|
| Summary |
|
| Screen Editor Commands |
|
| Overview |
|
| Summary of Screen Editor Commands |
|
| Backspace |
|
| Tab |
|
| Return |
|
| Space |
|
| ! ~ ` - Change Case |
|
| # - Column Ruler |
|
| $ - Print Item |
|
| & - Time and Date |
|
| * - Prestore Record |
|
| + - Highlight Line |
|
| . - Page Forward |
|
| : - Truncate Line |
|
| < - Unformat |
|
| = - Toggle Search Case-sensitivity |
|
| > - Format |
|
| ? - Help |
|
| [ ' P - Cut and Paste |
|
| 0 - Page Back |
|
| 7 - Word Back |
|
| 8 - Line Up |
|
| 9 - Word Forward |
|
| CTRL+C - Character Value |
|
| CTRL+D - Divide Screen |
|
| CTRL+L - Cursor Far Left |
|
| CTRL+P - Prestore Run |
|
| CTRL+R - Cursor Far Right |
|
| CTRL+T - Tab Size |
|
| A - Locate Again |
|
| B - Bottom |
|
| C - Comments |
|
| D - Delete Character |
|
| E - External Read |
|
| F - File |
|
| G - Go To Line Number |
|
| H - Half Screen Line Number |
|
| I - Input Mode |
|
| J - Insert Character |
|
| K - Delete Lines |
|
| L - Locate Character |
|
| M - Merge Lines |
|
| O - Overtype |
|
| Q - Delete Word |
|
| R - Replace Character |
|
| S - Search and Replace |
|
| T - Top |
|
| U - Undo |
|
| V - View |
|
| W - Window |
|
| X - Exit |
|
| Screen Editor Applications |
|
| Combining Adjacent Lines |
|
| Creating English Dictionary Items |
|
| Different Ways to Display Lines |
|
| Inserting Characters |
|
| Creating and Using Prestored Commands |
|
| Undo Command |
|
| Last Character of an Item |
|
| Alternative Method of Deleting Characters |
|
| ME command |
|
| ME Commands |
|
| Conventions |
|
| Command Mode |
|
| Edit Mode |
|
| RealEdit |
|
| Reality Resilience |
|
| Contents |
|
| Part 1: Introducing Reality Resilience |
|
| Part 2: Transaction Handling Reference |
|
| Part 3: Transaction Logging Reference |
|
| Part 4: Rapid Recovery Reference |
|
| Part 5: Shadow Database Reference |
|
| Part 6: FailSafe Reference |
|
| Part 7: Disaster Recovery |
|
| Part 8: Appendixes |
|
| Related Documents |
|
| Conventions |
|
| Overview of Resilience Options |
|
| Introducing Reality Resilience |
|
| Resilience Options |
|
| Transaction Handling |
|
| Transaction Logging |
|
| Rapid Recovery |
|
| Shadow Database |
|
| FailSafe |
|
| Disaster Recovery |
|
| Administration Utility |
|
| The tlmenu Utility |
|
| tlmenu Command |
|
| tlmulti Command |
|
| tlmenu Menus and Procedures |
|
| Show Logging Status Option |
|
| Naming Convention for Clean Logs |
|
| Backup Methods used by tlmenu |
|
| Remote Administration of a FailSafe Secondary |
|
| Configuration Options |
|
| Managing the temporary directory |
|
| Clean logs |
|
| Disabling clearance of TL-REJECT log |
|
| Transaction Handling |
|
| Overview |
|
| What is a Transaction? |
|
| What is Transaction Handling? |
|
| Executing a Transaction |
|
| Aborting a Transaction |
|
| Distributed Transactions |
|
| Configuring Transaction Handling |
|
| Overview |
|
| Defining a Transaction Handling Database |
|
| Starting Transaction Handling |
|
| Stopping Transaction Handling |
|
| TRANSABORT |
|
| TRANSEND |
|
| TRANSQUERY |
|
| TRANSTART |
|
| Process Recovery |
|
| Distributed Transactions |
|
| Introduction to Transaction Logging |
|
| Overview |
|
| Before and After Images |
|
| The Raw Log |
|
| Clean Logs |
|
| Transaction Logging with Multiple Databases |
|
| Database Recovery |
|
| Process Recovery |
|
| Rapid Recovery |
|
| Full Recovery |
|
| Configuring Transaction Logging |
|
| Overview |
|
| Configuring a Database for Transaction Logging |
|
| Starting Transaction Logging |
|
| Stopping Transaction Logging |
|
| Configuring the Transaction Logging Status Monitor |
|
| TL-SET-LOG-STATUS Command |
|
| Routine Maintenance of Transaction Logging |
|
| Overview |
|
| Switching Clean Logs |
|
| Listing Clean Logs |
|
| Archiving a Clean Log |
|
| Deleting Clean Logs |
|
| Exporting Clean Logs |
|
| Starting the Transaction Logging Status Monitor |
|
| Stopping the Transaction Logging Status Monitor |
|
| Saving the Database |
|
| Transaction Logging Database Recovery |
|
| Overview |
|
| Restoring the Database from the Most Recent Backup Tape |
|
| Restoring Clean Logs onto the Database |
|
| TL-RESTORE command |
|
| Miscellaneous Transaction Logging Procedures |
|
| Overview |
|
| Retrieving an Archived Clean Log |
|
| Listing Active Transactions |
|
| Overview |
|
| What is Rapid Recovery? |
|
| How Rapid Recovery Works |
|
| Database Recovery |
|
| Implications for Performance |
|
| Configuring Rapid Recovery |
|
| Overview |
|
| Setting Up a Database for Rapid Recovery |
|
| Recoverable Files |
|
| Rapid Database Recovery |
|
| Recovery Procedure |
|
| Shadow Databases |
|
| Actions Following Rapid Recovery |
|
| Overview |
|
| What is Shadow Database? |
|
| Shadow Database Configuration |
|
| Periodic Updating of Shadow |
|
| Database Recovery |
|
| Shadow Database Administration |
|
| Database Naming |
|
| Configuring Shadow Database |
|
| Overview |
|
| Defining/Redefining Shadow Database |
|
| Routine Maintenance of Shadow Database |
|
| Overview |
|
| Saving the Live Database |
|
| Saving the Shadow Database |
|
| Updating the Shadow Database |
|
| Shadow Database Recovery |
|
| Overview |
|
| Making the Current Database the Live Database and Restoring the Latest Clean Log |
|
| Rebuilding and Restoring the Shadow Database |
|
| Restoring Clean Logs onto the Shadow Database |
|
| Miscellaneous Shadow Database Procedures |
|
| Overview |
|
| Swapping to the Shadow Database |
|
| Shadow Database Host Configuration |
|
| UNIX |
|
| UNIX Disk Configuration |
|
| Partition Databases |
|
| Filestore Databases |
|
| Clean Logs |
|
| Starting Shadow Database on UNIX |
|
| Shadow Startup Script |
|
| Startup Procedure After Clean Shutdown |
|
| Startup Procedure After Dirty Shutdown |
|
| Use of File System Default Tables to Mount/Unmount Partitions |
|
| Symbolic Links in the Shadow Directory |
|
| Windows |
|
| Windows Disk Configuration |
|
| Clean Logs |
|
| Starting Shadow Database on Windows |
|
| Shadow Database Synonym Entries |
|
| Shadow Database Step-by-Step Configuration Guide |
|
| Overview |
|
| What is FailSafe? |
|
| The FailSafe Configuration |
|
| FailSafe Logging |
|
| Database Recovery |
|
| FailSafe Logging Link |
|
| FailSafe with Multiple Databases |
|
| Configuring a FailSafe Pair |
|
| Overview |
|
| Defining/Redefining a FailSafe Database |
|
| Routine Maintenance of FailSafe |
|
| Overview |
|
| Saving a Secondary Database |
|
| Saving the Primary Database |
|
| FailSafe Database Recovery |
|
| Overview |
|
| Checking/Reconfiguring Databases Prior to Recovery |
|
| Rebuilding and Restoring the Secondary Database |
|
| Restoring Clean Log(s) onto the Secondary Database |
|
| Resynchronising Databases for Normal FailSafe |
|
| Miscellaneous FailSafe Procedures |
|
| Overview |
|
| Logging Off Users and Locking a FailSafe Database |
|
| Unlocking a FailSafe Database |
|
| Swapping Primary and Secondary Databases and Continuing FailSafe |
|
| Stopping the Secondary and Breaking FailSafe |
|
| Use Alternative Failsafe Link |
|
| Reality Disaster Recovery |
|
| Configuring Disaster Recovery |
|
| Recovering a Database using Disaster Recovery |
|
| Disaster Recovery Administration |
|
| Clean Log Administration |
|
| Clean Log File System |
|
| Use of a Log Disk |
|
| Types of Log File |
|
| Managing Clean Log Size |
|
| Clean Log Partition Size |
|
| Estimating Clean Log Growth Rate |
|
| Archiving Clean Logs |
|
| Recovery from Clean Log Partition Full |
|
| Multiple Databases |
|
| Using English to Examine a Clean Log or Error Log |
|
| Using DataBasic to Examine a Clean Log or Error Log |
|
| Automatic Switching of Clean Logs |
|
| The Mechanism |
|
| Defining Clean Log Size Limit |
|
| Archiving Clean Logs |
|
| Raw Log Configuration |
|
| Location of Raw Log |
|
| Use of a Log Disk |
|
| Size of Raw Log |
|
| The 2 Minute Factor |
|
| Allowing for the Longest Transaction |
|
| How Update Data is Stored |
|
| Size of the Image Header |
|
| Transaction Boundary Images |
|
| Factors Affecting Raw Log Size |
|
| mklog - Making a Raw Log |
|
| rladm |
|
| Interactive Recovery of Distributed Transactions |
|
| rxaserver Command |
|
| About this Section |
|
| Introduction |
|
| Software Compliance |
|
| Assumed Knowledge |
|
| Contents |
|
| Related Documents |
|
| Conventions |
|
| Introduction to SQL for Reality |
|
| Introduction |
|
| What are ODBC and JDBC? |
|
| SQL for Reality |
|
| SQL/JDBC |
|
| Standards |
|
| SQL/ODBC for Reality |
|
| RealSQL Driver |
|
| Distributed Transactions |
|
| SQL/JDBC for Reality |
|
| Reality Database as an SQL Data Source |
|
| Accessing Reality Files using SQL |
|
| What is a Reality SQL Catalog? |
|
| Client/Server Interface |
|
| Definition of the SQL Environment in Reality |
|
| Administration Using SQLM |
|
| Setting up an SQL Catalog |
|
| Multiple Account Catalogs |
|
| SQL-Reality Relationships |
|
| SQL Catalog Files |
|
| SQLTABLES File |
|
| SQLCOLUMNS File |
|
| SQLINDEXES File |
|
| Creating a Reality SQL Catalog |
|
| Naming of Tables, Columns and Indexes |
|
| Reviewing Reality Dictionaries |
|
| Using Existing Reality Data Dictionaries |
|
| Checking a Column Definition |
|
| Indexes |
|
| Listing Columns and Indexes in Reality |
|
| Listing the Columns in a Table |
|
| Listing the Indexes for a Table |
|
| Setting Up a Working System |
|
| Setting-up the Host System |
|
| Setting-up the SQL/ODBC Software on a PC |
|
| Configuring the Standard Network Interface |
|
| Setting-up the SQL/ODBC Data Source |
|
| Setting-up the SQL/JDBC Software on a Client System |
|
| Connecting using SQL/JDBC |
|
| Troubleshooting |
|
| Host Configuration |
|
| Reality User-id |
|
| SQL/ODBC |
|
| SQL/JDBC |
|
| Catalog Administration |
|
| Introduction |
|
| Syntax |
|
| Using a Select List |
|
| Examples |
|
| Case Sensitivity |
|
| Creating the SQL Environment |
|
| SQL Catalog Files |
|
| Main Menu |
|
| Using the SQLM Menu Options |
|
| Entering File and Table Names |
|
| Selecting from a List |
|
| Amendments Screens |
|
| Option 1: Create New Table Definitions |
|
| Initial Procedure |
|
| Automatic Conversion of Data/Index Definitions |
|
| Manual Selection of Data/Index Definitions |
|
| Creating a Table for a File with no Data Definition Items |
|
| Option 2: Create Alternative View |
|
| Option 3: View Table Definitions |
|
| Viewing Privilege Grants |
|
| Viewing Primary Keys |
|
| Viewing Foreign Keys |
|
| Viewing Column Definitions |
|
| Viewing Index Definitions |
|
| Option 4: Amend Table Definitions |
|
| Updating Privilege Grants |
|
| Updating Primary Keys |
|
| Updating Foreign Keys |
|
| Updating a Column Definition |
|
| Updating Index Definitions |
|
| Toggling Update Permission |
|
| Option 5: Regenerate Table |
|
| Option 6: Rename Table |
|
| Option 7: Remove Table From SQL Environment |
|
| Option 8: Verify Table(s) |
|
| SQL Column and Index Definitions |
|
| SQL Column Definition Fields |
|
| Conversions in an SQL Column Definition |
|
| SQL Conversions to/from a Directly Connected Terminal |
|
| Data Generation |
|
| Output Conversions |
|
| Input Conversions |
|
| Update Conversions |
|
| SQL Index Definition Fields |
|
| Table/Column Definition Design |
|
| Introduction |
|
| Handling Multivalues and Subvalues |
|
| Accessing Multivalues or Subvalues in Columns |
|
| Examples of Handling Different Types of Multivalued Attributes |
|
| Techniques for Handling Multivalues |
|
| Examples of Handling Multivalued Data in a Single Row |
|
| Examples of Handling Related Multivalued Fields |
|
| Choosing Data Types |
|
| Column Type |
|
| Precision |
|
| Scale |
|
| Choosing Primary Keys |
|
| Application Index Design |
|
| Difference between SQL and Reality Indexes |
|
| Two-Step Index Creation Using TCL |
|
| One-Step Index Creation Using SQL |
|
| Differences Between TCL and SQL Creation Mechanisms |
|
| Processing a Query |
|
| Optimising a Query using Indexes |
|
| SQL Query Optimisation |
|
| Optimisation Methods |
|
| SQL Query Optimisation Rules |
|
| The use of Multiple AND/OR Clauses |
|
| Join Optimisation |
|
| LIKE Optimisation |
|
| Debugging Features |
|
| Index Matching Algorithm |
|
| Mismatch Problems |
|
| The ?missing values? Problem |
|
| Recommendations for Creating Indexes |
|
| Restrictions on Creating Indexes |
|
| SQL Statements Supported by Reality |
|
| Reality SQL |
|
| Data Types |
|
| Functions |
|
| SQL Views |
|
| Null Handling |
|
| Binary Data Types |
|
| Standards Compliance |
|
| SQL/ODBC |
|
| SQL/JDBC |
|
| Data Types |
|
| The SQL Command and Statements |
|
| The SQL command |
|
| SQL Statements |
|
| ALTER TABLE Statement |
|
| CALL Statement |
|
| CREATE INDEX Statement |
|
| CREATE PROCEDURE Statement |
|
| CREATE TABLE Statement |
|
| DELETE Statement |
|
| DROP INDEX Statement |
|
| DROP PROCEDURE Statement |
|
| DROP TABLE Statement |
|
| GRANT Statement |
|
| INSERT Statement |
|
| REVOKE Statement |
|
| SELECT Statement |
|
| UPDATE Statement |
|
| VERIFY Statement |
|
| SQL Search Condition |
|
| SQL Expression |
|
| SQL Stored Procedures |
|
| Writing Stored Procedures |
|
| BEGIN/END Statements |
|
| BREAK Statement |
|
| CONTINUE Statement |
|
| DECLARE Statement |
|
| IF/ELSE Statement |
|
| RETURN Statement |
|
| SET Statement |
|
| WHILE Statement |
|
| System Requirements |
|
| Host |
|
| Client |
|
| Setting up Logging |
|
| ODBC |
|
| Host-based Logging |
|
| ODBC Client-based Logging |
|
| PCSNI Logging |
|
| JDBC |
|
| Enabling Logging |
|
| SQL Reserved Keywords |
|
| SQL Environment Files |
|
| SQLINFO File |
|
| SQLTYPES File |
|
| SQLTABLES File |
|
| SQLCOLUMNS File |
|
| SQLINDEXES File |
|
| PERSONNEL File |
|
| Format of the PERSONNEL File |
|
| PERSONNEL Data |
|
| PERSONNEL Data definition items |
|
| UNIX-Connect |
|
| Overview |
|
| Contents |
|
| References |
|
| Conventions |
|
| Network User-ids |
|
| Introduction |
|
| Changing Network Passwords |
|
| Changing a Password |
|
| Deleting a Password |
|
| Remote Logon from UNIX |
|
| REMLOG |
|
| Modes of Operation |
|
| Commands |
|
| Network User-Ids |
|
| Setting Up The Terminal |
|
| Terminal Types |
|
| The TERM Variable |
|
| Character Translation |
|
| Local Mode |
|
| ! Command |
|
| Close or Disconnect Command |
|
| Exit or Quit Command |
|
| Help Command |
|
| Open or Connect Command |
|
| Remote Command |
|
| Set Command |
|
| Status Command |
|
| Starting REMLOG in Remote Mode |
|
| Remote Mode |
|
| Escape Sequence |
|
| Reality Environment |
|
| SovereignX Environment |
|
| Example Session |
|
| Error Messages |
|
| System Errors |
|
| Remote Logon to UNIX Environment |
|
| Logging On |
|
| From Reality |
|
| From SovereignX |
|
| From UNIX |
|
| Setting up the Terminal |
|
| Logging Off |
|
| Remote Printing |
|
| Using a Remote Printer |
|
| Listing Remote Printers |
|
| File Transfer |
|
| Introduction |
|
| Reality Filenames |
|
| UNIX Directory |
|
| Transferring Files |
|
| Reality to UNIX |
|
| UNIX to Reality |
|
| UNIX To UNIX |
|
| UNIX File and Directory Names |
|
| File Transfer Options |
|
| The .sftrc File |
|
| ! Command |
|
| connect Command |
|
| create-file Command |
|
| delete-file Command |
|
| delete-item Command |
|
| disconnect Command |
|
| get Command |
|
| help Command |
|
| put Command |
|
| quit Command |
|
| set Command |
|
| status Command |
|
| Running SFT from a Shell Script |
|
| Remote Shell Command |
|
| The rush Command |
|
| Special Characters |
|
| Special Characters and Shell Variables |
|
| Filename Expansion |
|
| Control Sequences |
|
| Introduction |
|
| Contents |
|
| Related Documents |
|
| Conventions |
|
| Overview |
|
| Product Overview |
|
| Network Types |
|
| UNIX-Connect Facilities |
|
| Remote Logon |
|
| Printing |
|
| Simple File Transfer |
|
| rush |
|
| Network Security |
|
| Time Synchronisation |
|
| Program to Program Communication |
|
| Remote File Access |
|
| UNIX-Connect Administration |
|
| netadmin |
|
| Configuring the Remote Environment |
|
| Printer Administration |
|
| Introduction |
|
| Network Printing Utility |
|
| Overview |
|
| Adding a Network Printer |
|
| Editing a Network Printer Entry |
|
| Listing Network Printers |
|
| Removing A Network Printer |
|
| Setting up Printers on Reality |
|
| Printing to Reality Printers from the Host |
|
| UNIX and Reality Configuration |
|
| Adding a Printer |
|
| Listing Printers |
|
| Removing a Printer |
|
| The ROUTE-FILE |
|
| Introduction |
|
| Network Types |
|
| Network Configuration |
|
| Types of Entry |
|
| ROUTE-FILE Maintenance |
|
| Adding a ROUTE-FILE Entry |
|
| Destination Entries |
|
| Listening Entries |
|
| Q Type Entries |
|
| Reality Entries |
|
| SovereignX Entries |
|
| Alternative Host Entries |
|
| Local Host Entry |
|
| Heartbeat Entries |
|
| Deleting an Entry |
|
| Editing an Entry |
|
| Listing Entries |
|
| Printing an Entry |
|
| Verifying the ROUTE-FILE |
|
| NSAP Format Options |
|
| Connecting to a Heartbeat System |
|
| Session Manager |
|
| Session Manager Menu |
|
| Clearing the Log Files |
|
| Starting the Session Manager |
|
| Stopping the Session Manager |
|
| ROUTE-FILE Listening Entries |
|
| Log Files |
|
| Event Log |
|
| Session Log |
|
| Changing the Session Manager Parameters |
|
| Network Security |
|
| Introduction |
|
| Location-based Security |
|
| PLid Format |
|
| Telnet Security |
|
| User Equivalence |
|
| The PLIDHOSTS File |
|
| USERS-FILE |
|
| USERS-FILE Management |
|
| The XUI User-id |
|
| General Administration Tasks |
|
| Configuring the Remote Environment |
|
| Reality Databases |
|
| SovereignX Environment |
|
| Time Synchronisation |
|
| Environment Variables |
|
| Example Configuration |
|
| The Initial Configuration |
|
| Network Replug |
|
| Remote Reality Database |
|
| Local Reality Database |
|
| Local Loopback |
|
| Local Connection to Reality |
|
| npu Command |
|
| npu Interface Scripts |
|
| External Interfaces |
|
| DataBasic Email API |
|
| EM_DEFINE_CONFIG |
|
| EM_START_EMAIL |
|
| EM_ADD_DELIVERY_DETAILS |
|
| EM_ADD_ATTACHMENT |
|
| EM_ADD_ATTACHMENT_ITEM |
|
| EM_ADD_AUTH_DETAILS |
|
| EM_ADD_HTML_TEXT |
|
| EM_ADD_PLAIN_TEXT |
|
| EM_SEND_EMAIL |
|
| EM_ENABLE_DEBUG |
|
| About this Section |
|
| Contents |
|
| Related Documents |
|
| Conventions |
|
| Overview |
|
| Introduction |
|
| Installation |
|
| Installation Procedure |
|
| Configuration |
|
| Creating a Configuration File |
|
| Default Options |
|
| Connection Details |
|
| Alternative Host Lists |
|
| Debug Options |
|
| Callback Option |
|
| PLId Base Session Numbers |
|
| Example |
|
| Problem Solving |
|
| Error Messages |
|
| Other Problems |
|
| HTML from English |
|
| Writing a Web Page Template |
|
| Writing a Conversion Template |
|
| Introduction |
|
| Related Documents |
|
| Glossary |
|
| Conventions |
|
| Configuring RealWeb |
|
| Connection Parameters |
|
| Persistent Connection Options |
|
| Login, Timeout and Connection Failed Pages |
|
| Setting up RealWeb Users and Accounts |
|
| RealWeb Security |
|
| RealWeb API |
|
| Writing a RealWeb Subroutine |
|
| A First RealWeb Subroutine |
|
| Enabling your RealWeb Subroutine |
|
| Two ways to Build your HTML |
|
| The RealWeb Buffers |
|
| Subroutine Types |
|
| Getting Data from your Database |
|
| Using the Results of TCL Commands |
|
| HTML Tables |
|
| Using HTML Templates |
|
| Using Item Locks with Persistent Connections |
|
| Passing Data to a RealWeb Subroutine |
|
| The Structure of a URL |
|
| Getting the Passed Data |
|
| Passing on Data to another Subroutine |
|
| Notes on using the API Routines |
|
| The aClass Parameter |
|
| Parameter Precedence Rules |
|
| Debugging your RealWeb Subroutines - RW_DEBUG |
|
| Debugging Routines |
|
| RWS_GET_BUF |
|
| RW_SET_BUF |
|
| RW_DISPLAY_PARAMS |
|
| RWA_DISPLAY_PARAMS |
|
| System Routines |
|
| RW_GET_PARAM |
|
| RW_SET_PARAM |
|
| RW_SET_TIMEOUT |
|
| RW_SET_TYPE |
|
| Page |
|
| RW_START_HTML_PAGE |
|
| RW_START_PAGE |
|
| RW_END_PAGE |
|
| Text Structure |
|
| RW_START_DIV |
|
| RW_END_DIV |
|
| RWS_DIV |
|
| RW_START_PARA |
|
| RW_END_PARA |
|
| RWS_PARA |
|
| Text and HTML Insertion |
|
| RW_INSERT_ITEM |
|
| RWA_INSERT_ITEM |
|
| RW_INSERT_CONV_ITEM |
|
| RWA_INSERT_CONV_ITEM |
|
| RW_PUT |
|
| RW_PUT_EX |
|
| RW_NEWLINE |
|
| RW_NEWLINES |
|
| RWA_NEWLINES |
|
| RW_RULE |
|
| RWA_RULE |
|
| RW_IMAGE |
|
| RWA_IMAGE |
|
| RW_BSPACE |
|
| RWA_BSPACE |
|
| RW_HSPACE |
|
| RWA_HSPACE |
|
| RW_VSPACE |
|
| RWA_VSPACE |
|
| Text Formatting |
|
| Character Formatting |
|
| RWS_BOLD |
|
| RWS_COLOR, RWS_COLOUR |
|
| RWS_FONT |
|
| RW_FONT_COLOR, RW_FONT_COLOUR |
|
| RW_FONT_SIZE |
|
| RW_FONT_END |
|
| RWS_ITALIC |
|
| RWS_MONO |
|
| RWS_QUOTE |
|
| RWS_ED_INSERT |
|
| RWS_ED_DELETE |
|
| Paragraph Formatting |
|
| RW_ALIGN |
|
| RWS_BLOCKQUOTE |
|
| RW_CENTER_ON, RW_CENTRE_ON |
|
| RW_CENTER_OFF, RW_CENTRE_OFF |
|
| RWS_CENTER, RWS_CENTRE |
|
| RW_FIXED_ON |
|
| RW_FIXED_OFF |
|
| RWS_FIXED |
|
| RWS_HEADING |
|
| RW_HEADING |
|
| Page Formatting |
|
| RWS_MULTICOL |
|
| RWS_MULTICOL2 |
|
| CSS Styles and Stylesheets |
|
| RWS_STYLE |
|
| RW_IMPORT_STYLESHEET |
|
| RW_LINK_STYLESHEET |
|
| Miscellaneous |
|
| RW_TAG |
|
| RWA_TAG |
|
| RWS_TAG |
|
| RWA_TAG_ATTR |
|
| RW_TAG_ATTR |
|
| RW_TAGA |
|
| RW_TAGL |
|
| Character Translation |
|
| RW_TRANS |
|
| RWS_TRANS |
|
| RW_PUT_TRANSLATED |
|
| Links |
|
| RW_ANCHOR |
|
| RWA_ANCHOR |
|
| RW_IMAGE_ANCHOR |
|
| RWA_IMAGE_ANCHOR |
|
| RW_IMAGE_FUNCTION |
|
| RWA_IMAGE_FUNCTION |
|
| Lists |
|
| RW_START_DLIST |
|
| RW_DLIST_ITEM |
|
| RW_END_DLIST |
|
| RWS_DLIST_DEF |
|
| RWS_DLIST_TERM |
|
| RWS_DLIST |
|
| RW_MAKE_DLIST |
|
| RWA_MAKE_DLIST |
|
| RW_START_DEFINITION |
|
| RW_DEFINITION_ITEM |
|
| RW_END_DEFINITION |
|
| RW_START_ULIST |
|
| RW_END_ULIST |
|
| RWS_ULIST |
|
| RW_MAKE_ULIST |
|
| RWA_MAKE_ULIST |
|
| RW_START_OLIST |
|
| RW_END_OLIST |
|
| RWS_OLIST |
|
| RW_MAKE_OLIST |
|
| RWA_MAKE_OLIST |
|
| RW_START_LIST_ITEM |
|
| RW_END_LIST_ITEM |
|
| RWS_LIST_ITEM |
|
| Forms |
|
| Form Definition |
|
| RW_START_HTML_FORM |
|
| RWS_FORM |
|
| RW_START_FORM |
|
| RW_END_FORM |
|
| Form Elements |
|
| RW_BUTTON |
|
| RWA_BUTTON |
|
| RW_BUTTON_CLICK |
|
| RW_CHECKBOX |
|
| RWA_CHECKBOX |
|
| RW_EDIT_BOX |
|
| RWA_EDIT_BOX |
|
| RW_EDITBOX |
|
| RW_HIDDEN |
|
| RWA_HIDDEN |
|
| RW_IMAGE_BUTTON |
|
| RWA_IMAGE_BUTTON |
|
| RW_IMAGE_FUNCTION |
|
| RWA_IMAGE_FUNCTION |
|
| RWS_LABEL |
|
| RW_SELECT_LIST |
|
| RWA_SELECT_LIST |
|
| RW_LIST |
|
| RW_RADIO |
|
| RWA_RADIO |
|
| RW_RESET |
|
| RWA_RESET |
|
| RW_SUBMIT_BUTTON |
|
| RWA_SUBMIT_BUTTON |
|
| RW_SUBMIT |
|
| RW_TEXT_AREA |
|
| RWA_TEXT_AREA |
|
| Grouping |
|
| RW_START_FIELDSET |
|
| RW_END_FIELDSET |
|
| RWS_FIELDSET |
|
| RWS_LEGEND |
|
| Cookies |
|
| RW_LIST_COOKIES |
|
| RW_SET_COOKIE, RW_SET_COOKIE_IMM |
|
| RW_GET_COOKIE |
|
| Tables |
|
| RW_MAKE_TABLE |
|
| RWA_MAKE_TABLE |
|
| RWS_TABLE |
|
| RWS_TABLE_ROW |
|
| RWS_TABLE_HEADER |
|
| RWS_TABLE_DATA |
|
| RWS_TABLE_CAPTION |
|
| RWA_TABLE_COLGROUP |
|
| RWS_TABLE_HEAD |
|
| RWS_TABLE_BODY |
|
| RWS_TABLE_FOOT |
|
| Frames |
|
| RW_START_FRAMESET |
|
| RW_END_FRAMESET |
|
| RW_FRAME |
|
| RW_IFRAME |
|
| RWS_NOFRAME |
|
| Miscellaneous |
|
| RW_STATUS_SCROLL |
|
| RW_GENTAG |
|
| RWS_GENTAG |
|
| Calling a RealWeb Subroutine |
|
| Overview |
|
| Configuring JavaReal |
|
| Related Documents |
|
| Extending the RSC Class |
|
| Example Subroutine-specific RSC Class |
|
| Calling the Subroutine-specific RSC Class |
|
| Writing Servlets to Access Reality via RealWeb |
|
| Managing Connections |
|
| Constructing a Servlet |
|
| Example Servlet Code |
|
| Description of the Example Servlet |
|
| Properties File |
|
| Debugging |
|
| SQL/JDBC Interface to Reality |
|
| Introduction to the Reality JDBC Driver |
|
| JDBC Interfaces |
|
| RealSQLConnection |
|
| RealSQLDriver |
|
| RealSQLDatabaseMetaData |
|
| RealSQLResultSet |
|
| RealSQLResultSetMetaData |
|
| RealSQLStatement |
|
| Connection Examples |
|
| Example Application Using SQL/JDBC |
|
| Description of the Example Application |
|
| Diagnostics |
|
| JavaDocs |
|
| JavaDocs for JReal Classes |
|
| Class Hierarchy |
|
| DDAConnectionSpec |
|
| DDAMsg |
|
| DDATcp |
|
| DDATest |
|
| Diag |
|
| Fifo |
|
| IniFiles |
|
| ItemView |
|
| Properties |
|
| RealWeb |
|
| RealWebException |
|
| RealWebURL |
|
| RSC |
|
| RSCConnection |
|
| RSCDescriptor |
|
| RSCException |
|
| RSCParam |
|
| RWDatabase |
|
| SNI |
|
| Util |
|
| JavaDocs for Reality SQL/JDBC Classes |
|
| Class Hierarchy |
|
| RealCatalogQuery |
|
| RealCatalogQueryR81 |
|
| RealCatalogQueryR82 |
|
| RealColumnIterator |
|
| RealColumnMetaData |
|
| RealDebug |
|
| RealError |
|
| RealItemTokenizer |
|
| RealMessage |
|
| RealParamData |
|
| RealPrepareCatalogQuery |
|
| RealPrepareSQL |
|
| RealPrepareSQLR81 |
|
| RealPrepareSQLR82 |
|
| RealRowParser |
|
| RealRowTokenizer |
|
| RealServer |
|
| RealSQLArray |
|
| RealSQlBlob |
|
| RealSQLCallableStatement |
|
| RealSQLClob |
|
| RealSQLConnection |
|
| RealSQLDatabaseMetaData |
|
| RealSQLDriver |
|
| RealSQLException |
|
| RealSQLPreparedStatement |
|
| RealSQLRef |
|
| RealSQLResultSet |
|
| RealSQLResultSetMetaData |
|
| RealSQLStatement |
|
| RealSQLWarning |
|
| RealTypes |
|
| VersionInfo |
|
| Glossary |
|
| Remote Basic ActiveX Control |
|
| cNISRbRscLink Class |
|
| cNISRbRscLink Members |
|
| cNISRbRscLink.CallSubroutine Method |
|
| cNISRbRscLink.CloseLink Method |
|
| cNISRbRscLink.OpenLink Method |
|
| cNISRbRscLink Errors |
|
| cNISRbRscLink Examples |
|
| Reality Web Services and RESTful |
|
| Web Services Management Console |
|
| Incoming Web Services |
|
| Creating a Reality Web Service |
|
| Calling Reality Web Services |
|
| Microsoft Office Example |
|
| Microsoft Visual Studio .NET Example |
|
| Microsoft Visual Studio 6.0 Example |
|
| Web Service Licences |
|
| Allocating Licences to Databases |
|
| Web Service Statistics |
|
| realityrest |
|
| RHTTP_RW_RESTFUL Function |
|
| REST_ENABLE Function |
|
| Subroutine annotations |
|
| RW_SET_RESULT Subroutine |
|
| RW_SET_HEADER Subroutine |
|
| RW_RETURN Subroutine |
|
| Outgoing Web Services |
|
| #REALHTTP.USER.DEFS |
|
| RHTTP_SET_DEFAULT Function |
|
| RHTTP_INIT_REQUEST Function |
|
| RHTTP_SET_HEADER Function |
|
| RHTTP_GET_HEADER Function |
|
| RHTTP_GET Function |
|
| RHTTP_POST Function |
|
| RHTTP_SOAP_REQUEST Function |
|
| RHTTP_RETRIEVE Function |
|
| RHTTP_GET_REPLY_HEADER Function |
|
| RHTTP_CLOSE Function |
|
| RHTTP_RESET Function |
|
| RHTTP_BUILD_URL Function |
|
| RHTTP_PARSE_QUERY Function |
|
| RHTTP_PARSE_URL Function |
|
| RHTTP_PATCH Function |
|
| RHTTP_PUT Function |
|
| RHTTP_DELETE Function |
|
| RHTTP_GET_URL Function |
|
| RHTTP_OPTIONS Function |
|
| RHTTP_HEAD Function |
|
| RHTTP_URL_DECODE Function |
|
| RHTTP_URL_ENCODE Function |
|
| Outgoing Web Services - Examples |
|
| XML Support |
|
| XML Extraction |
|
| XML Extraction Examples |
|
| XML.QUERY Subroutine |
|
| XML.INIT Subroutine |
|
| XML.PARSE Subroutine |
|
| XML.PARSE.QUERY Subroutine |
|
| XML.EXTRACT Subroutine |
|
| XML Generation |
|
| XML Generation Examples |
|
| XML.GENERATE Subroutine |
|
| Other Documents |
|
| Differences Documents |
|
| Quick Reference Guides |
|
| MultiValue |
|
| Terminals and Printers |
|