ADSM-L

sql

2000-02-02 07:26:58
Subject: sql
From: "Van Ruler, Ruud R SSI-TSEA-332" <Ruud.R.vanRuler AT IS.SHELL DOT COM>
Date: Wed, 2 Feb 2000 13:26:58 +0100
Hi  gurus

Could you explain the following:

SELECT LL_NAME,STATE -
     FROM BACKUPS -
     WHERE NODE_NAME = 'EUCP01' -
     GROUP BY LL_NAME,STATE

part of the result of select:
0012_vxdmp.7               ACTIVE_VERSION
0013_vxedit.1m             ACTIVE_VERSION
0014_vxencap.1m            ACTIVE_VERSION
0015.sun.env               ACTIVE_VERSION


 SELECT * FROM BACKUPS -
 WHERE NODE_NAME='EUCP01' AND -
 LL_NAME='0012_VXDMP.7'

result of select:
ANR2034E SELECT: No match found using this criteria.


=======================================================
             Ruud van Ruler
Shell Services International BV - ISES/32
Our Data Storage Management home page: http://sww2.shell.com/dstorage/
> Room 2A/D07
> Dokter van Zeelandstraat 1, 2285 BD Leidschendam NL
Tel : 070 - 3034644  /  Fax : 070 - 3034012
Email Internet: ruud.r.vanruler AT is.shell DOT com
                          r_van_ruler AT compuserve DOT com
Email X400:/S=vanRuler /I=R /C=GB /A=GOLD /P=Shell /O=IS


                                                            R.vanRuler
================================================================
<Prev in Thread] Current Thread [Next in Thread>
  • sql, Van Ruler, Ruud R SSI-TSEA-332 <=