new product announcement : Fortress SQL 1.0

Hi, we at Fortress Software Designs have developed a motif based GUI for informix users out there, if interested, please email at fortress@cerf.net or slow-mail to this address: Fortress Software Designs 4130 La Jolla Village Drive Suite 107-165 La Jolla, CA 92037 (619)492-86100 below is the tech sheet for the product. -------------------------------------------------------------------- FORTRESS SQL 1.0 TECHNICAL SUMMARY - 10/01/1992 ----------------------------------------------- Fortress Software Designs, La Jolla, California. Overview -------- Fortress SQL 1.0 is a graphical front end tool for accessing the Informix database engine. The software consists of an SQL construction front-end, as well as a graphical forms builder. The SQL constructor provides a point-and-click interface for constructing 36 SQL statement types for Informix database creation and maintenance as well as database querying. The output of queries are captured into row by column cells in stand alone dialogs. In this form, the data can be realized into business graphics objects by point and click. The form builder is an object oriented data entry/retrieval form construction tool. The graphical forms created by this tool provides a point-and-click data entry and querying interface that may be run to access any Informix database engine. Resource Requirements and Supported Platforms --------------------------------------------- Hardware: Operating System: Release Date: IBM RS/6000 - AIX 3.2 December 1992 Intel 386 and above - Interactive Unix 3.0 November 1992 SCO Unix 1993 (Q1) Sunsoft Solaris 2.0 1993 (Q1) USL Destiny 1993 (Q1) All platforms require X-Window Release 4 or greater, Motif 1.1 or greater. Informix SE and Online (4.1 and greater) is supported on all platforms. SQL Commands Supported and Description of Implementation -------------------------------------------------------- 1. Alter Index - Point and click selection of index names from Associated list of table names. 2. Alter Table - Point and click selection of table names as well as alter table options on listed columns. 3. Begin Work - Point and click execution. 4. Close Database - Point and click execution. 5. Commit Work - Point and click execution. 6. Create Audit - Keyboard specification of "pathname" for list selection of table name. 7. Create Database - Keyboard specification of new database name and toggle selection of creation options. 8. Create Index - Point and click selection of associated table name and indexing options. Keyboard specification of index name. 9. Create Synonym - Keyboard specification of synonym from list selection of table name. 10. Create Table - Point and click create table options from specified new table name. 11. Create View - Point and click creation of SELECT statement to create a keyboard specified view name. 12. Database - Point and click selection of available databases. 13. Delete - Interactive row by row point and click deletion from tables as well as point and click "where" clause builder for range/criteria deletion. 14. Drop Audit - Point and click selection of table name to drop audit. 15. Drop Database - Point and click selection of available database names to drop. 16. Drop Index - Point and click selection of index name to drop. 17. Drop Synonym - Point and click selection of synonym to drop. 18. Drop Table - Point and click selection of table name to drop. 19. Drop View - Point and click selection of view name to drop. 20. Grant - Point and click selection of user names and privileges. 21. Insert - Point and click selection of table name produces generic form for keyboard entry of data values. 22. Load - Point and click insert statement building for loading flat file with delimiter. 23. Lock Table - Point and click selection of table name and lock table options. 24. Recover Table - Point and click table name selection. 25. Rename Column - Point and click table and column name selection for specified rename. 26. Rename Table - Point and click table name selection. 27. Revoke - Point and click selection of user names and privileges. 28. Rollback Work - Point and click execution. 29. Rollforward - Point and click selection of database name. 30. Select - Point and click construction of columns and tables as well as "where" clause. 31. Set Explain - Point and click selection of options. 32. Set Lock Mode - Point and click selection of options. 33. Set Log - Point and click selection of options. 34. Unload - Point and click selection of options and construction of select statement. 35. Unlock Table - Point and click selection of table name. 36. Update - Interactive row by row point and click update from tables as well as point and click "where" clause builder for range/criteria update. Select Output Description (The Viewport) ---------------------------------------- The output of the select statement is realized in a separate, concurrent resizable/iconable row-column cell based dialog. In this format, the data can be viewed, scrolled vertically and horizontally, and subsequently printed or used to generate pie, line, line fitting, scatter and bar charts. The generated charts in turn, can be printed. This format provides the advantage of encapsulating each select output into its own as a separate object. Other Features (SQL Builder) ---------------------------- 1. Information Dialog - Queries the database system tables on schema descriptions in a separate dialog. 2. Hyper Help - On-line hyper text based help system for SQL syntax reference as well as general help. 3. Perform Monitor - Logs each and every SQL statement as they are executed to verify execution as well as provide a retrievable command history. 4. Run command - executes a shell command in the background or in a self contained window in the foreground. Form Builder Objects Description -------------------------------- 1. Labels - Resizable, movable text and graphic labels. Text format can be specified font types and color. Graphic formats support X bitmap files as well as blob types. 2. Text Fields - Provides data entry field into database table. Control over font, color and size as well as numeric, alpha-only and noentry column attribute checking. 3. Buttons - i) NEXT: brings up next logical record on form. ii) PREVIOUS: brings up pr