Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Forum/Friends
Suppose I have billions of record's in QVD file. But I want to just add some 100 records in QVD file. The process I follow as below:
qvdtab:
1. 1st load the QVD data in Memory (Resident Load)
2. (Concenate) Extracting the require/new 100 records from DataDase.
3. Store qvdtab into D:\QVD\dataqvd.qvd(qvd)
My requirement:-
Is there any may to directly insert 100 records in QVD file without parking in memory?.
Advance Thanks
SD
hi,
look at direct discovery
regards
ASHFAQ
Hi Ashfaq,
Thanks for Quik Response.
I am aware about the Direct discovery. In short it is directly co-ordinating/connecting(online) with database.
I am taking about updation of QVD.
Adv Thanks
SD
Hi,
I guess you always have to read all records that you want to store into 1 qvd (reading your initial records, concatenate new ones then storing into qvd).
However in your case, if you always need to insert new records (no update/delete of existing record), you could store each time the new pack of records into a different qvd and choose a common name for them with the timestamp (date and/or time), say MyQvd20141006.qvd and MyQvd20141007.qvd, etc.
You can use a variable for that:
let vDate = date(today(), 'YYYYMMDD');
And after loading your new records:
store MyQvd into MyQvd$(vDate).qvd;
When you want read the qvds that start with "MyQvd":
Load * from MyQvd*.qvd(qvd);
Hope this answers your request.
Hi JP,
Thanks for quick response. I am aware of all those stuff which u had mentioned above.
My query/question is whether I can insert changed/new 100 records directly in dataqvd.qvd without doing the process which is mentioned in 1st discussion
Adv Thanks
SD
Shan,
I already mentioned that you need to do the process you described if you want to store in 1 qvd only.
As far as I know, there's no insert/concatenate functionality directly into a qvd, without passing by a resident load.
I also proposed an alternative if you want to avoid doing your process, by storing into different qvds which names start the same, so you can later use the wildcard character '*' when you want to load the whole data.