Well, this is a lot closer to what I am looking for.

It almost worked.

Now it gets stuck in a prompt loop:

ANR2963W This SQL query may produce a very large result table .......

Do you wish to proceed? (Yes/No)
Do you wish to proceed? (Yes/No)
Do you wish to proceed? (Yes/No)
......

Is there a way to turn off the prompts ?





Bruno Calce <Bruno.Calce AT BEDAG DOT CH>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
07/13/2001 08:39 AM
Please respond to "ADSM: Dist Stor Manager"

 
        To:     ADSM-L AT VM.MARIST DOT EDU
        cc: 
        Subject:        AW: SQL on OS390


hello,
i guess you have to use QUIT before the "/*".

my job looks like this and it works://S99QBAT JOB  NOTIFY=S99Q

//**********************************************************************
//* EXECUTE ADMIN CLIENT IN BATCH                                      *
//**********************************************************************
//SERVER  EXEC PGM=DSMADMC, 
//            PARM='/-ID=BAT -PA=BATUSER1' 
//SYSPRINT DD SYSOUT=* 
//SYSIN    DD * 
  SELECT MSGNO,MESSAGE,DATE_TIME FROM ACTLOG WHERE - 
         ORIGINATOR='SERVER' AND - 
         (SEVERITY='E' OR SEVERITY='W' OR MSGNO=9999) - 
         AND DATE_TIME>='2001-07-01 00:00:00.000000' 
  QUIT 
//DSCOPT   DD DISP=SHR,DSN=DSM1.ADMIN.OPTIONS 
//DSCLANG  DD DISP=SHR,DSN=SYS1.SANSMSG(ANSMENU) 

regards
bruno