SQL*LOAD question / Help

This should be fairly easy for regular users of SQL*LOAD. Here is my .ctl file:

load data
infile newdata.dat
append
into table hp_drive_test
fields terminated by ","
 (ser_part_id, prod_tag, fru_ser_seq,
  fru_bld_dt DATE "DD_MON-YY",
  soft_err_tot, tot_def_worst_hd, max_inc_sk_avg,   max_full_sk_avg, avg_sk, npes_nrro, npes_rro,   spinup_time, run_current, row_add_dt ..... problem field)

I want to put the current system date "sysdate" into the field called row_add_dt. How do I tell sql*load this?

I know I can do this -----> row_add_dt constant "08-JUN-93"

BUT, obviously, i don't want to have to do this everytime I load.

Send help to: Jenny_Farnham_at_stortek.com or post to this newsgroup. Thanks! Received on Wed Jun 09 1993 - 00:34:00 CEST