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.