topic Re: pls explain this steps in Application Development and Automation Discussions

pls explain this steps

Former Member — Tue, 23 Oct 2007 14:59:59 GMT

SELECT SINGLE SUM( seatsocc )

FROM sflight INTO sum

WHERE fldate LIKE '2001%'.

WRITE: / sum.

just explain what is being done in this program thankyou ....

Re: pls explain this steps

Former Member — Tue, 23 Oct 2007 16:29:50 GMT

it is not really a performance topic, but absolute basic ABAP.

It selects from the table sflight all flightdates starting with 2001 and

sums up the seatoccupation.

The SINGLE is not necessary (maybe not even correct).

Siegfried

Re: pls explain this steps

Former Member — Wed, 24 Oct 2007 04:12:49 GMT

yes i know its basic ....i was reading abt how not to use select statement ...it came in this so i happen to ask a doubt....any way thanks for your help...

santo

Re: pls explain this steps

ci985642 — Wed, 24 Oct 2007 22:04:22 GMT

SELECT SINGLE SUM( seatsocc )

FROM sflight INTO sum

WHERE fldate LIKE '2001%'.

WRITE: / sum.

Santosh,

Performance-wise, in this SQL statement, instead of using the LIKE operator, it would be faster to use BETWEEN '20010101' and '20011231'. The LIKE operator, although is robust enough for pattern matching, is generally DB intensive when you use it for non-character type data, like Date, Time, etc. As you can see, in this case the field FLDATE will be a limitation for using the LIKE operator.

Also as the previous suggestion goes, there is a logical bug in using the SINGLE addition to the SQL.

Thanks,

Chaps.