tool development

[Former Member]

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

[jaideeps]

hi,

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

[Former Member]

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.

<i><b>Reward Points to Helpful answer. It motivates us</b></i>

[Former Member]

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.

[Former Member]

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.

[Former Member]

> 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.

<i><b>Pl. Reward points if this is helpful.</b></i>