Looking today at week-over-week shares outstanding changes among the universe of ETFs covered at ETF Channel, one standout is the Vanguard Industrials ETF (AMEX: VIS) where we have detected an approximate $24.0 million dollar outflow — that’s a 3.2% decrease week over week (from 9,314,450 to 9,014,450). Among the largest underlying components of VIS, in trading today United Technologies Corp. (NYSE: UTX) is off about 0.4%, Danaher Corp. (NYSE: DHR) is off about 0.3%, and Precision Castparts Corp. (NYSE: PCP) is lower by about 0.8%. For a complete list of holdings, visit the VIS Holdings page ยป …read more
Source: FULL ARTICLE at Forbes Markets
Tag Archives: VIS
Store results in table
By Rami Reddy
Hello everyone,
I have a shell script, which connects to the database and runs .sql file.
after executing of .sql file, i need to store the results in error table.
How can i achieve this one? could you please give your suggestions.
here is my code.
#!/bin/sh
#set -vx
SCHEMA_NAME=$1
LOG="/db01/apps/applvis/VIS/apps/apps_st/appl/xxhex/12.0.0/sql/test1.log_rundate_`date +%Y%m%d`.`date +%H%M%S`"
echo ' '>>$LOG
echo 'start sqlplus .sql '>>$LOG
date >>$LOG
sqlplus apps/apps@VIS @/db01/apps/applvis/VIS/apps/apps_st/appl/xxhex/12.0.0/sql/test1.sql ${SCHEMA_NAME} 1>>$LOG
EXIT_CODE=$?
if [$EXIT_CODE = 0]
then
echo "Program successfull" >>$LOG
echo '<<>$LOG
date >>$LOG
else
echo "ERROR Program did not successfully execute " >> $LOG
echo "EXIT CODE = $EXIT_CODE"
date >>$LOG
exit 1
fi
echo ' ' >>$LOG
echo 'end sqlplus .sql ' >>$LOG
echo ' ' >>$LOG
Thanks,
Rami Reddy
…read more
Source: FULL ARTICLE at The UNIX and Linux Forums