topic Re: Confirmation/Way out requrie require for QVD file generation? in QlikView

Confirmation/Way out requrie require for QVD file generation?

Mon, 06 Oct 2014 07:47:07 GMT

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

Re: Confirmation/Way out requrie require for QVD file generation?

ashfaq_haseeb — Mon, 06 Oct 2014 07:49:58 GMT

hi,

look at direct discovery

regards

ASHFAQ

Re: Confirmation/Way out requrie require for QVD file generation?

Mon, 06 Oct 2014 08:03:36 GMT

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

Re: Confirmation/Way out requrie require for QVD file generation?

Mon, 06 Oct 2014 08:36:25 GMT

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.

Re: Confirmation/Way out requrie require for QVD file generation?

Mon, 06 Oct 2014 08:51:39 GMT

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

Re: Confirmation/Way out requrie require for QVD file generation?

Mon, 06 Oct 2014 09:12:03 GMT

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.