Mainframe considerations - ACEINT utility

 

On the Mainframe, ACEINT executes in BATCH Processing mode only and must be initiated using JCL, examples of which can be found below. Interactive mode is not supported on the mainframe.

SQL statements are input from DD=STDIN. This can be assigned to a PDS Member, a Sequential Dataset, or inline using // DD *.

The output from ACEINT is written to DD=SYSTERM.

 

Example for executing ACEINT using STDIN input only :

//PJ$ACE   JOB  CLASS=G,MSGCLASS=X

/*JOBPARM  LINES=99999

//*

//* Example ACEINT session using STDIN only

//*

//  SET ACELOD=CONNX.LOAD

//*

//ACEINT   EXEC PGM=ACEINT,

//         REGION=0M

//*

//STEPLIB  DD   DISP=SHR,DSN=&ACELOD

//*

//SYSTERM  DD   SYSOUT=*

//SYSUDUMP DD   SYSOUT=*

//STDIN    DD   *

-- Connect to EMPLOYEES

connect to ' DD=EMPLOYEES,GATEWAY=10.20.138.17' 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;

//

In the above example, all SQL statements are input from DD=STDIN.

A CONNECT SQL statement must be supplied as ACEINT is being started without any connection options (-n, -u, [-p])

 

Example for executing ACEINT using PARM and STDIN input :

//PJ$ACE   JOB  CLASS=G,MSGCLASS=X

/*JOBPARM  LINES=99999

//*

//* Example ACEINT session using PARM and STDIN

//*

//  SET ACELOD=CONNX.LOAD

//*

//ACEINT   EXEC PGM=ACEINT,

//         REGION=0M,

//         PARM='-nDD=EMPLOYEES,GATEWAY=10.20.138.17 -uPJ'

//*

//STEPLIB  DD   DISP=SHR,DSN=&ACELOD

//*

//SYSOUT   DD   SYSOUT=*

//SYSPRINT DD   SYSOUT=*

//SYSTERM  DD   SYSOUT=*

//SYSUDUMP DD   SYSOUT=*

//STDIN    DD   *

-- 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;

//

In the above example, the -n, -u, [-p] options have been supplied using // EXEC PARM=. A connection to the requested Server is made immediately. Once a connection has been established, input switches to DD=STDIN, which is then processed statement by statement.

A CONNECT SQL statement is not required as ACEINT is being started with connection options.