topic Re: tool development in Application Development and Automation Discussions

tool development

Former Member — Tue, 19 Jun 2007 06:50:49 GMT

hi all,

actually my requiremnet is we r developing a tool for checking all the coding standards of a report program for that first i need to design a flow chart for that standards, how to do it even for a few of them . send me some sample code regarding this

Re: tool development

jaideeps — Mon, 09 Jul 2007 11:33:09 GMT

hi,

you can use MS-visio for these diagrams/flow charts...tell me what exactly you require...

Re: tool development

Former Member — Mon, 09 Jul 2007 13:57:03 GMT

Hi,

1. You identify the rules of your coding standard like.

Select * should not be allowed.

Loop in side loop is not allowed. etc...

2. You have to read all lines of the program using read report statement.

3. Use your logic and validate lines of the program against that logic.

Hope this will help you,

Darshan.

Reward Points to Helpful answer. It motivates us

Re: tool development

Former Member — Tue, 10 Jul 2007 04:07:37 GMT

hi friends.

thanks for your reply. i need other input such as where delete , update ,insert and modify should not be used which will affect the performance.

Re: tool development

Former Member — Tue, 10 Jul 2007 04:08:15 GMT

hi friends.

thanks for your reply. i need other input such as where delete , update ,insert and modify should not be used which will affect the performance.

Re: tool development

Former Member — Tue, 10 Jul 2007 07:17:33 GMT

> hi friends.

> thanks for your reply. i need other input such

> as where delete , update ,insert and modify should

> not be used which will affect the performance.

For Delete, Updae, and other there is no specific rule.

1> dnt use corresponding fields in your select statement

2> move the contents of your intrnal table to work area

3> analyse your code in sm30

4> use for all entries if you think you can change your code

5> if your requiremnet suggest you then use select single or select upto n rows

statement

6> try to use your where clause on primary keys

For performance related standards... visit follwoing site...

/people/rob.burbank/blog/2006/11/16/performance--what-will-kill-you-and-what-will-leave-you-with-only-a-flesh-wound

/people/rob.burbank/blog/2007/03/19/joins-vs-for-all-entries--which-performs-better

http://blogs.ittoolbox.com/sap/db2/archives/for-all-entries-vs-db2-join-8912

Darshan.

Pl. Reward points if this is helpful.