Re: logfile in sqlloader

Sorry it should read the same file. I know that I can specify the log file by saying log=filename.

However, it seems strange that the logfile is not created by default like it is when running from a bat file.

Perhaps it is being created in some other folder but all the likely default folders I look in I dont see it.

On 21 Jun, 20:02, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> colmkav wrote:
> > Could someone explain why when I execure the following command in my
> > VB code I get no log file whereas when I call it within a bin file I
> > get a log file.
>
> > sControlFolder = ""C:\TEMP\"
>
> > SQLLDR EQRISK/eq control=" & sControlFolder &
> > "InstrumentComposition.ctl
>
> > (in the bin file I have)
>
> > sqlldr userid=eqrisk/eq control=instrument.ctl
>
> You have two different control file specified here. Are the contents
> identical? How do they differ with respect to logging?
>
> Cheers,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> d...@nospam.peasland.nethttp://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com
Received on Fri Jun 22 2007 - 01:56:02 CDT