The utilities
- QINDEX — Data Item Index File Program: builds a file containing data definitions of DMS 1100 database records, SFS/PCIOS data files, BIS RIDs, and RDMS 1100 relational tables.
- QRYSCH — Query Schema Utility: easily display DMS 2200 area, record, and set information useful when developing reorganization routines.
- SCHUTL — Schema Modification Utility: alter a copy of the schema/subschema absolutes to produce faster reloads, avoiding separate schema compiles.
- PBLD / PFIX — Pointer Correction Utilities: replace set pointers, performing old-to-new record location correction.
Database maintenance advantages
- Shorter database unload/reload times
- In-place global pointer changes when expanding the number of allowed areas/pages
- Pointer manipulation capability; ignore set linkages during reload
- Save and restore pointers; cross-reference old record locations to new when correcting pointers
- Significantly reduce production downtime
- Always load database areas in page-number sequence — even CALC
- Easily add new set relationships and new set pointers (owner / prior)
- Isolate reorganizations by area for speed; built-in CALC simulator
- Minimize impact of cross-area designs; easily patch broken links
- Quick reorganizations regardless of hierarchical levels
Application development features
- Select from multiple date formats, including those used in date arithmetic
- Use wildcard characters on IF statement comparisons
- Control case sensitivity on IF statement comparisons
- Command to shift characters to all upper or lower case
- Trim insignificant leading and trailing spaces from data
- Automatic detection of overflow on numeric edit masks
- Built-in CSF command for dynamically assigning and freeing files
- Useful date conversion commands; commands may be abbreviated for quick development
- In-line and procedural DOs for highly structured code
- Easily coded data and variable definitions
Modes of operation
- Input for writing I-QU PLUS-1 programs
- Conversational for browsing files and database structures
- Save programs in object form to secure source code
- Full diagnostics for easy debugging
Supported file types
- SFS 2200 and PCIOS
- DMS 2200
- Direct I/O
- RDMS 2200
- BIS DTM
- SORT
Required software
Any currently supported SBR or supported level of: ASCII COBOL, COMUS, ED, ELT, EXEC, MAP, MSAM, PCIOS, PLUS, SORT, SSG, SYSLIB, UCSRTS.
