Code analysis using Run with parameter file

Hello all,

I run code analysis using “Run with parameter file” and it does code analysis and generates report for single sql file( I mentioned the path/name of the SQL file in .INI file).

that part works fine…

But my requiremet is : For the above scenerio(ie “Run with parameter file”), if i just specify the folder name in .INI file, it should read all the SQL files and subfolder in that folder and it should the code analysis.

I did follwing changes in INI file:

So I mentioned the folder name like:

[DIR]

DIR1 = D:\VINOD

under VINOD folder there 10 .SQL files…

Above condition does work att all and I tried all permutation and combinations but it did not work.

Please help me How can I overcome this?

I will be waiting for response…

Thanks in advance,

Vinod

Starting with v12, Toad started allowing wildcard. For your situation, simply change the files entry to something like:

[FILES]

FILE1=D:\VINOD*.sql

Hello Sir,

Thank you so much for your inputs.

This allready I have tried and this will not work…its throwing following error and no report being generated.

Failed exception

9/17/2013 5:57:31 PM: Code Analysis1 (Code Analysis) started.

9/17/2013 5:57:31 PM: Start processing Code Analysis Items

9/17/2013 5:57:31 PM: Processing 1 of 1

9/17/2013 5:57:31 PM: Code Analysis1 (Code Analysis) finished.

Please let me know this can be handled

Would not another alternative be to use the Toad app designer’s looping iterator to process all the files in the directory and to call code analysis for each
with just that file name ???

From: vinodkm [mailto:bounce-vinodkm@toadworld.com]

Sent: Tuesday, September 17, 2013 7:32 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code analysis using Run with parameter file

RE: Code analysis using Run with parameter file

Reply by vinodkm

Hello Sir,

Thank you so much for your inputs.

This allready I have tried and this will not work…its throwing following error and no report being generated.

Failed exception

9/17/2013 5:57:31 PM: Code Analysis1 (Code Analysis) started.

9/17/2013 5:57:31 PM: Start processing Code Analysis Items

9/17/2013 5:57:31 PM: Processing 1 of 1

9/17/2013 5:57:31 PM: Code Analysis1 (Code Analysis) finished.

Please let me know this can be handled

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

What version of Toad are you running?

From: vinodkm [mailto:bounce-vinodkm@toadworld.com]

Sent: Tuesday, September 17, 2013 8:32 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code analysis using Run with parameter file

RE: Code analysis using Run with parameter file

Reply by vinodkm

Hello Sir,

Thank you so much for your inputs.

This allready I have tried and this will not work…its throwing following error and no report being generated.

Failed exception

9/17/2013 5:57:31 PM: Code Analysis1 (Code Analysis) started.

9/17/2013 5:57:31 PM: Start processing Code Analysis Items

9/17/2013 5:57:31 PM: Processing 1 of 1

9/17/2013 5:57:31 PM: Code Analysis1 (Code Analysis) finished.

Please let me know this can be handled

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Hello Sir,

Thanks for your inputs…

as I am new to this…Can you please share 1 example…It would be very nice go with that…

Thanks in advance,

Vinod

Hello Sir,

I am using version 11.6

Thanks,

Vinod

If you’re on version 12+, this should work fine. Below is my test example ini file.

[22]

Name=Code Analysis1

Type=Code Analysis

[OPTIONS]

RULESET=C:\Users\admin\AppData\Roaming\Quest Software\Toad for Oracle\12.0\RuleSets\Minimum_20.rst

RSET=Top 20

OUTPUTDIR=c:\output

HTMLFILENAME=CodeAnalysis.html

XMLFILENAME=.xml

METRICHISTORYFILENAME=.xls

XLSFILENAME=.xls

CODEXPERT_SCAN=1

SQL_SCAN=0

PASSWORDS_ENCRYPTED=1

INCLUDE_HTML=1

INCLUDE_XML=0

INCLUDE_XLS=0

INCLUDE_SERVERSIDE_INSERT=0

INCLUDE_METRICS_HISTORY=0

INCLUDE_METRICS_HISTORY_HTML=0

SEND_EMAIL=0

CLEAR_ERROR_LOG=1

SERVERSIDE_INSERT_RUNNAME=AUTOGENERATE

[FILES]

FILE1=C:\test*.sql

and my command line:

toad.exe -a “Code Analysis1 | c:\Code Analysis1.ini”

From: vinodkm [mailto:bounce-vinodkm@toadworld.com]

Sent: Tuesday, September 17, 2013 8:32 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code analysis using Run with parameter file

RE: Code analysis using Run with parameter file

Reply by vinodkm

Hello Sir,

Thank you so much for your inputs.

This allready I have tried and this will not work…its throwing following error and no report being generated.

Failed exception

9/17/2013 5:57:31 PM: Code Analysis1 (Code Analysis) started.

9/17/2013 5:57:31 PM: Start processing Code Analysis Items

9/17/2013 5:57:31 PM: Processing 1 of 1

9/17/2013 5:57:31 PM: Code Analysis1 (Code Analysis) finished.

Please let me know this can be handled

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

This feature wasn’t added until 12.0

Greg

From: vinodkm [mailto:bounce-vinodkm@toadworld.com]

Sent: Tuesday, September 17, 2013 9:33 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code analysis using Run with parameter file

RE: Code analysis using Run with parameter file

Reply by vinodkm

Hello Sir,

I am using version 11.6

Thanks,

Vinod

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

