Home » SQL & PL/SQL » Client Tools » Automation
Automation [message #503258] Wed, 13 April 2011 20:45 Go to next message
captainlaw
Messages: 5
Registered: April 2011
Junior Member
Hello,
I'm using Toad DB2 4.7
In "Toad Automation Script", I'm able to choose "Select to File" in Database Activities and output to a csv file.

However, business process requires TAB Delimited TXT file. I'm NOT able see that in export option or any other activities.

Can someone help me setup automation to TAB file?

Your help is much appreciated!
Re: Automation [message #503259 is a reply to message #503258] Wed, 13 April 2011 20:51 Go to previous messageGo to next message
BlackSwan
Messages: 25797
Registered: January 2009
Location: SoCal
Senior Member
>I'm using Toad DB2 4.7 In "Toad Automation Script", I'm able to choose "Select to File" in Database Activities and output to a csv file.
Those who live by the GUI die by the GUI.

Re: Automation [message #503302 is a reply to message #503259] Thu, 14 April 2011 04:28 Go to previous messageGo to next message
Littlefoot
Messages: 21333
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Another approach, perhaps?

(I'm not sure that it'll work because - I use Oracle version, while yours is DB2 one so options might differ).

In Editor, run the SELECT statement; if what you meant to do was to export the whole table, it would be "SELECT * FROM THAT_TABLE". Otherwise, you'd create any SELECT statement you want (which includes joins etc.).

Now right click the result window and choose "Export dataset" (see the options displayed on the screenshot).

/forum/fa/8884/0/
Re: Automation [message #503335 is a reply to message #503302] Thu, 14 April 2011 12:22 Go to previous messageGo to next message
captainlaw
Messages: 5
Registered: April 2011
Junior Member
Hello,
I'm able to run automation successfully, however, when I schedule it, it DID NOT create the file. I have verified this with two of my automation (.tas) and one is very simple export two rows into a csv file.

Why is there difference when I schedule it? Some additional permission that I need to set it up?

Please see image attached.
Re: Automation [message #503336 is a reply to message #503335] Thu, 14 April 2011 12:25 Go to previous messageGo to next message
BlackSwan
Messages: 25797
Registered: January 2009
Location: SoCal
Senior Member
>Why is there difference when I schedule it?

different OS environment
Re: Automation [message #503338 is a reply to message #503336] Thu, 14 April 2011 13:20 Go to previous messageGo to next message
captainlaw
Messages: 5
Registered: April 2011
Junior Member
Windows Scheduler is on the same box, so not sure what you meant by different OS environment.
Some additional Permission that I need to allow it to run successfully through Windows Scheduler?

Your help is appreciated!
Re: Automation [message #503340 is a reply to message #503338] Thu, 14 April 2011 13:44 Go to previous messageGo to next message
captainlaw
Messages: 5
Registered: April 2011
Junior Member
Here's the command windows scheduler is setup to run:
"C:\Program Files (x86)\ToadDB2\Toad.exe" -batch=true "C:\LAW\Toad\LAWToad.tas"
Re: Automation [message #503341 is a reply to message #503340] Thu, 14 April 2011 14:55 Go to previous message
Littlefoot
Messages: 21333
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Ah! Not sure it is a culprit, but TOAD for Oracle works rather strange (or doesn't work at all) if installed into a directory that contains brackets in it. Therefore, I installed it into C:\TOAD and everything seems to be fine here. Now, as your installation went to "Program Files (x86)", maybe it causes problems, and maybe not. Can't tell for sure. Can you afford reinstalling it?
Previous Topic: any audit tool avilable ?
Next Topic: Toad Code Page Issue
Goto Forum:
  


Current Time: Sun Jan 21 03:44:42 CST 2018

Total time taken to generate the page: 0.07130 seconds