ADSM-L

Re: Nesting SQL statements

1999-12-13 08:16:38
Subject: Re: Nesting SQL statements
From: Brian Nick <BRIAN_NICK AT PHL DOT COM>
Date: Mon, 13 Dec 1999 08:16:38 -0500
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.
<Prev in Thread] Current Thread [Next in Thread>