SELECT 'PX' where SYM='NG' AND CME_NYMEX_FUTURES.CONTRACT_MONTH = '6' andCME_NYMEX_FUTURES.CONTRACT_YEAR = '2013'
and OPR_DATE=(select opr_date FROM CME_NYMEX_FUTURES whereSYM='NG'
SET FEED OFF SET VERIFY OFF SET HEAD OFF
select 'echo -en '||cme.BODY||' | mailx -s '||cme.SUBJECT ||' -a "$HTMLFILE"'||decode(MAIL_FROM,null,'',' -r "<' ||MAIL_FROM||'