sqlldr question
From: Zhiliang Hu <zhu_at_genomicfx.com>
Date: Wed, 28 Feb 2001 12:25:51 -0600
Message-ID: <3A9D42AF.A38F683C_at_genomicfx.com>
Date: Wed, 28 Feb 2001 12:25:51 -0600
Message-ID: <3A9D42AF.A38F683C_at_genomicfx.com>
How would you include a function like "to_date" using SQL Loader
(sqlldr)?
I tried the following as my control file and it failed. Any suggestion
is
very appreciated!
load data
infile 'proc_data.txt'
badfile 'proc_data.bad'
discardfile 'proc_data.dsc'
append into table genotest
fields terminated by "#" optionally enclosed by '"'
(PPID,
Plate,
location,
Raw1,
Raw2,
Bk_grd,
Read1,
Read2,
to_date ('Date_typed', 'DD-MM-YY'))
Thanks in advance!
Zhiliang Received on Wed Feb 28 2001 - 19:25:51 CET