| external table... [message #214645] |
Wed, 17 January 2007 06:18 |
suvv
Messages: 17
Registered: October 2006
|
Junior Member |
|
|
I can successfully create the external table and read the data.
However I would like to place a header in the spooled file but the only method
I have found to ignore the header is to use the "SKIP" parameter. I would
rather not use this as it hard codes the number of lines I reserve for a
header.
Is there another method to add a comment to a external tables file and have the
selects on the file ignore the comments?
Could I use "LOAD WHEN ( column1 != '--' )" as each comment line begins with a
double dash?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
