buffer

[Former Member]

how to retrive the data from database tables without using buffers?

[Former Member]

Hi Jayasankar,

In SELECT statemant u can add

... BYPASSING BUFFER

Effect

This addition causes the SELECT statement to avoid the SAP buffering and to read directly from the database and not from the buffer on the application server.

or

u have option while creating table wheather to use the buffer or not for that table.

U can find the Buffering option in TECHNICAL SETTINGS of the table

Best regards,

raam

[Former Member]

PARAMETERS: p_cityfr TYPE spfli-cityfrom,

p_cityto TYPE spfli-cityto.

DATA: BEGIN OF wa,

fldate TYPE sflight-fldate,

carrname TYPE scarr-carrname,

connid TYPE spfli-connid,

END OF wa.

DATA itab LIKE SORTED TABLE OF wa

WITH UNIQUE KEY fldate carrname connid.

DATA: column_syntax TYPE string,

dbtab_syntax TYPE string.

column_syntax = `c<sub>carrname p</sub>connid f~fldate`.

dbtab_syntax = `( ( scarr AS c `

& ` INNER JOIN spfli AS p ON p<sub>carrid = c</sub>carrid`

& ` AND p~cityfrom = p_cityfr`

& ` AND p~cityto = p_cityto )`

& ` INNER JOIN sflight AS f ON f<sub>carrid = p</sub>carrid `

& ` AND f<sub>connid = p</sub>connid )`.

SELECT (column_syntax)

FROM (dbtab_syntax)

INTO CORRESPONDING FIELDS OF TABLE itab BYPASSING BUFFER .

LOOP AT itab INTO wa.

WRITE: / wa-fldate, wa-carrname, wa-connid.

ENDLOOP.