Shell Programming and Scripting

output="loop.csv"          #Output file
elements=${#currency_pair[@]} # total number of rows in an array
for((i=0;i<$elements;i++)); do
        echo ${currency_pair[${i}]} #debug statement
        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`
        echo "Results is stored as"
        echo $results
done

#!/usr/bin/ksh
echo $* > /tmp/foo
cat - >> /tmp/foo

#!/usr/bin/ksh
echo $* > /tmp/foo
cat - >> /tmp/foo

currency_pair=("${currency_pair[@]}" "RVL EUR-CHF") #array element 1
currency_pair=("${currency_pair[@]}" "RVL EUR-JPY") #array element 2

output="loop.csv"
elements=${#currency_pair[@]}
for((i=0;i<$elements;i++)); do
echo ${currency_pair[${i}]}
results=`xsql -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`
echo "Results is stored as"
echo $results
done

#!/usr/bin/ksh
echo logging args >&2
echo $* > /tmp/foo
echo logging stdin >&2
cat - >> /tmp/foo
echo finished >&2