Re: Need help with SQL*Loader - skipping records

>>>>> "no0one1000" == no0one1000 <no0one1000_at_my-deja.com> writes:

    no0one1000> I know there is a way to skip columns but is there any     no0one1000> way to do an IF statement and skip an entire record?

Yes. If you can guarantee the first N bytes of the header are 'XXX' (and your data will _never_ contain 'XXX' at these positions), then you can use the following in the SQL*Loader control file to ignore the header record.

	LOAD DATA
	TRUNCATE
	INTO TABLE emp
	WHEN (1:3) != 'XXX'
	...

HTH
--
Andy Cowling
Sequent Computer Systems, Weybridge, UK Received on Thu Jun 17 1999 - 02:40:36 CDT