1) my flat file is like such.

id t2_id t_date
1902004-09-13
2952004-09-15

2) table

my_tab
---------------
id numbber
t2_id number
t_date date
created_by number
created_date date

3) i would like to load flat file
while defaulting create_by to 1
and created_date to to_date(20040914,'yyyymmdd')



4) i would like to do something like this(whic doesn't work):

load data
infile '/tmp/flat_file.txt"str X'02'"
append
into table my_tab
fields TERMINATED BY X'01'
trailing nullcols(
id,
t2_id,
t_date,
created_by default 1,
created_date default to_date(20040914,'yyyymmdd'))

thanks