topic Re: general.... in Application Development and Automation Discussions

general....

Former Member — Wed, 30 May 2007 03:26:26 GMT

Hi,

A table is buffered. By select statement i dont want to get

the data from table buffer. i want to get the data from

database. how?

Thx in adv,

Reg,

Suresh Kumar.V

Re: general....

Former Member — Wed, 30 May 2007 03:28:29 GMT

you can use

SELECT * FROM SPPROD INTO WA_SPPROD BYPASSING BUFFER WHERE PRODUCER = 'BOE'.

like this

regards

shiba dutta

Message was edited by:

SHIBA DUTTA

Re: general....

Former Member — Wed, 30 May 2007 03:29:09 GMT

Hi,

Use the BYPASSING BUFFER addition..


SELECT * FROM ZTABLE BYPASSING BUFFER
             INTO TABLE T_ZTABLE

Thanks,

Naren

Re: general....

Former Member — Wed, 30 May 2007 03:29:11 GMT

hi Suresh,

Use<b> BYPASSING BUFFER</b> statement

SELECT * FROM <TABLE> BYPASSING BUFFER WHERE .... .

Refer

Re: general....

Former Member — Wed, 30 May 2007 03:32:52 GMT

Hi,

Normally we will use this by passing buffer for T tables to optimize the fetching.

Use statement BYPASSING BUFFER in the select statement.

Eg:

SELECT persg " Employee group

persk " Employee sub group

trfkz " ES grouping for collective agreement provision

FROM t503

BYPASSING BUFFER

INTO TABLE i_t503.

Regards,

Priyanka.

Re: general....

Former Member — Wed, 30 May 2007 04:38:18 GMT

Hi,

You can use the BYPASSING BUFFER addition in the seelect statement,

Reward points if it is helpful.

Regards,

Sangeetha.a