Since your intention is just to have the temptime and totaltime for individual SQL_FILE, you can use arrays instead: (Assuming you are using bash)
Code:
declare -A temptime totaltime
for ((i=1;i<=$no_of_runs;i++))
do
ls *.sql | while read SQL_FILE
do
start=`date +%s`;
db2 -vtf $SQL_FILE > $SQL_FILE.out;
end=`date +%s`;
temptime[$SQL_FILE]=`expr $end - $start`
totaltime[$SQL_FILE]=`expr ${totaltime[$SQL_FILE]} + ${temptime[$SQL_FILE]}`
done
done
2 arrays, temptime and totaltime are declared as associative arrays. So, the array indexes will be the filenames, and the corresponding values will contain the duration taken to execute.(BTW, you do not need expr to do the calculation. Bash can do arithmetic on its own)
Guru.
This User Gave Thanks to guruprasadpr For This Post:
Evening all,
Have been trying to create the following environment variable:
${MD_SYSTEM}_ZZ_EMAIL_SUPPORT="myname@domain.com"
However when the script that contains the above is executed it returns:
ksh: MDQA_ZZ_EMAIL_SUPPORT=myname@domain.com: not found
Is what I'm trying to do... (2 Replies)
Bit of a newbie :D with regard to unix scripting and need some advice. Hopefully someone can help with the following:
I have a predefined set of variables as follows:
AAA_IP_ADD=1.1.1.1
BBB_IP_ADD=2.2.2.2
I have a funnction call which retrieves a value into $SUPPLIER which would be... (3 Replies)
I found one post in another site with a solution for my problem
the below solution should explain what I want.
#!/bin/sh
first="one"
second="two"
third="three"
myvar="first"
echo ${!myvar}
But this gives error 'bad substitution'
System info
SunOS sundev2 5.9... (3 Replies)
Hi all,
I’m very new to UNIX programming. I have a question on dynamic variable
1. I’m having delimited file (only one row). First of all, I want to count number of columns based on delimiter. Then I want to create number of variables equal to number of fields.
Say number of... (5 Replies)
I need some variable help
TEMP1=Jane
TEMP2=Sue
X=1
eval USER=TEMP${X}
echo $USER
This gives output USER1
I would like to get Jane
I have tried
eval USER='TEMP${X}'
eval USER="TEMP${X}"
eval USER=`TEMP${X}` (3 Replies)
Hi guys.
i have a requirment as below.
I have a scripts which perform for loop
for i in /backup/logs -- it will give all the logs file
SC_RIO_RWVM_20120413064217303.LOG
SC_RIO_RWXM_20120413064225493.LOG
SC_RIO_RXXM_20120413064233273.LOG
...
do
open script.sh ---- in this file... (3 Replies)
I have a small program which needs to pass variable dynamically to form the name of a second variable whose value wil be passed on to a third variable.
***************** Program Start ******************
LOC1=/loc1
PAT1IN=/loc2
PAT2IN=/loc3
if ; then
for fpattern in `cat... (5 Replies)
My Code :
--------------------------------------------
#!/bin/bash
for i in `echo server1 server2`
do
eval ${i}_name = "apache"
echo ${i}_name
done
--------------------------------------------
Current output :
>./test.sh
./test.sh: line 5: server1_name: command not found... (3 Replies)
#!/bin/sh
if
then
echo "Insufficient number of arguments ">> error".log" ;
echo "Please check error log for more details";
exit 1 ;
else
file_name=$1".csv";
fi ;
in_par_number=`head -n1 $file_name | sed 's///g' | wc -c`
read -a arr <<< `head -n1 $file_name | sed 's// /g'`
... (6 Replies)
Hello,
I'm trying to build a small script to store a command into a dynamic variable, and I have trouble assigning the variable.
#!/bin/bash
declare -a var1array=("value1" "value2" "value3")
var1arraylength=${#var1array}
for (( i=1; i<${var1arraylength}+1; i++ ));
do
mkdir... (7 Replies)
Discussion started by: alex2005
7 Replies
LEARN ABOUT OPENSOLARIS
let
let(1) User Commands let(1)NAME
let - shell built-in function to evaluate one or more arithmetic expressions
SYNOPSIS
ksh
let arg...
ksh93
let [expr...]
DESCRIPTION
ksh
Each arg is a separate arithmetic expression to be evaluated.
ksh93
let evaluates each expr in the current shell environment as an arithmetic expression using ANSI C syntax. Variables names are shell vari-
ables and they are recursively evaluated as arithmetic expressions to get numerical values. let has been made obsolete by the ((...)) syn-
tax of ksh93(1) which does not require quoting of the operators to pass them as command arguments.
EXIT STATUS
ksh
ksh returns the following exit values:
0 The value of the last expression is non-zero.
1 The value of the last expression is zero.
ksh93
ksh93 returns the following exit values:
0 The last expr evaluates to a non-zero value.
>0 The last expr evaluates to 0 or an error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO ksh(1), ksh93(1), set(1), typeset(1), attributes(5)SunOS 5.11 2 Nov 2007 let(1)