The LL_NAME field is case-sensitive.

For UNIX clients LL_NAME is in mixed case.
Windows clients LL_NAME is in all upper case.

************************************************************************
Wanda Prather
The Johns Hopkins Applied Physics Lab
443-778-8769
wanda_prather AT jhuapl DOT edu

"Intelligence has much less practical application than you'd think" -
Scott Adams/Dilbert
************************************************************************




> -----Original Message-----
> From: Van Ruler, Ruud R SSI-TSEA-332 [SMTP:Ruud.R.vanRuler AT IS.SHELL DOT 
> COM]
> Sent: Wednesday, February 02, 2000 7:27 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      sql
>
> 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
> ================================================================