OraFAQ Forum: SQL & PL/SQL » How to ignore Header in the data file while loading through SQL Loader

Home » SQL & PL/SQL » SQL & PL/SQL » How to ignore Header in the data file while loading through SQL Loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to ignore Header in the data file while loading through SQL Loader [message #189675]

Fri, 25 August 2006 09:29

be2sp1
Messages: 52
Registered: September 2005
Location: India

Member

Hi,

I have a control as mentioned below and i want to ignore the Header coming in the data file while loading. The header is coming as 'HDR' in the data file and will be present on top of all the records.

LOAD DATA
-- INFILE './data/QS_STAT_BOOK_EXT.dat'
-- BADFILE './bad/QS_STAT_BOOK_EXT.bad'
-- DISCARDFILE './discarded/QS_STAT_BOOK_EXT.dsc'
TRUNCATE
INTO TABLE QS_STAG_BOOKING_MASTER
FIELDS TERMINATED BY '^' TRAILING NULLCOLS
( BOOKING_ID, BOOKING_NAME)

Thanks

Report message to a moderator

Re: How to ignore Header in the data file while loading through SQL Loader [message #189678 is a reply to message #189675]

Fri, 25 August 2006 09:41

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Use SKIP=1

I hesitate though, you say "present on top of all the records", does that mean it will be in the file ONCE for all the records OR listed before EACH individual record.

[Updated on: Fri, 25 August 2006 09:42]

Report message to a moderator