Regarding select Statement

[Former Member]

Dear Friends,

How to fetch data from data base table directly instead of table buffer.Plz give me one example.

Thanks in advance...

[Former Member]

In SE38,Press F1 on BYPASSING BUFFER.You have to use this with select clause.

Edited by: Harsh Bhalla on Nov 26, 2009 9:31 AM

[Former Member]

This is the syntax that incorporates bypassing buffer addition, in order to read data directly from database

Select... FROM { {dbtab [AS tabalias]}

| join

| {(dbtab_syntax) [AS tabalias]} }

[UP TO n ROWS]

[CLIENT SPECIFIED]

[BYPASSING BUFFER]

[former_member156446]

the advantage of using buffer tables ( transparent tables) is the concept of buffer why do you want to not select using buffer... if you by pass buffer the load might be higher on database... make sure you know what you are doing.