- 论坛徽章:
- 0
|
报错如下 :./gather.sh
: command not found:
0712
: command not found:
./gather.sh: line 87: syntax error near unexpected token `done'
'/gather.sh: line 87: `done<0712_log
代码如下 :
#mon_day=`date +%m%d`
mon_day=0712
#ls sB*.${mon_day} > ${mon_day}_log
echo ${mon_day}
while read str
do
str1=${str}.bad
str2=${str}.log
echo ' LOAD DATA ' >> load_sb.ctl
echo " INFILE '/data1/snapshot_wjjs/${str} ' ">> load_sb.ctl
echo " BADFILE '/data1/snapshot_wjjs/${str1} '">> load_sb.ctl
echo " DISCARDFILE '/data1/snapshot_wjjs/${str2} ' " >>load_sb.ctl
echo " append INTO TABLE "SETT_ORI_B" ">>load_sb.ctl
echo " (TICKET_TYPE POSITION(1:2) char
,
CALLING_AREA_CODE POSITION(3:11) char
,
CALLING_NBR POSITION(12:26) char
,
INTERCONNECT_CODE POSITION(27:35) char
,
CALLED_AREA_CODE POSITION(36:44) char
,
CALLED_NBR POSITION(45:59) char
,
CALLED_NBR_TYPE POSITION(60:60) char
,
START_TIME POSITION(61:74) date "yyyymmddhh24miss"
,
DURATION POSITION(75:80) integer external
,
SETT_DURATION POSITION(81:85) integer external
,
DIRECTION POSITION(86:86) char
,
IN_PARTNER_ID POSITION(87:8 char
,
OUT_PARTNER_ID POSITION(89:90) char
,
OTHER_PARTNER_ID POSITION(91:92) char
,
IN_TRUNK_ID POSITION(93:95) char
,
OUT_TRUNK_ID POSITION(96:9 char
,
SWITCH POSITION(99:101) char
,
FEE_TYPE POSITION(102:102) char
,
ROAM_TYPE POSITION(103:103) char
,
BEAR_SERV_TYPE_ID POSITION(104:105) char
,
SETT_AREA_CODE POSITION(106:109) char
,
FILE_NBR POSITION(110:129) char
,
deal_date POSITION(140:153) date "yyyymmddhh24miss"
,
OWN_AREA_CODE POSITION(144:147) char
,
SETT_RULE_ID POSITION(148:154) char
,
FEE_BASE POSITION(155:161) integer external
,
FEE_LONG POSITION(162:16 integer external
,
FEE_INFO POSITION(169:175) integer external
,
FEE_SUM POSITION(176:182) integer external
,
FEE_INTER1 POSITION(183:189) integer external
,
FEE_INFO2 POSITION(190:196) integer external
,
FEE_LONG2 POSITION(197:203) integer external
,
FEE_INTER2 POSITION(204:210) integer external
,
FEE_LONG3 POSITION(211:217) integer external
,
FEE_SETT POSITION(218:224) integer external
) " >> load_sb.ctl
#done< ${mon_day}_log
done<0712_log |
|