SQL/SPL Editor apps
Posted in 2024
Topics: Stored Procedures & SPL, Triggers, Constraints & Referential Integrity, Migration, Import/Export & Data Conversion
Hi I'm looking for an application on windows for our dev team, which can handle execute SQL, create SPL/triggers, load /unonload data. Bonus if it can open the source text files and login to database from command line. (Because we have to preper our SPL-s source code file before we're creating it in the database.) (like the old SQLEditor from the old time, but with fresh driver ;) ) ------------------------------ Gábor Fekete Software Engineer Capital Systems Budapest ------------------------------
Gábor:
You have several options:
The free version (after the trial license expires) of AGS Server Studio includes an SQL editor and can execute queries. Download from
Server Studio and Sentinel - Advanced DBMS Tools for IBM Informix Data Servers
The engine and CSDK are both delivered with dbaccess which you can copy anywhere you need it, or just install the CSDK wherever you need it.
Informix HQ includes an SQL editor and can execute queries.
The SQuireL SQL Editor can connect to Informix
The RazorSQL SQL Editor can connect to Informix
DBVisualizer supports Informix (commercial)
Most SQL Editors that support ODBC or JDBC connections support Informix
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------