Search the web
Sign In
New User? Sign Up
toad · Self Help List for TOAD Development Users
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
importing in batch using Toad app   Message List  
Reply | Forward Message #47962 of 49384 |
RE: [toad] importing in batch using Toad app

In the beta, I’m seeing it not display these errors when you run from command line, but unfortunately, it isn’t logging them either (unless you set up the log file option)

 

Next beta will still not show these errors when you run from command line, but will always write them to the app designer error log (in addition to the more detailed import error log, if you configure it)

 

-John

 

 

 

 

From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Melanie Wert Cantrell
Sent: Thursday, July 02, 2009 2:26 PM
To: toad@yahoogroups.com
Subject: [toad] importing in batch using Toad app

 




Hello, all.

I have a Windows batch job that runs a Toad app which does an import from a file into a table. When I run the app interactively, if it encounters an error (e.g. null value for non-null field), I get a dialog window that asks me if I want to continue. If this happens in batch, the app stops and the job continues at the next step. I am logging errors, but the load stops after encountering and logging the first error.

This is the command I'm using

%ToadHome%\Toad.exe -c %DBConn% -a "load temp tables->persons"

Is there something I can add to this that will tell it to continue after encountering an error?

Melanie



Thu Jul 2, 2009 8:44 pm

jdorlon3
Offline Offline
Send Email Send Email

Forward
Message #47962 of 49384 |
Expand Messages Author Sort by Date

Hello, all. I have a Windows batch job that runs a Toad app which does an import from a file into a table. When I run the app interactively, if it encounters...
Melanie Wert Cantrell
melaniewertc...
Offline Send Email
Jul 2, 2009
7:42 pm

I don't think there is, but there should be. I'm working on it. From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Melanie Wert Cantrell ...
John Dorlon
jdorlon3
Offline Send Email
Jul 2, 2009
8:14 pm

In the beta, I'm seeing it not display these errors when you run from command line, but unfortunately, it isn't logging them either (unless you set up the log...
John Dorlon
jdorlon3
Offline Send Email
Jul 2, 2009
8:44 pm

I have the log file option set up. Interactively, it logs the error and prompts me to continue or not. In batch, it logs the error and then stops loading....
Melanie Wert Cantrell
melaniewertc...
Offline Send Email
Jul 7, 2009
10:26 pm

Sorry, there is not. But - you could try the beta. It should work there. :) From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Melanie...
John Dorlon
jdorlon3
Offline Send Email
Jul 8, 2009
1:06 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help