Active Query

Product Focus

Create, Maintain and Execute disparate SQL Scripts into a unified central logical unit, a simple drill down tree, with the ability of creating an Active + End User or Active + End User(Adv) application at anytime with a single click.

Product Description

Active Script Manager provides a simple drill down tree interface for maintaining SQL scripts. The user can create, delete, edit and execute the scripts with a simple right click.

A wizard allows the user to inventory all existing scripts into the drill down by rapidly creating file associations. Once the drill down tree is ready with all the scripts, the user can easily create Active+EndUser and Active+EndUser(Adv) applications with a single click.

Product Architecture

The solution architecture is highly scalable. It can support hundreds of users and thousands of devices. It has multiple options to support active-active or active-passive architectures.

  • Database Compatibility:

    Oracle

    SQL Server

    DB2

  • Operating System Compatibility:

    Windows95/98/ME

    WindowsNT/2000 client connecting to ANY Database on the corporate network

  • Technical Requirements:

    Pentium 100MHz or higher

    10MB hard disk space

    64 MB RAM (128 MB recommended).

Benefits

  • Organize all your existing SQL scripts into categories and items in a drill down tree.
  • Maintain and Execute the SQL scripts.
  • View the results in a rich output window with reporting and color visual filters.
  • Create Active+EndUser and Active+EndUser(Adv) applications.
  • Create multiple functional views on the same set of operating system files, organized by project, by date, by user, or other such categories.

Application Area

  • Get all SQL files organized.
  • When SQL files are stored in several computers and locations, it is useful to bring all the SQL files into a single logical collection, an ASM file.
  • For creating end user applications (Active+EndUser and Active+EndUser(Adv)).