FEATURES
Modules
Technical Details
ASP Model
Order
Just The Job
|
Technical Details
Database Details
Main databases supported:
| SQL | Non-SQL |
| INFORMIX-ON Line | ACU COBOL | ASCII |
| INFORMIX-SE | BBX BASIC | Btrieve |
| INFORMIX-Turbo | C-ISAM | Clipper |
| Ingres | C-tree | DataFlex |
| Oracle | DBASE | DBL |
| Progress | Foxbase | Lotus 1-2-3 |
| Sybase | MDBS | Microsoft COBOL |
| VAX Rdb | PCBUS | Softbol |
| VAX RMS | VAX Rdb/VMS (DSRI) |
Plus variants of the above.
We support over 70 file formats in total
Hardware
| MS/ PC-DOS 2.0 or higher | Windows 3.1 |
| UNIX System V.3 and V.4 | SCO Xenix |
| Motif | SCO Unix and variants |
| DEC VAX.VMS 4.5 | Ultrix |
| Data General AOS/VSII | IBM |
| VME/Xetc | DataGeneral |
| HP | ICL |
| Interactive Unix | AT&T |
| DEC | Sequent |
| Bull | Altos |
| Pyramid | UNISYS |
| SUN | All PC-Clones |
Manipulation
- Operations: add, subtract, multiply, divide, move, 18 digit precision in all calculations
- Conditional IF-THEN-ELSE logic
- User-specified scaling of result field, including rounded or truncated
- Data maths (add, subtract)
- SUBSTRING, CONCATENATE, PROMPT, MOVE and INITIALIZE commands to create temporary fields
Sorting
- Numeric, character and date sequencing
- Ascending and descending by field
- Unlimited number of sort fields
- Configurable to generate ORDER BY or to sort outside of database
Search
- All comparison operators: equal, not equal, less, greater, less or equal, greater or equal, range, multiple values
- Numeric, character, date and null comparisons
- Unlimited levels of selection conditions can be combined with ANDIOR using parentheses
- Wild card, Begins with, ends with, contains search capabilities
General
- Full internationalisation (different languages) and localisation support
- Configurable keystrokes
- stored procedures can be run by a batch file, or executed by a user program
- Parameter passing to modify stored procedures
- User prompting for runtime parameters
- User defined editor
- Case sensitive IF/SEARCH
- Number of fields per report: unlimited
- Maximum page width: unlimited
- Maximum page length: unlimited
- Number of control breaks: unlimited
- Maximum file size: unlimited
- Maximum number of records: unlimited
- Maximum number of fields: unlimited
- Maximum numeric field size: 18 digits
- Related files per procedure: Limited only by operating system environment
- Maximum character field size: 9999 bytes
|