Home » RDBMS Server » Server Utilities » sqlldr - Skip header in all Infiles
sqlldr - Skip header in all Infiles [message #356395] Thu, 30 October 2008 11:03 Go to next message
Amom
Messages: 3
Registered: October 2008
Junior Member
Hello everyone,

utility: sql loader

Here is my problem:I need to upload data from multiple Infiles into the database table. While doing so, I would like to suppress or skip header line of each file. Is there a similar function to 'skip' or any other way to ignore header from every infile.

Here is my control file:

LOAD DATA
INFILE file1.CSV
......
INFILE file[n].CSV
REPLACE
INTO TABLE CSV_IMPORT
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
( a, b, c)

Thanks a lot

[Updated on: Thu, 30 October 2008 11:05]

Report message to a moderator

Re: sqlldr - Skip header in all Infiles [message #356403 is a reply to message #356395] Thu, 30 October 2008 11:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe SKIP itself?

Regards
Michel
Re: sqlldr - Skip header in all Infiles [message #356406 is a reply to message #356395] Thu, 30 October 2008 11:23 Go to previous messageGo to next message
Amom
Messages: 3
Registered: October 2008
Junior Member
Unfortunately, Skip function is skipping the header in only the first infile and not in the rest Sad
Re: sqlldr - Skip header in all Infiles [message #356412 is a reply to message #356406] Thu, 30 October 2008 11:52 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
I believe you will need to use a separate control file for each infile, in order to skip the header row in each infile.
Re: sqlldr - Skip header in all Infiles [message #356629 is a reply to message #356412] Fri, 31 October 2008 10:20 Go to previous message
Amom
Messages: 3
Registered: October 2008
Junior Member
Thanks - I wanted to avoid that, but looks like that's the only way.
Previous Topic: SQL*Loader-350: Syntax error at line 12
Next Topic: External table
Goto Forum:
  


Current Time: Fri Dec 09 15:52:39 CST 2016

Total time taken to generate the page: 0.16315 seconds