loading default value via sql loader

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

never mind. something like this works. the constant keyword filled in the defaults.

infile '/u02/data/emusic/EMUSIC.song_dl_history.00.txt' "str X'02'"
truncate
into table songs
fields TERMINATED BY X'01'
trailing nullcols(
USER_ID,
SONG_ID,
DATE_DOWNLOADED date "yyyy-mm-dd" nullif date_downloaded="0000-00-00",
RIGHT_ID filler,
album_id filler,
created_by constant 1,
created_date sysdate,
updated_by constant 1,
updated_date sysdate)