ADSM-L

Re: Select for access date

2004-09-01 10:26:31
Subject: Re: Select for access date
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
Date: Wed, 1 Sep 2004 10:26:27 -0400
A suggestion:

I always forget (or mistype) that stgpool_name has to be upper case.
You can make the script bulletproof by using the UPPER function in the WHERE
clause:

... from volumes where stgpool_name=upper('$1') and...

That works whether you type in upper or lower...

<Prev in Thread] Current Thread [Next in Thread>