JCL for Executing SQL Statements

The following sample is an example of JCL that you can submit to run the SQL statement that discovers the content of the mountpoint table:
ccsm
The following sample is an example of JCL that you can submit to run the SQL statement that discovers the content of the mountpoint table:
//***************************************************************************** //***************************************************************************** //*                                                                           * //*JOBLIB DD DSN=HLQ.CUSLIB replace HLQ with HLQ of your 
CA CSM
 installation  * //*          DSN=HLQ.CAAXLOAD replace HLQ with HLQ of your 
CA CSM
 installation* //*                                                                           * //***************************************************************************** //***************************************************************************** //B2UP     OUTPUT DEST=LOCAL,JESDS=ALL,DEFAULT=Y, //         PAGEDEF=32D3,CHARS=GT20,FORMDEF=P2B111 //JOBLIB   DD DSN=HLQ.CUSLIB, //         DISP=SHR //         DD DSN=HLQ.CAAXLOAD, //         DISP=SHR //         DD DSN=SYSDEV.CCS.LINKLIB, //         DISP=SHR //         DD DSN=CEE.SCEERUN,DISP=SHR //         DD DSN=CEE.AIGZMOD1,DISP=SHR //* //SQLEXEC  EXEC PGM=DBSQLPR, //       PARM='prtWidth=1500,inputWidth=80' //SYSUDUMP DD  SYSOUT=* //SYSPRINT DD  SYSOUT=* //STDERR   DD  SYSOUT=* //STDOUT   DD  SYSOUT=* //OPTIONS  DD  * AUTHID=CASWMGT /* //SYSIN    DD  *    SELECT MP_DATASET    FROM MOUNTPOINT WHERE NOT MP_TYPE='PRODUCT' OR MP_TYPE IS NULL; /*
The following sample is a fragment of output that you receive after submitting the JCL for discovering the content of the mountpoint table:
Command Line Options ____________________ INPUTWIDTH=80 PRTWIDTH=1500 Option File Options ___________________ AUTHID=CASWMGT INPUT STATEMENT: SELECT MP_DATASET    FROM MOUNTPOINT WHERE NOT MP_TYPE='PRODUCT' OR MP_TYPE IS NULL; MP_DATASET VARCHAR(45) ______________________________________________ OMVSUSR.CAMSM.APLROOT OMVSUSR.CAMSM.LJWK OMVSUSR.CAMSM.MSMT1 OMVSUSR.CAMSM.MSMT3 ...
The data sets that are returned after the input statement are the data sets that you have to back up:
OMVSUSR.CAMSM.APLROOT OMVSUSR.CAMSM.LJWK OMVSUSR.CAMSM.MSMT1 OMVSUSR.CAMSM.MSMT3