If you got to
www.toadworld.com and do a search on blogs written by various toad experts you will find numerous examples of how to use the toad app designer. Here’s just a few examples of the many such blogs out there on automating
toad use via the app designer. Note that none of these is a simple example o what you want to do – but rather teach you via similar examples so you can do anything you want. So you need to learn and then apply this knowledge to arrive at your desired answer.

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/09/21/task-automation-in-toad-174-saving-you-hours.aspx

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2011/12/06/using-automation-designer-for-everyday-tasks.aspx

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2008/12/05/happy-holidays-a-toad-appsdesigner-app-just-for-you.aspx

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/04/19/automated-toad-db-health-check-via-email.aspx

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/05/03/automated-toad-db-health-check-via-email-part-2.aspx

http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/05/14/quick-intro-to-toad-command-line.aspx

So since he’s on 11.6 then my guess is the only workaround (other than upgrade) is to use the app designer and looping constructs ….

From: Gregory Liss [mailto:bounce-GTDG@toadworld.com]

Sent: Tuesday, September 17, 2013 8:37 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code analysis using Run with parameter file

RE: Code analysis using Run with parameter file

Reply by Gregory Liss

This feature wasn’t added until 12.0

Greg

From: vinodkm [mailto:bounce-vinodkm@toadworld.com]

Sent: Tuesday, September 17, 2013 9:33 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code analysis using Run with parameter file

RE:
Code analysis using Run with parameter file

Reply by vinodkm

Hello Sir,

I am using version 11.6

Thanks,

Vinod

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

The Help file also has several topics with instructions.

This video is linked there:
http://www.youtube.com/watch?v=wH0T6HYXID0&feature=youtu.be

For Help, on the Toad toolbar, go to
Help > Contents.

In Help, on the Contents tab, see
Manage Projects > Automate Tasks and Processes for several topics on using the Automation Designer (app designer).

J

From: Bert Scalzo [mailto:bounce-Bert_Scalzo@toadworld.com]

Sent: September 17, 2013 9:42 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code analysis using Run with parameter file

RE: Code analysis
using Run with parameter file

Reply by Bert Scalzo

If you got to

www.toadworld.com
and do a search on blogs written by various toad experts you will find numerous examples of how to use the toad app designer. Here’s just a few examples of the many such blogs out there on automating toad use via the app designer. Note
that none of these is a simple example o what you want to do – but rather teach you via similar examples so you can do anything you want. So you need to learn and then apply this knowledge to arrive at your desired answer.

http://gyk.r.mailjet.com/redirect/ko7whq8tb07n6wxmqq7gsj/www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/09/21/task-automation-in-toad-174-saving-you-hours.aspx

http://gyk.r.mailjet.com/redirect/khlfhsy083wg177bpqkjfl/www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2011/12/06/using-automation-designer-for-everyday-tasks.aspx

http://gyk.r.mailjet.com/redirect/q2odtj7rlrxm0hvs63oyow/www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2008/12/05/happy-holidays-a-toad-appsdesigner-app-just-for-you.aspx

http://gyk.r.mailjet.com/redirect/qzhxt88vrbx9wytg3vmwj1/www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/04/19/automated-toad-db-health-check-via-email.aspx

http://gyk.r.mailjet.com/redirect/02srt1bwchn1nc4f2hjor1/www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2010/05/03/automated-toad-db-health-check-via-email-part-2.aspx

http://gyk.r.mailjet.com/redirect/qbrbh77wq4s1xqfr9rmz4d/www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/05/14/quick-intro-to-toad-command-line.aspx

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Dear sir,

I installed V12 and I just mentioned

[FILES]

FILE1=C:\test*.sql

in INI file…so now I could able read all the files in a folder…that works fine now…

But the question is:

is it possible to recursive folders in INI file? (it should parse through each subfolder and read the sql file)

Thanks in advance,

Vinod

Have you looked at using the app designer as a front end to feed code analysis – it has directory/folder and file iterators (loops) ???

From: vinodkm [mailto:bounce-vinodkm@toadworld.com]

Sent: Monday, September 23, 2013 8:44 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code analysis using Run with parameter file

RE: Code analysis using Run with parameter file

Reply by vinodkm

Dear sir,

I installed V12 and I just mentioned

[FILES]

FILE1=C:\test*.sql

in INI file…so now I could able read all the files in a folder…that works fine now…

But the question is:

is it possible to recursive folders?

Thanks in advance,

Vinod

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Dear sir,

I tried for that but it does not work for me…

I am not able to read the %loop iterator% variable into code analysis…

Thanks,

No, you need to specify each directory.

You can do this by adding likes like:

FILE2=c:\test\subdir1*.sql

FILE3=c:\test\subdir2*.sql

From: vinodkm [mailto:bounce-vinodkm@toadworld.com]

Sent: Monday, September 23, 2013 9:44 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code analysis using Run with parameter file

RE: Code analysis using Run with parameter file

Reply by vinodkm

Dear sir,

I installed V12 and I just mentioned

[FILES]

FILE1=C:\test*.sql

in INI file…so now I could able read all the files in a folder…that works fine now…

But the question is:

is it possible to recursive folders?

Thanks in advance,

Vinod

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Dear Sir,

Using folder iterator I tried but I am not able to reference the %loop iterator% into code analysis…

But we could able to do it for email sending and all…

is there any way to reference it through? or is through INI file?

I’ll let Greg answer that one ….

From: vinodkm [mailto:bounce-vinodkm@toadworld.com]

Sent: Monday, September 23, 2013 9:05 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Code analysis using Run with parameter file

RE: Code analysis using Run with parameter file

Reply by vinodkm

Dear Sir,

Using folder iterator I tried but I am not able to reference the %loop iterator% into code analysis…

But we could able to do it for email sending and all…

is there any way to reference it through? or is through INI file?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Thank you so much sir…

Dear All,

Can you pl let me know how that can be handled?

Thanks in advance,