What is File-Aid?
Posted: Fri May 10, 2013 11:22 am
File-AID is Compuware's cross-platform file and data management solution. File-Aid is a versatile utility that is basically used for re-formatting data while copying from another data set. As per the Compuware, Compuware's mainframe data management solution File-AID enables developers to focus on their time developing by providing quick and convenient access to the necessary data and files.
I believe, apart from several usage of this utility like copy data sets, concatenate data-sets etc. File-AID can also be used in logical decisioing in Step exections in a Job; e.g. - it can be used to check whether a file is empty or not.
Below is the general structure of File-Aid Batch processing JCL.
General Structure :
File-AID has the support for:
DB2 for z/OS
DB2 UDB
VSAM
IMS
MVS
Oracle
QSAM
SQL server
Sybase
XML
I believe, apart from several usage of this utility like copy data sets, concatenate data-sets etc. File-AID can also be used in logical decisioing in Step exections in a Job; e.g. - it can be used to check whether a file is empty or not.
Below is the general structure of File-Aid Batch processing JCL.
General Structure :
Code: Select all
//STEPNAME EXEC PGM=FILEAID
//DD01 DD DSN=INPUT.FILE,DISP=SHR
//DD01O DD DSN=OUTPUT.FILE,DISP=OLD
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSLIST DD SYSOUT=*
//SYSTOTAL DD SYSOUT=*
//SYSIN DD *
DB2 for z/OS
DB2 UDB
VSAM
IMS
MVS
Oracle
QSAM
SQL server
Sybase
XML