INFO Features

 Overview

INFO is a complete RAD/RDBMS supporting various host file systems such as sequential, fixed length, ISAM and gateways to SQL databases (Oracle, Ingres, Sybase, etc). INFO includes rich browse features for all file types and allows import/export of data in many file and spreadsheet formats.

INFO offers a powerful non-procedural application language of its own, yet when combined with other applications and databases, INFO really shows its strength for data manipulation and analysis. INFO is an excellent tool for isolating data sets to provide immediate response for management decisions. Due to INFO's ability to provide heterogeneous joins, it can, for example, merge data from a COBOL ISAM system to an SQL RDBMS* and produce reports, new datafiles or tables, or data in spreadsheet format. The possibilities are endless.

Based on the concept of file and object directories for each user, INFO provides a friendly interactive command environment for data definition, protection, data entry and update. It offers full screen formatting, data validation, ad hoc query and report writing capabilities. With the full programming language users can combine simple INFO procedures or develop complex menu driven applications.

INFO performs all the relational operations experts demand of a database management system. INFO can easily help reduce your IT department's backlog and provide a quick response to short-term management requests.

Top



 Data Definition

  • Interactive data file definition with password protection to item level.
  • Automatic creation of ISAM files for fast multi-key retrieval on large data sets.
  • Supports popular data types: character, integer, date, leading fill, numeric, binary, floating point, packed decimal, implied decimal, overpunch, trailing sign, long text, Blobs (binary large objects).
  • SQL data types automatically translated *
  • File types - INFO supports file types with fixed and variable length records.
  • ISAM files - INFO supports C-ISAM, DISAM96, VMS RMS ISAM and Primos MIDAS/PLUS indexed files.
  • RDBMS - INFO supports SQL databases.*

Top

 Data Manipulation/Query

  • Relational features: many-to-one, one-to-many and many-to-many; up to 10 files joined at any time; query, display, and updating apply to all items in related (joined) files or tables.
  • English-like query language supports logical operators: lt, ge, gt, eq, cn (contains), nc (not contains), bw (begin with), nb (not begins with) and boolean and/or/xor for record selection. High speed table look-up via binary search or keyed access of ISAM files.
  • Global update of working data set or individual record update with or without screen forms.
  • Data output via list, display and print options that support text and fixed length output formats. Special forms output templates for display and hardcopy.

Top

 Data Entry

  • Data entry via formatted input forms that support range and list checking, table look-up and validation, non-duplication specifier, forced item entry, default values, logical branching, custom error messages, ANSI video attributes.
  • Video attributes - reverse, blink, underline, double high, double wide & color.

Top

 Reporting

  • Powerful report generator for both simple and complex reports.
  • Complex reports include: 5 levels of subtotals and grand total, summary option, new page on subtotal break, multiple lines per record, up to 5 lines of each report titles and column headings.

Top

 Programming

  • Complete application development language with automatic read/write.
  • If..else..endif logic & Do.. Doend loops.
  • One to many keyed related record processing.
  • Internal formatted variables.
  • Array processing.
  • Program chaining and sub-routines trace mode.
  • Pseudo-compiler for fast execution and distribution of run-time object files.
  • Flexible schemes for setting up multi-user applications.
  • Condition handling - all standard break signals handled cleanly with optional user exits.
  • Environment variables - allows use of logicals or environment variables (pathnames etc.).
  • Sort - sort on 16 keys ascending or descending, full file, part file or set.

Top

 Integration

  • Easy integration with word-processing or spreadsheets, either under UNIX or via client/server providing data export to PC workstations.
  • Spooler - supports standard host operating system print options.
  • Text retrieval - full text retrieval extensions. **
  • 3GL interface - call interface from any 3GL such as 'C', COBOL, FORTRAN for embedded applications.
  • Extensible - users can add their own commands.

PC setup

 

 

* INFO-SQL gateway and
** INFO-Text are optional


Top