Re: difficulty with sqlldr

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Sun, 22 Jul 2001 09:41:18 +0200
Message-ID: <9je00v$2re$1@ctb-nnrp1.saix.net>

"Ed Stevens" <Ed_Stevens_at_nospam.noway.nohow> wrote

> 0,"04-B",20010619,"08.36.53","OFF"
> 1495,"04-B",20010619,"08.37.12","ON "
> 2497,"12-2",20010619,"08.43.52","ON "

> load data
> infile 'test_data.txt'
> discardfile 'c:\_temp\test_discard.txt'
> replace
> into table nmm.eds_test
> fields terminated by "," optionally enclosed by '"'
> (empno,
> dept,
> crte_date "yyyymmdd",
> crte_time "hh24-mi-ss",
> crt_flag)

Don't have the utils manual with me, but try the following:

crte_date DATE "yyyymmdd",
crte_time DATE "hh24.mi.ss",

--
Billy

Received on Sun Jul 22 2001 - 02:41:18 CDT