Skip to Content
0
Former Member
Oct 24, 2012 at 08:02 AM

singleselct statement instead of multiple select statements

21 Views

Hi All,

INCLUDE <ICON>.

DATA : DEL_ICON TYPE ICON-ID,
BLNK_ICON TYPE ICON-ID,
ACTV_ICON_G TYPE ICON-ID,
ACTV_ICON_R TYPE ICON-ID,
SHLP_ICON TYPE ICON-ID,
CLEAR_ICON TYPE ICON-ID .


SELECT SINGLE ID INTO ICON-ID FROM ICON WHERE NAME = 'ICON_FENCING'.
CONCATENATE ICON-ID 'Show Additional selection' INTO DY_SEL_ON SEPARATED BY SPACE.
CONCATENATE ICON-ID 'Hide Additional selection' INTO DY_SEL_OF SEPARATED BY SPACE.

SELECT SINGLE ID INTO DEL_ICON FROM ICON WHERE NAME = 'ICON_DELETE'.
SELECT SINGLE ID INTO BLNK_ICON FROM ICON WHERE NAME = 'ICON_HOLD'.
SELECT SINGLE ID INTO ACTV_ICON_G FROM ICON WHERE NAME = 'ICON_LED_GREEN'.
SELECT SINGLE ID INTO ACTV_ICON_R FROM ICON WHERE NAME = 'ICON_LED_RED'.
SELECT SINGLE ID INTO SHLP_ICON FROM ICON WHERE NAME = 'ICON_ENTER_MORE'.
SELECT SINGLE ID INTO CLEAR_ICON FROM ICON WHERE NAME = 'ICON_REFRESH'.

I have to improve the performance of my report. How to write sigle select statement instead of multiple select statements?

Thanks,

Venkata.