Thanks Mary Anne, What I'm looking for is a simple report that shows the APAR number and short description or title.
Charles (Chuck) Hardee Senior Systems Engineer Database Administration Information Technology Services Thermo Fisher Scientific 300 Industry Drive Pittsburgh, PA 15275 Direct: 724-517-2633 FAX: 412-490-9230 [email protected] -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Mary Anne Matyaz Sent: Friday, September 07, 2012 4:33 PM To: [email protected] Subject: Re: Reading the CA MSM database Chuck, Here's one that just does an sql call...what are you looking for? Mary Anne STEP05A EXEC PGM=DBSQLPR, // PARM='PRTWIDTH=1500,INPUTWIDTH=72' //STEPLIB DD DSN=CAMSM.V50.RUN.CUSLIB,DISP=SHR // DD DSN=CAMSM.V50.RUN.CAAXLOAD,DISP=SHR //CXX DD DSN=CAMSM.V50.RUN.CXX,DISP=SHR //SYSUDUMP DD SYSOUT=* //SYSPRINT DD SYSOUT=* //STDERR DD SYSOUT=* //STDOUT DD SYSOUT=* //OPTIONS DD * AUTHID=CASWMGT /* //SYSIN DD * SELECT * FROM MOUNTPOINT; /* It shows you your mountpoints: MOUNTPOINTID, <8>, INT NOT NULL MP_PATH, < /msmserv/mpm/scroot/DatabaseM/CA/MAINTENANCE>, VARC MP_DATASET, < OMVS.CAMSM.MSMT5>, VARCHAR(16/45) MP_TYPE, <*> (NULL), VARCHAR(20) MP_OPTIONS, < ZFS>, VARCHAR(3/2000) MOUNTPOINTID, <9>, INT NOT NULL MP_PATH, < /msmserv/mpm/scroot/DatabaseM/CA/MAINTENANCE/descri MP_DATASET, < OMVS.CAMSM.MSMT6>, VARCHAR(16/45) MP_TYPE, <*> (NULL), VARCHAR(20) MP_OPTIONS, < ZFS>, VARCHAR(3/2000) MOUNTPOINTID, <10>, INT NOT NULL MP_PATH, < /msmserv/mpm/scroot/DatabaseM/CA/MAINTENANCE/CA_1_T 40) MP_DATASET, < OMVS.CAMSM.MSMT7>, VARCHAR(16/45) MP_TYPE, <*> (NULL), VARCHAR(20) MP_OPTIONS, < ZFS>, VARCHAR(3/2000) ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
