SQL*Loader question.

Hello everybody.
I am trying to load some data using SQL*Loader. Here is what I am doing.
I have a dimension DAY with day_key column which is PK of this dimension. I want to insert value of PK from DAY for the current date into start_date column in the different table. Let's call it EMP.
The following satement:

    select t.day_pk from day t
    where t.actual_date = TRUNC(SYSDATE);

actual_date holds date in a form of dd/mm/yyyy My control file looks like following:

load data infile 'D:\emp.csv'
into table "EMP"
fields terminated by "," optionally enclosed by '"' TRAILING NULLCOLS
 (emp_wh,
 empt_id,
 description,
 start_date_wh "select t.day_wh from day_dm t where t.actual_date = TRUNC(SYSDATE);"
 )

In the flat file emp.csv I have data for the first 3 columns. When I execute sqldr, I get column START_DATE_WH. ORA-00936: missing expression

Could anybody help me, please?
I appreciate your time and help.
Thanks
Peter. Received on Tue Sep 04 2001 - 19:58:11 CDT