topic Re: Which SQL statement bypassess the table buffer? in Application Development and Automation Discussions

Which SQL statement bypassess the table buffer?

Former Member — Thu, 16 Aug 2007 12:08:13 GMT

help me

Former Member — Thu, 16 Aug 2007 12:16:58 GMT

Hi ,

SELECT (column_syntax)

FROM (dbtab_syntax) bypassing buffer

INTO CORRESPONDING FIELDS OF TABLE itab.

Regards

Former Member — Thu, 16 Aug 2007 12:18:40 GMT

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 — Thu, 16 Aug 2007 12:20:06 GMT

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 — Thu, 16 Aug 2007 12:39:56 GMT

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 — Thu, 16 Aug 2007 12:49:00 GMT

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..................