Re: Monitoring SQLLDR

Dear D.

I don't know what your scripting language is, but I myself use Access 97 VBA. I wrote a utility function called synchShell to replace the original shell, which use WIN32 API function to check the termination of the spawned process. You can easily find that information on www.microsoft.com/search with 'shell' keyword or something.

Moreover, the bad file (and discard file) generated by sqlldr.exe can be used to check the result.

Dino

On Mon, 15 Oct 2001 23:10:34 GMT, dsmcd <dsmcd_at_uswestmail.net> wrote:

>Hello...
>
>For my Sqlldr, I'm using my front-end to call
>the batch script which calls the control file. I
>would like my front-end to know that the
>import is done before going to the next statement.
>
>But, since the download uses cmd.exe, my
>front-end cannot tell when it's done (i.e.,
>cmd.exe is closed).
>
>Has anyone here worked around this issue? Did
>you're control file returned a value to the front-end
>when the cmd.exe closed? Some other solution?
>
>Any suggestions would be appreciated.
>
>Thx,
>D.
Received on Tue Oct 16 2001 - 08:37:43 CDT