topic Re: Regarding select Statement in Application Development and Automation Discussions

Regarding select Statement

Former Member — Thu, 26 Nov 2009 03:44:14 GMT

Dear Friends,

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

Thanks in advance...

Re: Regarding select Statement

Former Member — Thu, 26 Nov 2009 03:57:15 GMT

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

Re: Regarding select Statement

Former Member — Thu, 26 Nov 2009 07:15:35 GMT

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]

Re: Regarding select Statement

former_member156446 — Thu, 26 Nov 2009 07:17:54 GMT

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.