General

  • Relational Data Base
  • Application Builder
  • Internet Enabled
  • SQL
  • ODBC with SQL Server
  • Graphics
  • Spreadsheet Style Interface
  • Platform Interoperability
    • Windows (all PC versions including Windows 10)
    • Linux (Intel)
    • SUN Solaris
    • Mac OS (Intel)
    • Unix (Various)
  • Help
    • Full on-line documentation
    • HTML based
    • Context Sensitive
    • Customisable

Relational Database

  • Data Dictionary
  • Case Structured Option
  • Supports large databases
    • 4095 record types
    • 4095 variables per record
    • 2 billion records a database
  • Supports large disk volumes
  • Multiple Databases
  • Security at record and variable level (31 levels)
  • Dynamic database definition
  • Valid values, Ranges
  • Missing Values
  • Automatic Data Input
  • Data verification
  • Value labels
  • Date and Time Support
  • Table Files
  • Recovery and Journalling
  • Concurrent Update

ODBC

  • Cross Platform SQL Server
  • Windows ODBC Driver
  • 4GL SQL Server Interface
  • 4GL ODBC Interface

Graphics

  • Windows Based
  • 2D and 3D Graphics
  • 35 Built In Formats
  • Analyse variables by categories
  • Produce frequency charts, scatter or line plots and statistics
  • Data in text format for other packages

Spreadsheet

  • Windows Based
  • Display data as spreadsheet
  • Direct access to database for update
  • Use in Application Builder for summary data
  • Save for Excel®

Application Builder

  • Creates portable applications
  • Fourth generation language with full program logic
  • Unlimited size of programs
  • Subroutines
  • Subprocedures
  • Suspend and Execute
  • Graphical user interface builder
  • Dialog and Menu Handling
  • Block Structured
  • Integrated with Database
  • More than 200 built in functions
  • Automatic generation of analyses and reports
  • Report Generator for simple and complex reports
  • File input for text and binary
  • File Output Types include:
    • ASCII
    • Binary
    • CSV
    • DBase®
    • HTML
    • MINITAB®
    • SAS®
    • SPSS®
  • Cross Tabulations
    • Nesting and Concatenation
    • One, two or three dimensions
    • Statistics
    • Quantiles
    • Row and Column Percents
    • HTML tables
  • Data Entry
    • Forms data entry
    • Interactive Update
    • Verification
    • Search
    • Default screens
  • Interface for C and Fortran

Internet Enabled

  • CGI interface from 4GL
  • Direct link to web servers
  • No scripting required
  • HTML output
  • Develop and test locally

SQL

  • Interactive Commands
  • Menu Interface
  • Retrieval, Update and Definition
  • ANSI Standard
  • Integrated with database
SIR Database Software