In addition to interactive processing, ACEINT supports batch processing by reading an input file as input and (optionally) writing output to an output file. The following syntax is used to activate batch processing:
Syntax:
ACEINT < input file {>output file}
Example:
ACEINT < employees.sql > employees.log
Example of employees.sql file:
-- Connect to EMPLOYEES connect to EMPLOYEES user PJ; -- Select some columns from EMPLOYEES where NAME = 'SMITH' select PERSONNEL_ID, FIRST_NAME, NAME from EMPLOYEES where NAME = 'SMITH'; -- Disconnect current session from EMPLOYEES disconnect; -- Quit ACEINT quit;
Example of employees.log:
ACEINT - Version 9.00 (Build 07/06/2005) (c) Copyright Software AG, All rights reserved. Tue Jun 07 09:12:10 2005 Adabas SQL Gateway RCI: 1.0.12 -- Connect to EMPLOYEES connect to EMPLOYEES user PJ; User PJ connected to EMPLOYEES. -- Select some columns from EMPLOYEES where NAME = 'SMITH' select PERSONNEL_ID, FIRST_NAME, NAME from EMPLOYEES where NAME = 'SMITH'; PERSONNEL_ID FIRST_NAME NAME ------------ ---------- ---- 40000311 GERHARD SMITH 20009300 SEYMOUR SMITH 20014100 MATILDA SMITH 20015400 ANN SMITH 20018800 TONI SMITH 20023600 MARTIN SMITH 20025200 THOMAS SMITH 20029800 SUNNY SMITH 20000400 MARK SMITH 20001000 LOUISE SMITH 20001900 MAXWELL SMITH 20002300 ELSA SMITH 20003200 CHARLY SMITH 20003900 LEE SMITH 30000001 FRANK SMITH 30000311 GERALD SMITH 30034001 FRANCIS SMITH 30038013 WINSTON SMITH 20000000 JUNE SMITH 19 rows selected. -- Disconnect current session from EMPLOYEES disconnect; Disconnected. -- Quit ACEINT quit; Warning: Uncommitted modifications lost with disconnect.