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