Re: Nesting SQL statements
1999-12-13 08:16:38
Nick,
Maybee I'm off base here but why not just derfine this select as a script and
then run the script in batch?? That's what we do under OS/390 2.5 ADSM 3.1.2.40.
Hope this helps.
Brian
Nick Rutherford <Nick.Rutherford AT HONDA-EU DOT COM> on 12/13/99 08:11:56 AM
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
cc: (bcc: BRIAN NICK/Phoenix Home Life Mutual Insurance)
bcc: BRIAN NICK/Phoenix Home Life Mutual Insurance
Subject: Nesting SQL statements
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.
|
|
|