Toad's automation utility that allows you to easily script database activities and schedule them using the windows scheduler
Questions tagged [toad-scripting]
7 questions
7
votes
1 answer
'DECFLOAT' error in db2
Lookup Error - DB2 Database Error: ERROR [22018] [IBM][DB2/AIX64] SQL0420N Invalid character found in a character string argument of the function "DECFLOAT".
Query-----
SELECT
MSISDN,
CONTRNO,
TRANSDATE,
TARIFF_GROUP,
…
Jabed
- 178
- 1
- 2
- 13
2
votes
1 answer
Invoked Toad and executed query file from command line. Cannot automatically export result dataset
I am trying to automate execution of few TOAD based queries from the Command line. I'm using:
Toad.exe -c schema/pwd@myOracleDB -f C:\temp\sample.sql /exec
On running this, TOAD opens up and the SELECT query in sample.sql is run.
Please suggest…
Somdeb Roy
- 23
- 1
- 4
0
votes
1 answer
Dynamic automation scheduling in Toad
I have been following Stackoverflow for years but posting for the first time. I am trying to dynamically schedule a script in Toad but there doesn't seem to be an option for it. For example, I want to automatically trigger a script on lets say 2nd…
champ7289
- 3
- 1
0
votes
2 answers
How to connect to Oracle DB using Process arguments?
I am new on Oracle and stuck in a problem for almost a week, I am trying to connect to an oracle database through TOAD, i am able to direct login through SID and Service Name using toad Application itself .
But i have a requirement to use a custom…
Mohsin Ali
- 3
- 4
0
votes
0 answers
Toad Automation load all various excel files from a folder
I have to load all excel files into a table.
now the issue I am getting is that the file name is always going to be different no matter what and the same goes for the sheet. Is it possible to setup the toad automation to just load the all excel…
Gilbert V
- 1,050
- 5
- 16
- 43
0
votes
1 answer
Toad data modeler scripting: Entity.Attributes[i].Domain returns undefined
I'm trying to programmatically retrieve the domain of a table's field.
We only use domains in our model, as shown below:
The code is the following:
for (var counterAttr = 0; counterAttr < TableObject.Attributes.Count; counterAttr++)
{
var attr…
Teejay
- 7,210
- 10
- 45
- 76
-1
votes
1 answer
Unit test the Oracle SQL stored procedure in TOAD
I have a complex stored procedure written by someone and I need to understand part of it to check what data it returns. So, started to test it by passing some data in toad. this is an Oracle stored procedure. I get error:
Encountered the symbol…
user3147594
- 61
- 1
- 2
- 14