ESP Workload Automation

 View Only
  • 1.  Accessing the CA7.SASDS Dataset

    Posted Mar 11, 2015 11:35 AM


    Is there documentation on accessing,referencing(layout) of this VSAM file? I looked in the "programmers guide" but it just told about what may be stored in it and the DEFINE of it.

    I know the PROSE information is stored in this dataset and I wasn't sure if there is another way to capture the "description" field listed below or how I would do it.

     

    ------------------------  CA-7 CPU JOB DOCUMENTATION  ----------------------

     

    FUNCTION: REPL      (APPEND,CLEAR,DELETE,EDIT,FE,FETCH,LIST,REPL,SAVE,UPD)

     

     

      

     

    JOB: DOBR14

     

    SYSTEM:

     

     

      

     

      

     

      

     

    DESC: DUMMY TEST JOB                              > LINK:



  • 2.  Re: Accessing the CA7.SASDS Dataset

    Posted Mar 11, 2015 12:04 PM

    There is no 'outside' access to data stored in the SASDS file for releases of CA 7 prior to r12.  The only access if through the LPROS command.  With r12 of CA 7 an SQL can be done against the Datacom/AD database file.



  • 3.  Re: Accessing the CA7.SASDS Dataset

    Posted Mar 11, 2015 12:12 PM

    Not sure but... I don't have access to the program but this program is extracting information - I wanted to write a SAS program to extract data until we convert to r12

     

    S010LPRO   EXEC   PGM=XXXXXXXX,

     

      PARM='UPSI=L'

     

    SASDS      DD     DSN=CA7.SASDS,

     

               DISP=SHR,

     

               AMP=('BUFND=42')

     

    DESC       DD     DSN=XXXXXXXX.PROSE.OUT,

     

               DISP=(NEW,PASS),

     

               UNIT=SYSDA,

     

               DCB=(LRECL=100,BLKSIZE=23400,RECFM=FB),

     

               SPACE=(CYL,(10,2),RLSE)

     

    PRT        DD     SYSOUT=Z

     

    SYSUDUMP   DD     SYSOUT=Z

     

    *

     

    LPROS      DD     DUMMY

     

    FILEOUT    DD     DUMMY

     

    FJOB       DD     DUMMY



  • 4.  Re: Accessing the CA7.SASDS Dataset

    Posted Nov 13, 2018 09:25 AM

    We have SAS programs (running in foreground and background z/OS) that extract from SASDS, SASJOB and VRM under r11.3. Is there any documentation that would help us workout how to connect to CA7 r12 using SAS on the mainframe ?