SPL Workstation! Develop, debug, analyze and optimize server-side applications.

SPL Workstation is a visual productivity environment for Informix DBAs and developers. It is utilized in analysis, development, debugging and optimization of Informix server-side applications deployed on any platform. SPL Workstation runs under Windows 95/98 or NT and features the following seamlessly integrated productivity tools: SPL Debugger is the only interactive debugger for Informix database servers' stored procedures and triggers available on the market. It enables you to execute stored procedures and triggers line-by-line, to set breakpoints, to watch and to modify values of variables, etc. SPL Debugger can be invoked from any client application or development tool, such as Visual Basic, PowerBuilder, C++, Informix-4GL, etc. SQL Editor is a powerful full-featured, color-coded editor, customized specifically to support Informix SPL and SQL languages. It provides complete syntax checking without requiring actual code execution on the server and supports nested objects cross-referencing. SQL Editor enables you to apply SPL code templates, to execute individual code statements and to get back multiple result sets. Object Explorer allows you to visually browse database server objects tree, to display objects' properties and to build object dependencies trees. It also gives you ability to customize your workspace by creating virtual project folders to speed up your access to logically grouped database objects. Dependencies Explorer enables you to analyze all complex source and data dependencies of any selected database object with a single click of the mouse. The generated dependencies trees are created to the required levels of nesting and contain all database objects (such as stored procedures, triggers, tables and views) that are dependant on the selected object of interest. Reference Analyzer is a powerful impact and reverse analysis tool, which enables you to determine what effect will changes in one database object will have on other server-side application objects. It performs powerful searches for all references to a specific database object across one or multiple databases. The results of reference analysis return all stored procedures, triggers and views that contain references to the selected object of interest and identify each line of source code where such references were found. You can view and edit any of the found object's references by clicking on its associated line of source code. Data Editor enables you to watch and edit data in database tables and views using a "spreadsheet-style" grid with resizable and movable columns. Data can be visually filtered sorted and exported into a variety of file formats including ASCII, Excel, SQL, etc. Session Browser enables you to browse active server sessions, to get all sessions details, including last SQL statement executed during the session, as well as to set auto-monitoring and logging options. For example, you can set up an option to refresh session information every 3 seconds and log SQL statements executed during the selected session into a text file. Project Folders enable you to logically organize database objects into virtual folders within the Object Explorer. Project Folders can be created with any level of nesting. You can place shortcuts to database objects (such as procedures, triggers, tables and views) into folders. Multiple shortcuts to the same database object can reside in different project folders. For more information and to get your free evaluation copy go to: http://www.agsltd.com Sales Department Advanced Global Systems, Ltd. sales@agsltd.com