Skip to Content
avatar image
Former Member

Which SQL statement bypassess the table buffer?

help me

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 16, 2007 at 12: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.

    Add comment
    10|10000 characters needed characters exceeded

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

  • avatar image
    Former Member
    Aug 16, 2007 at 12: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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 12:16 PM

    Hi ,

    SELECT (column_syntax)

    FROM (dbtab_syntax) bypassing buffer

    INTO CORRESPONDING FIELDS OF TABLE itab.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 12: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

    Add comment
    10|10000 characters needed characters exceeded