Re: Nesting SQL statements
1999-12-13 16:39:44
> 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
|
|
|