END {    srand();    CHARGE_FEE="charge_fee.ctl";    printf("load data\ninfile *\nappend\ninto table charge_fee\nfields terminated by '|'\n(\n\tfee_id\t\tinteger external,\n\tcreate_ts\tdate(14) 'YYYYMMDDHH24MISS',\n\tupdate_ts\tdate(14) 'YYYYMMDDHH24MISS',\n\tstatus\t\tchar(1),\n\tfee_month\t\tchar(6),\n\tuser_nm\t\tchar(20),\n\tcharge_dt\tchar(8)\n)\nbegindata\n") > CHARGE_FEE;    CHARGE_FEE_DTL="charge_fee_dtl.ctl";    printf("load data\ninfile *\nappend\ninto table charge_fee_dtl\nfields terminated by '|'\n(\n\tfee_id\t\tinteger external,\n\tfee_type\tchar(2),\n\tfee_at\t\tinteger external\n)\nbegindata\n") > CHARGE_FEE_DTL;    for(fee_sq=1; fee_sq<=1000000; fee_sq++)    {        printf("%07d|20010101000000|20010101000000|1|200201|test%04d|19700101\n", fee_sq, int(rand()*10000)) >> CHARGE_FEE;        for(i=0; i<5; i++)  a_fee_type[i]=0;        i=0;        while(i<5)        {            value=int(rand()*10)+1;            repeat=0;            for(j=0; j<i; j++)            {                if(a_fee_type[j]==value)                {                    repeat=1;                    break;                }            }            if(!repeat)            {                a_fee_type[i++]=value;            }        }        for(i=0; i<5; i++)        {            printf("%07d|%02d|%012.0lf\n", fee_sq, a_fee_type[i], rand()*1000000) >> CHARGE_FEE_DTL;        }    }    CHARGE_FEE_CFG="charge_fee_cfg.ctl";    printf("load data\ninfile *\nappend\ninto table charge_fee_cfg\nfields terminated by '|'\n(\n\tfee_type\tchar(2),\n\tfee_nm\t\tchar(10)\n)\nbegindata\n") > CHARGE_FEE_CFG;    printf("01|市話\n02|長話\n03|國際\n04|異地漫游\n05|來電顯示\n06|來電轉移\n07|WAP服務\n08|語音信箱\n09|語音增強\n10|多方通話\n") >> CHARGE_FEE_CFG;}