Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to make an buffer incremental load from a csv file. But every time I reload, the last entry from the file is missing. If I load normally, everything works fine. please help me out.
I think you should use the buffer-feature only if you are sure that you have a significant advantage from them. Your missing entry will be probably caused by a not complete fitting load-condition which you should check again.
- Marcus
check this: Buffer(Incremental) Load Issue
Thnaks for the reply
...Could you please share an example for the same..
Hi,
Are you using Stale as part of this option for your BUFFER?
You need to look at this, especially if you are reloading manually.
You can specify as you want it
buffer (stale after 7 days) select * from MyTable;
or
buffer (stale after 1 hour) select * from MyTable;
I'm not using stale....I'm just using the below script
buffer (Incremental)LOAD
U_name,
U_pwd
FROM
[Source_path\Buffer.txt]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
\\Buffer.text data
U_name,U_pwd
Jhnk,124
greg,123
Ureg,224
Preg,545
using the above script I'm able to display only first three record...if I add a fifth record to the above text file...only four record are displayed.... the last value is missing every time I load.
Hi,
The incremental option in Buffer only check the QVD file size which is stored in XML header in the QVD file.
Use FileSize () function before and after adding new records.
Add few carriage returns and see if that make difference