Shell Programming and Scripting

output="loop.csv"

elements=${#currency_pair[@]}

for((i=0;i<$elements;i++)); do
  echo ${currency_pair[${i}]}
  results=`isql -U$DBLOGIN -P$DBPASSWD -D$DBNAME -b -w 2000 -s',' - o$output <<EOF
 select Code,BidRate,AskRate from FXPoint where RelativeDateType = 1  and
(Code = '${currency_pair[${i}]}')
go
EOF`
done

output="loop.csv"
tempfile="loop.tmp"
>$output
elements=${#currency_pair[@]}

for((i=0;i<$elements;i++)); do
  echo ${currency_pair[${i}]}
  results=`isql -U$DBLOGIN -P$DBPASSWD -D$DBNAME -b -w 2000 -s',' - o$tempfile <<EOF
 select Code,BidRate,AskRate from FXPoint where RelativeDateType = 1  and
(Code = '${currency_pair[${i}]}')
go
EOF`
cat $tempfile >> $output
rm -f $tempfile
done

output="loop.csv"

elements=${#currency_pair[@]}
for((i=0;i<$elements;i++)); do
  if [ "${i}" -eq 0 ]; then
     SELECT="('${currency_pair[${i}]}'"
  else
     SELECT="${SELECT},'${currency_pair[${i}]}'"
  fi
done
SELECT="${SELECT})"

results=`isql -U$DBLOGIN -P$DBPASSWD -D$DBNAME -b -w 2000 -s',' - o$output <<EOF
 select Code,BidRate,AskRate from FXPoint where RelativeDateType = 1  and
 Code in ${SELECT}
go
EOF`