SQLloader

I am really into deep shit and if I cant solve this problem I will have to rebuild all my tables and all ASP pages...puhhhhh...I was hoping that someone outhere could help me with my problem....

I want my control file to look like this:

load data
infile "C:\import\480.swe"
truncate
into table test
when (1:3) = 'D01'
(ID position(15:18),

Name position(23:4))

when (1:3) = 'D02'
(Thelephone position(5:8),

ID position(15:18))

begindata

D01 test test ID23 test test test
D02 test test ID23 test test test
D01 test test ID24 test test test
D02 test test ID24 test test test

I want the sqlloader to insert every row in the same post, like a loop that fetching in every data to the same record. I have tried a lot of diffrent ways but none have worked out. Please.........

kind regardes Joakim Krassman

It would be really nice if you could email me the answer...if there is one...

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 05 1999 - 11:23:02 CET