08-16-2007 1:08 PM
08-16-2007 1:39 PM
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.
08-16-2007 1:16 PM
Hi ,
SELECT (column_syntax)
FROM (dbtab_syntax) bypassing buffer
INTO CORRESPONDING FIELDS OF TABLE itab.
Regards
08-16-2007 1:18 PM
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
08-16-2007 1:20 PM
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
08-16-2007 1:39 PM
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.
08-16-2007 1:49 PM
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..................