You need to run a macro.
     //SYSTSIN  DD *
     DSMADMC / -ID=nodename -PASSWORD=password MACRO DD:DD1
     //DD1 DD *
     Q AC BEGIND=10/01/1999 ENDD=10/04/1999 BEGINT=10:00 ENDT=08:30
Jim Sporer



______________________________ Reply Separator _________________________________
Subject: Nesting SQL statements
Author:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>  at IPNET
Date:    12/13/99 1:11 PM


Hello all,
Does anybody know how to nest multiple SQL statements in a batch program running
under MVS.

I am trying to do the following....

DSMADMC -ID=userid -PA=password -
SET SQLDISPLAYMODE WIDE
SELECT FILESPACE_NAME,NODE_NAME,FILE_NAME FROM CONTENTS WHERE
VOLUME_NAME='ES2624'

I am unable to get the second statement processed in batch.
Does anybody know if this is possible
Any help would be appreciated,
thanks in advance,

Nick Rutherford.