SQL & PL/SQL

Hi,

I have a problem with sql loader. i need to load 5 columns in a table and my file only contains 3 fields (pipe separated file) i need to add a sequenced id and a loading date. When i try to run the below, the sequence and the sysdate is populated correctly, but column3 is inserted into column1. If i add my file two more null columns, then it works properly:

||column1|column2|column3

also if i put my variables in the end it also works, but i cannot restructure the table so this solution doesnt work. Do u have any idea how to specify positions in pipe separated files? i should load file in the below format:

column1|column2|column3
it onlz works properly if i add the two pipe in the beginning

my control file:

LOAD DATA
INFILE 'test201001.csv'
APPEND
INTO TABLE test_load
FIELDS TERMINATED BY '|'
(
id "seq.nextval",
sys_creation_date "sysdate",
column_1,
column_2,
column_3
)

Thanx your help in advance

Edited by: user9013593 on 2010.01.19. 6:18

Edited by: user9013593 on 2010.01.19. 6:19