Buffer mgnt

[Former Member]

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

[RichHeilman]

Isn't this handled automatically by the runtime?

Regards,

Rich Heilman

[Former Member]

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

[RichHeilman]

Oh, I guess that I read the question backwards.

Regards,

RIch Heilman

[Former Member]

thanks vishnu

vijayendra

[RichHeilman]

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

Regards,

RIch Heilman

[Former Member]

"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.