Which SQL statement bypassess the table buffer?

[Former Member]

help me

[Former Member]

hi

reward if usefull

Following are the SQL statements which bypass table buffer; avoid these statements when working with buffered tables.

SELECT ... BYPASSING BUFFER.

SELECT from the database views

SELECT ... DISTINCT ... .

SELECT COUNT, SUM, AVG, MIN, MAX.

SELECT ... ORDER BY (other than the primary key)

SELECT ... FOR UPDATE. (EXEC ... ENDEXEC)

Native SQL statements.

[Former Member]

Hi ,

SELECT (column_syntax)

FROM (dbtab_syntax) bypassing buffer

INTO CORRESPONDING FIELDS OF TABLE itab.

Regards

[Former Member]

Hi,

When you are writing the select you need to mention as BYPASSING BUFFER to get the online data from database.

Ex: SELECT MATNR FROM MARA BYPASSING BUFFER INTO TABLE ITAB_MARA.

Regards

Chowdary

[Former Member]

Hi ,

Sample code

data : begin of itab occurs 3 ,

ebeln type ebeln ,

ebelp type ebelp ,

end of itab .

select ebeln

ebelp from

ekpo bypassing buffer

into table itab .

Regards

[Former Member]

hi

reward if usefull

Following are the SQL statements which bypass table buffer; avoid these statements when working with buffered tables.

SELECT ... BYPASSING BUFFER.

SELECT from the database views

SELECT ... DISTINCT ... .

SELECT COUNT, SUM, AVG, MIN, MAX.

SELECT ... ORDER BY (other than the primary key)

SELECT ... FOR UPDATE. (EXEC ... ENDEXEC)

Native SQL statements.

[Former Member]

Naresh r u really satisfying with these type points u r getting

deepthi and rahul also y r u giving points to only naresh

guys please give some value to this great forum..................