load data 
infile '/home/abc.txt'
append 
into table temp
FIELDS TERMINATED BY ":"
TRAILING NULLCOLS
(NAME               "TRIM(:NAME)",
ACC_NBR                "TRIM(:ACC_NBR)",
TAG                    "DECODE(TRIM(:TAG),'1','1','2')",
MONTH_ID               "TRIM(:MONTH_ID)",
CALLS                  CONSTANT   0,
COUNTS                 CONSTANT   0)
每个字段后的双引号内的语句语法是什么样的?还能些什么关键字?