SQL loader, skipping records

From: Martin Falck-Hansen <falck_at_tli.de>
Date: Tue, 13 Jul 1999 11:03:18 +0200
Message-ID: <aeDi3.157$Mu.64701_at_news.tli.de>



Hi

I need to read a file with SQL loader. Then file is variable length, records is delimited by a "|", but i dont need all the data only some of the fields from the file .. is there a possiblity to skip these or can you fake a dummy variable where you put all (i tried putting all data into the same logical field .. but this didnt work - it was not allowed)

anybody got an idea ?!?!

regards
Martin Falck Received on Tue Jul 13 1999 - 11:03:18 CEST

Original text of this message