15 ACE reports
Informix has a set of report utilities which generate, compile, and run ACE reports. The default ACE report looks like this:
DATABASE mydb END
SELECT
col1,
col2,
....
FROM tab1 END
FORMAT EVERY ROW END
Informix source files have the suffix: .ace. The Informix program aceprep compiles source into a binary with suffix .arc. Another program acego runs the binary to produce output.
If you have legacy ACE reports, you may use the Aubit4GL utilities to create 4GL source which you may then compile and run. Aubit4GL provides a set of utilities:
-
generate_aace to create default ACE reports
-
aace workalike for aceprep
-
aace_runner workalike for acego
-
aace_4gl translates .aarc binary to 4GL source
-
aace_perl translates .ace or .aace file to perl (needs report.pm)
generate_aace will produce default Informix-style ACE report for a given database and table. The generated file should be given a .aace or a .ace suffix added to the table name.
generate_aace -d mydb -t agents > agents.aace