My boss is wanting reports on jobs run and jobs that have errors but he want's it in csv mode. Anyone have any ideas or ways that this can be done?
that would be wonderful to download it straight from mainframe as a CSV report. I have V11.3 of CA7 and it does not, so what I do is to run a report to a flat file on the mainframe, then run that file through file/aid or File Manager to strip out the report headings. Then transfer the mainframe file to my PC as TXT and then import that file into formatted Excel.
May have to clean up the lines or headers a little but once you have it, you that then incorporate the CA7 job and File Manager into one job and then email the file to you as a TXT.
Please open this a an idea (enhancement) so product management can review and consider.
Says we can with R12 and SQL reporting
Thanks Phon.... I see it says delivered but I'm not seeing anything in documentation on HOW to do it. We have r12 and I've done a search of the documentation. Roderick_Woods
CA 7 r12 and sql didn't cross my mind. Thanks Phon for waking me up. I have some jcl that executes DBSQLPR and creates an output csv file. Let me massage it and I will post it.
Indeed DBSQLPR can easily create CSV files that you can then email or FTP to your workstation and open in Excel.
However CA Datacom/AD also includes the Datacom/Server component (at no extra cost). So you can define a read-only Datacom/Server started task, and then connect directly from Excel (or any other ODBC/JDBC tool) to the CA 7 repository tables in Datacom/AD. That's what we do.
Thanks OwenWilliams once I get going on this your idea might be useful also. Right now I'm trying to get csv files for a different department and I'm not sure if we would have them connect to our database.
I was going to post the jcl here, but that is to much trouble :-) ...
Go to the CAL2JCL library and there is a member called AL2SQL. You would specify OPT=C to read in member (AL2SOPTC) from the CAL2OPTN dataset. This member has the options for creating CSV file. You also need to override the STDOUT DD SYSOUT=* to point to a dataset set. I used the following DCB for my STDOUT:
//STDOUT DD DSN=RODERICK.TEST.CSV,DISP=(NEW,CATLG,DELETE),// UNIT=SYSDA,SPACE=(TRK,(5,5)), // DCB=(RECFM=VB,LRECL=32756,BLKSIZE=32760)