topic Re: buffer in Application Development and Automation Discussions

buffer

Former Member — Sat, 14 Jun 2008 06:20:06 GMT

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

Re: buffer

Former Member — Sat, 14 Jun 2008 06:23:39 GMT

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.

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

Re: buffer

Former Member — Sat, 14 Jun 2008 11:18:09 GMT

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_{carrname p}connid f~fldate`.

dbtab_syntax = `( ( scarr AS c `

& ` INNER JOIN spfli AS p ON p_{carrid = c}carrid`

& ` AND p~cityfrom = p_cityfr`

& ` AND p~cityto = p_cityto )`

& ` INNER JOIN sflight AS f ON f_{carrid = p}carrid `

& ` AND f_{connid = p}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.