Reply to ADSM V3 on MVS

*** Original Author:  ADSM-L @ MARIST - ** Remote User **; 06/18/98 05:24pm

>Received: from VM.MARIST.EDU by AUDUCADM.DUC.AUBURN.EDU (IBM MVS SMTP V3R1)
>   with TCP; Thu, 18 Jun 98 17:24:30 CDT
>Received: from VM.MARIST.EDU by VM.MARIST.EDU (IBM VM SMTP V2R3)
>   with BSMTP id 3485; Thu, 18 Jun 98 18:19:44 EDT
>Received: from VM.MARIST.EDU (NJE origin LISTSERV@MARIST) by VM.MARIST.EDU
> (LMail V1.2b/1.8b) with BSMTP id 8726; Thu, 18 Jun 1998 18:19:41 -0400
>Received: from VM.MARIST.EDU by VM.MARIST.EDU (LISTSERV release 1.8c) with NJE
>          id 7024 for ADSM-L AT VM.MARIST DOT EDU; Thu, 18 Jun 1998 18:19:38 
> -0400
>Received: from MARIST (NJE origin SMTP@MARIST) by VM.MARIST.EDU (LMail
>          V1.2b/1.8b) with BSMTP id 8712; Thu, 18 Jun 1998 18:19:38 -0400
>Received: from  205.145.64.64  by VM.MARIST.EDU (IBM VM SMTP V2R3) with TCP;
>          Thu, 18 Jun 98 18:19:20 EDT
>Received: from inweb_dmz.humana.com by  205.145.64.64  via smtpd (for
>          vm.marist.edu  148.100.1.2 ) with SMTP; 18 Jun 1998 22:19:47 UT
>Received: from LOUDOM2 by louita1.humana.com via smtpd (for vm.marist.edu
>           148.100.1.2 ) with SMTP; 18 Jun 1998 22:19:47 UT
>Received: by loudom2.humana.com(Lotus SMTP MTA v4.6.1  (569.2 2-6-1998))  id
>          85256627.007A44F9 ; Thu, 18 Jun 1998 18:15:30 -0400
>X-Lotus-FromDomain: HUMANA
>Mime-Version: 1.0
>Content-type: text/plain; charset=us-ascii
>Content-Disposition: inline
>Message-ID:  <86256627.0079CAB4.00 AT loudom2.humana DOT com>
>Date:         Thu, 18 Jun 1998 17:18:36 -0500
>Reply-To:     "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>Sender:       "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>From:         Julie Phinney <jphinney AT HUMANA DOT COM>
>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.