ADSM-L

Re: Nesting SQL statements

1999-12-13 16:39:44
Subject: Re: Nesting SQL statements
From: Russell Street <russells AT AUCKLAND.AC DOT NZ>
Date: Tue, 14 Dec 1999 10:39:44 +1300
> 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'


You have to use a macro file.  Put all the statements into a file and
then invoke with

        DSMADMC -ID=xx -PA=yyy macro path-to-file

The command line can only process one command by design.

Russell
<Prev in Thread] Current Thread [Next in Thread>