Sqlldr question
From: Mikael Johansson <mjo_at_algonet.se>
Date: 1996/02/25
Message-ID: <4gq8n2$7l0_at_prometheus.algonet.se>#1/1
1996022014013658511019960320 99
[EOF] execution results in (extract of bad-file): Received on Sun Feb 25 1996 - 00:00:00 CET
Date: 1996/02/25
Message-ID: <4gq8n2$7l0_at_prometheus.algonet.se>#1/1
I would appreciate if anyone could explain why this doesn't work.
Load file looks like this:
load data
infile *
append into table ordque(
time_que position (01:14) date 'YYYYMMDDHH24MISS',
time_que_ms position (15:20) integer external,
time_limit position (21:32) date 'YYYYMMDDHH24MI'
"rpad(:time_limit,12,'0')",
que_no position (33:34) integer external
) begindata
1996022014013658511019960320 99
[EOF] execution results in (extract of bad-file): Received on Sun Feb 25 1996 - 00:00:00 CET
