ADSM-L

Nesting SQL statements

1999-12-13 08:11:56
Subject: Nesting SQL statements
From: Nick Rutherford <Nick.Rutherford AT HONDA-EU DOT COM>
Date: Mon, 13 Dec 1999 13:11:56 +0000
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.
<Prev in Thread] Current Thread [Next in Thread>