execute

[Former Member]

1) SELECT * FROM SBOOK INTO SBOOK_WA

UP TO 1 ROWS

WHERE CARRID = 'LH'.

ENDSELECT.

2) SELECT * FROM SBOOK INTO SBOOK_WA

WHERE CARRID = 'LH'.

EXIT.

ENDSELECT.

how above queries will execute.?

[Former Member]

1) will select one row of first record.

2)same as above,will select one record and exit

Regards,

Reema

[Former Member]

i wanna know how execution takes place?

[seshatalpasai_madala]

Hi,

Both will have the same effect. Only difference is in the second case there is one more statement 'EXIT' for the program to excute, where as in the first case its not the case.

Check with this program.

DATA: SBOOk_WA TYPE SBOOK.

SELECT * FROM SBOOK INTO SBOOK_WA

UP TO 1 ROWS

WHERE CARRID = 'LH'.

ENDSELECT.

write: sbook_wa-carrid.

clear: sbook_wa.

SELECT * FROM SBOOK INTO SBOOK_WA

WHERE CARRID = 'LH'.

EXIT.

ENDSELECT.

write: sbook_wa-carrid.

Regards,

Sesh

[Former Member]

when the database is queried in both case.

1)the performance is better as it queries for one record by explicitly saying upto one row

2)It queries randomly and exits the loop.

[seshatalpasai_madala]

Hi,

Both will have the same effect.<b> Only difference is in the second case there is one more statement 'EXIT' for the program to excute, where as in the first case its not the case.</b>

Check with this program.

DATA: SBOOk_WA TYPE SBOOK.

SELECT * FROM SBOOK INTO SBOOK_WA

UP TO 1 ROWS

WHERE CARRID = 'LH'.

ENDSELECT.

write: sbook_wa-carrid.

clear: sbook_wa.

SELECT * FROM SBOOK INTO SBOOK_WA

WHERE CARRID = 'LH'.

EXIT.

ENDSELECT.

write: sbook_wa-carrid.

Regards,

Sesh

[Former Member]

1) SELECT * FROM SBOOK INTO SBOOK_WA

UP TO 1 ROWS

WHERE CARRID = 'LH'.

ENDSELECT

ex

loop at SBOOK INTO SBOOK_WA WHERE CARRID = 'LH'. .

write: SBOOK_WA-CARRID

endloop.

above exp condition ok write carried.