Code Inspector with 'SELECT * FROM'

[Former Member]

Hello all,

I want to tell my code inspector, that it shall find

Select * from.

I put it in the ABAP STATEMENT PATTERNS but now the code inspector finds all selects for it interpretates * as wildcard.

What can I do ?

Please help

Simone

[Former Member]

If your intention is to only find those statements in the code you can also use report RPR_ABAP_SOURCE_SCAN and give "Select * from" as a search string and the package or program name.

[Former Member]

Try using single colon before and after to suppress the astrict.

Reward if helpful

Rama C

[ThomasZloch]

déjà vu...

[Former Member]

as you ask this question in the performance forum, I would also like to know why you want to see all 'select *'.

If you want to solve any performance problems then I should say, that it will not help.

Select ' are no real performance issue. Field lists are nice to have, but difference is only considerable, if you reduce the width of the table dramatically, i.e.

it is enough if you check the very width tables.

And please to not introduce new select statements which deviate from others just in the definition of the field list.

The real performance issues are the indexes, or better the selects which have no proper index support.

Siegfried

[Former Member]

Hello,

thanks for all your help.

´For Code Review I develop tools to automate the formal code review. Thanks to your ideas I use a combination of the report and the code inspector. For some cases I created a little report which deals with regular expressions. So now I can do the formal code review in short time and concentrate on better structures and all that other stuff.

Ciaoi

Simone