Shell Programming and Scripting

It's staring me in the face.
This time it is the alias!

You are unwittingly creating variables in your environment from the first run which are available to the second run.

The problem is the "dot-space" in the alias. This causes the script to be executed in the current environment rather than in a clean Shell. It is a useful feature of Shell ... but you don't want to use it here.

Try:

Code:

ts_size='~/util/sql/ts_size.sh'

Hi Methyl,

Sorry, I did not see your post...here is the code as it stands now. I played around with the ` and {} surrounding the variables. But no luck.
As you can see, I have removed the ` and it still behave incorrectly.
My logic for calculating wild is correct as you mention. I am testing if the input has a wild character which in this case is "%". So a non zero value confirms it. Based on that I set = or like.
However, once I use the wild character, it seems to remember it for the next run.

and the alias is defined as:

Code:

> alias|grep -i ts_size
ts_size='. ~/util/sql/.ts_size.sh'

Code:

#!/bin/ksh
#xwhere=" "
#xwild=" "
#wild=" "
if [ $# -eq 1 ]
then
wild=$(echo $1 | awk '{print index($1,"%") }')
# echo $wild
if [ $wild -ne 0 ]
then
xwild="like"
else
xwild="="
fi 
xwhere="where tablespace_name "$xwild" upper('"$1"')"
fi
echo $xwhere
sqlplus -s / <<eof 2>/dev/null
set linesize 120;
set pagesize 1000;
set feedback off;
set echo off;
set heading off;
col tablespace_name forma a30;
select round(sum(bytes/1024/1024/1024),2) as "Gb",' Gb ', tablespace_name from dba_data_files $xwhere group by rollup (tablespace_name) order by 1 asc;
eof

---------- Post updated at 07:16 PM ---------- Previous update was at 07:04 PM ----------

Hi Methyl,

Is there a way to give you multiple thanks...that's it. The alias was the culprit in the end, plus the earlier fixes with spaces etc..

My hats off to you.

Thanks