topic Re: Buffer mgnt in Application Development and Automation Discussions

Buffer mgnt

Former Member — Wed, 07 Mar 2007 18:12:52 GMT

Can we perform a direct db read from a buffered db table. If yes how? thxn in advance

Re: Buffer mgnt

RichHeilman — Wed, 07 Mar 2007 18:15:09 GMT

Isn't this handled automatically by the runtime?

Regards,

Rich Heilman

Re: Buffer mgnt

Former Member — Wed, 07 Mar 2007 18:21:03 GMT

1. Use BYPASSING BUFFER option:

SELECT ... FROM tables options ...

In tables, you specify the names of database tables and define joins.

In options, you can specify the following:

· CLIENT SPECIFIED to disable automatic client handling

· BYPASSING BUFFER to disable data buffering

2. Use native SQL EXEC - ENDEXEC

Re: Buffer mgnt

Former Member — Wed, 07 Mar 2007 18:24:53 GMT

"By pass buffer" is the best option in the select query will provide the provision that the data cann't be read from the buffer .it takes data from the table.

Re: Buffer mgnt

RichHeilman — Wed, 07 Mar 2007 18:25:39 GMT

Oh, I guess that I read the question backwards.

Regards,

RIch Heilman

Re: Buffer mgnt

Former Member — Wed, 07 Mar 2007 18:27:13 GMT

thanks vishnu

vijayendra

Re: Buffer mgnt

RichHeilman — Wed, 07 Mar 2007 18:29:43 GMT

Don't think my my answer solved your problem, please assign the 10 points to Vishnu. Thanks.

Regards,

RIch Heilman