OraFAQ Forum: Client Tools

Home » Other » Client Tools » Automation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Automation [message #503258]

Wed, 13 April 2011 20:45

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!

Report message to a moderator

Re: Automation [message #503259 is a reply to message #503258]

Wed, 13 April 2011 20:51

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Automation [message #503302 is a reply to message #503259]

Thu, 14 April 2011 04:28

Littlefoot
Messages: 21823
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/

Attachment: export_dataset.png
(Size: 28.02KB, Downloaded 2585 times)

Report message to a moderator

Re: Automation [message #503335 is a reply to message #503302]

Thu, 14 April 2011 12:22

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.

Attachment: ToadAutomationIssue1.jpg
(Size: 26.24KB, Downloaded 1293 times)

Report message to a moderator

Re: Automation [message #503336 is a reply to message #503335]

Thu, 14 April 2011 12:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Why is there difference when I schedule it?

different OS environment

Report message to a moderator

Re: Automation [message #503338 is a reply to message #503336]

Thu, 14 April 2011 13:20

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!

Report message to a moderator

Re: Automation [message #503340 is a reply to message #503338]

Thu, 14 April 2011 13:44

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"

Report message to a moderator

Re: Automation [message #503341 is a reply to message #503340]

Thu, 14 April 2011 14:55

Littlefoot
Messages: 21823
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?

Report message to a moderator

Previous Topic:	any audit tool avilable ?
Next Topic:	Toad Code Page Issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 05:45:05 CST 2024