Re: Stupid SQL*Loader tricks

Shaun Mallory (S.mallory_at_ehv.sc.philips.com) wrote:
: Try define the INFILE with a dot at the end. like this
: '/foo/bar/up/detail_xx.'
 

: This is a trick that I have used in the PC environment to do such things
: as save a file without extension in notepad. Who knows it might work in
: your environment.

Shaun

Did try it an sqlload still complains. Thanks for the suggestion

Steve

: Shaun
 

: Steve Emmett wrote:
: >
: > Is there any way to overcome SQL*Loader's need to append a .dat to a file defined in INFILE?
: >
: > As an example, I have a multitude of files of the form detail_xx (WITHOUT any .extension).
: > In my control file I define INFILE = '/foo/bar/up/detail_xx'. When I invoke sqlload, I get
: > an error that there is no file of that name (detail_xx). But, when I append .dat on the end
: > of the detail_xx datafile, sqlload recognizes the INFILE definition.
: >
: > I don't want to append a .dat to every file I need to load just to make sqlload happy - is
: > there anyway to force sqlload to recognize EXACTLY the INFILE definition?
: >
: > TIA
: >
: > Steve
: > --
: > ____________________________________________________
: > Steve J. Emmett semmett_at_patriot.net
: > ::::::::::::::::::::::::::::::::::::::::::::::::::::
: > "A mind that is stretched to a new idea
: > never returns to its original dimension."
: > ----------------------------------------------------

--
____________________________________________________
Steve J. Emmett                  semmett_at_patriot.net
::::::::::::::::::::::::::::::::::::::::::::::::::::
    "A mind that is stretched to a new idea
     never returns to its original dimension."
----------------------------------------------------