ADSM-L

Re: Tapes that a node use

1998-08-03 12:04:24
Subject: Re: Tapes that a node use
From: Andrew Raibeck <storman AT US.IBM DOT COM>
Date: Mon, 3 Aug 1998 12:04:24 -0400
Hello,

SQL string comparisons are done on a byte-for-byte
basis, so they are case sensitive.

Most ADSM constructs are stored in upper case. However,
some elements, like filespace names, volume names,
directories, file names, etc., are case sensitive and
are thus stored accordingly.

If you are not sure of the proper casing to use, you
can convert everything to upper or lower case via the
UCASE or LCASE functions, i.e.:

   select * from volumeusage where lcase(node_name)='rznt01'

or

   select * from volumeusage where ucase(node_name)='RZNT01'

If you aren't sure of the case, use lcase (or ucase) in
front of both expressions, i.e.:

   select * from contents where lcase(file_name) like (lcase('%AndyRaibeck%')

There may be more elegant ways to do this, but this should
work for you.

Regards,

Andy

Andy Raibeck
IBM Storage Systems Division
ADSM Client Development
e-mail: storman AT us.ibm DOT com

Please respond to ADSM-L AT VM.MARIST DOT EDU
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: Re: Tapes that a node use


According to Louie, James:
> Thanks to IBM who supplied me with this answer when I asked the same
> question.
>
> select * from volumeusage where node_name='XXX'
>

  First test:

  adsm> select * from volumeusage where node_name='rznt01'
  ANR2034E SELECT: No match found using this criteria.
  ANS5102I Return code 11.


  Second test:

  adsm> select * from volumeusage where node_name='RZNT01'

  NODE_NAME     COPY_TYPE  FILESPACE_NAME      STGPOOL_NAME        VOLUME_NAME
  ---------     ---------  ------------------  ------------------  -----------
  RZNT01        BACKUP     DOS                 MAGSTART            0000  RZNT01 
       BACKUP     DOS                 MAGSTART            000027


  Question: Why is the input of the node name case sensitive?


-----------------------------------------------------------------------Heinz 
Flemming                             flemming AT rz DOT uni-karlsruhe.deHeinz 
Flemming                             flemming AT rz.uni-karlsruhe DOT de
Computing Center, University of Karlsruhe
Zirkel 2, P.O.Box 6980
D-76128 Karlsruhe
Germany
-----------------------------------------------------------------------
<Prev in Thread] Current Thread [Next in Thread>