Reply to ADSM V3 on MVS

Thanks, Mike!
---------------------- Forwarded by Julie Phinney/Green Bay/Humana on
06/19/98 03:32 PM ---------------------------
06/19/98 03:32 PM ---------------------------


Mike Stewart <STEWAJM AT AUDUCADM.DUC.AUBURN DOT EDU> on 06/19/98 12:12:00 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Julie Phinney/Green Bay/Humana)
Subject:  Reply to ADSM V3 on MVS



>Subject:      ADSM V3 on MVS
>To:           ADSM-L AT VM.MARIST DOT EDU
>
I have 3 problems trying to issue commands using TSO in a batch job:
1. When I issue the SELECT command with a WHERE clause and the > sign, for
example:
SELECT  VOLUME_NAME from VOLUMES \
WHERE DATE(LAST_WRITE_DATE)  > '1998-06-16'
It gives me an error  Invalid Redirection File, because > is the same sign
used for file redirection.  Does anyone know a way to get around that?

2. When I issue a SELECT command in TSO batch that will be a long time to
execute, ADSM issues the ANR2963W message ("This SQL query may produce a
very large result table...")  and then asks Do you wish to proceed?  many
times, until the job times out.  Does anyone know how to respond to that
message in batch (like adding a /Y  parm in the code)

3. We register nodes using DSMADMC in TSO.  We need to issue SET ACCESS
commands right after.  But those are DSMC commands, so I can't use the TSO
Admin client to issue them.  Does anyone know of a way to Set Access in
TSO?

Thanks for any help!
Julie Phinney
JPHINNEY AT HUMANA DOT COM

*** Comments From: STEWAJM - Stewart, Mike; 06/19/98 07:18am

1. I found that by not leaving any blanks before or after
   the '>' in an sql query the symbol seems to be interpreted
   as a greater than rather than a pipe, for example:

 FROM ADSM.NODES                                                     -
      WHERE NODE_NAME LIKE 'EXP.%'                                   -
            AND                                                      -
               (DAYS(CURRENT_TIMESTAMP)-DAYS(LASTACC_TIME)>180)      -
            AND                                                      -
(DAYS(CURRENT_TIMESTAMP)-DAYS(CAST(SUBSTR(NODE_NAME,5,10)AS DATE))>=180 -
 > 'output.filename'

works for me.

2. I think maybe the -noconfirm option will do what you want, as in:
   CALL 'SYS1.LINKLIB(DSMADMC)' '-ID=xxxxxxx -PASS=xxxxxxx -NOCONFIRM'

3. Sorry; can't help there.