Antoine,
I saw an interesting application named PDQout which appears to build
sqlloader control files and it might be helpful for this situation. You
might try the demo at:
http://www.oriolecorp.com/frameindexPD.html
David Simpson
www.dotcomsolutionsinc.net
"Antoine Tissier" <nospam_at_nospam.net> wrote in message
news:20020707.112757.213975407.10866_at_nospam.net...
> Hi,
>
> I d like to load a table with sqlloader.
>
> The file has a header and a footpage.
>
> So, what i am looking for is a thing like
>
> DEFAULTIF
> DO NOTHING
>
> I managed to write the when statement that checks if is the body,
> the footpage or the header. But i do not know how to ask him to do
> nothing.
>
> Obviously, if i only write the when statement for the body, the exit code
> won't be zero, and i need to know if the load has been successful.
>
> Thx in advance
> Antoine
Received on Mon Jul 08 2002 - 10:46:48 CDT
