Shell Programming and Scripting

OUTFILE="file${COUNT}_"`echo "$X" | awk -F"\t" '{ print $n }'`"_"`date +%Y%m%d%H%M%S`".txt"

THS_PROF_44083669_20090114111146.txt

THS_PROF_44083455_20090114111146.txt

with their corresponding values i.e

cat THS_PROF_44083669_20090114111146.txt
D|44083669|0192652286|10866|1

cat THS_PROF_44083455_20090114111146.txt
D|44083455|0192300318|10867|1

Apart from these two files im getting 2 another files i.e.

THS_PROF.txt

THS_PROF__20090114111146.txt

cat THS_PROF.txt
SQL>
SQL> select 'D'||'|'||ciam.external_id||'|'||ciem.external_id||'|'||p.element_id||'|'||
  2  case when (p.element_id in (select b.member_id from package_component_members b, package_components c
  3  where member_id in (10867,10866,10866,10867,10868,10866,10866,90014,90021)
  4  and b.member_type=1
  5  and b.component_id in (10459,10458,10658,20105,10499,10647,10810,90014,90022)
  6  and c.component_id=b.component_id)) then '1'
  7  end "A"
  8  from customer_id_acct_map ciam, customer_id_equip_map ciem, product p, cmf c, dual
  9  where ciam.account_no=p.billing_account_no
 10  and ciem.subscr_no=p.parent_subscr_no
 11  and p.billing_account_no=c.account_no
 12  and c.account_no=ciam.account_no
 13  and c.bill_period='G08'
 14  and ciem.external_id_type=1
 15  and ciam.external_id_type=1
 16  and ciem.external_id_type=ciam.external_id_type
 17  and p.element_id in (select b.member_id from package_component_members b, package_components c
 18  where member_id in (10867,10866,10866,10867,10868,10866,10866,90014,90021)
 19  and b.member_type=1
 20  and b.component_id in (10459,10458,10658,20105,10499,10647,10810,90014,90022)
 21  and c.component_id=b.component_id);
D|44083669|0192652286|10866|1
D|44083455|0192300318|10867|1
SQL>
SQL> spool off;

cat THS_PROF__20090114111146.txt
SQL> spool off;