Re: AW: SQL on OS390
2001-07-13 09:31:13
Subject: |
Re: AW: SQL on OS390 |
From: |
Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU> |
Date: |
Fri, 13 Jul 2001 09:19:13 -0400 |
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
|
|
|