Section 12.2: afinderr Up Chapter 12: A4GL Utilities Section 12.4: aupscol  

12.3 asql

This is an workalike for Informix’s dbaccess program. Several versions are required depending on the target database :
  1. asql_g.4ae - Generic interface (For ODBC usage)
  2. asql_i.4ae - Compiled using native Informix ESQL/C
  3. asql_p.4ae - Compiled using native Postgres ecpg
When the program starts - you’ll be presented with a menu :
figure asql_1.png
figure asql_query1.png
figure asql_query2.png
The only major difference should be the Utilities menu - this provides access to some features which are present in the Informix isql tool which are not available in the dbaccess tool.
figure asql_util.png

12.3.1 runforms

This is a simple replacement for the sperform Informix utility which allows you to add, update and remove data from a table (or tables) via a simple form interface. runforms is used as the ’Run Form’ option in the asql application.
 Section 12.2: afinderr Up Chapter 12: A4GL Utilities Section 12.4: aupscol