SQL*Loader question

From: Roger Palmen <roger_at_il.ft.hse.nl>
Date: 1996/12/03
Message-ID: <581bfv$11n_at_charm.il.ft.hse.nl>#1/1


I have a data-file of which I want to skip the first number. (always 3 characters) terminated by a comma. The first number I want to read into the database starts at position 5. The control file below generates an error on the last column:

invalid number (error in table test, column uvbtemp)

Anybody any idea where this goes wrong? (or does anybody have a better idea on how to skip the first number?)

INTO TABLE test
FIELDS TERMINATED BY ","
(loggeryear position(5) integer external, loggerdate integer external,
..
..

uvbrad decimal external,
uvbtemp decimal external)

Roger Palmen roger_at_il.ft.hse.nl Received on Tue Dec 03 1996 - 00:00:00 CET

Original text of this message