Can it be done???

[MalcolmCICWF]

I had this random idea the other day when one of the companies qvds finished loading but encountered a problem causing only half the records to load. The job did not fail and I knew nothing about it until I tried to call upon that qvd for some data.

My question is, can you create a qvd that would check the record total loaded in another qvd, then check that against the last day or 2 for a percentage/volume drop, and then alert you somehow? It seems that sometimes the load of a qvd does not work and yet you dont notice for some time. I just want some sort of early detection system. Ideas?

[erichshiino]

You don't need anything up to line 39.

When I used noofRecords = noofRows( x ), the argument x is a resident table (in my case it was transactions)

Since you are using a QVD as your target, you can use qvdnoofRecords as we used in the if statement in line 51

You also need to remove the (qvd) on line 42.

Hope it helps,

Erich

[MalcolmCICWF]

I have to be so close, but I cannot get the number of records to generate, the field is just blank. Any ideas?

[erichshiino]

I'd say it is very close now

In line 16, change NoOfRows( ...  to QvdNoOfRecords ( ....

Then, in line 25, change the if to

if  $(QvdnoofRecords) > 0  then

Regards,

Erich

[MalcolmCICWF]

I did what you mentioned and that all made sense, but then I got the below error, so I figured I needed to write it like '$(QvdnoofRecords) > 0 then

Now the script finished again, but no records! I know the QVD has records, I even tried others to be sure. This thing is getting frustrating.

This is how I am sitting right now

[CELAMBARASAN]

Hi,

     You should use LET in the line 16 before QvdnoOfRecords and reloadTime to set a variable value.

Celambarasan

[erichshiino · Accepted solution]

When you don't use SET or LET and just try to create a variable, LET is the default. So, it should work anyway.

I tried some diferente values, and I found that if the the argument of QVDNoOfRecords () is a qvd that doesn't exist, the variable is not created. So, in the case, I would use the funcion in the if again instead of trying to use the variable.

So, in line 16, let the variable as it is.

In line 25, change the if to call the function:

if QVDnoOfRecords ( ' ... etc ....' ) > 0 then ....

Regards,

Erich

[MalcolmCICWF]

It finally worked! it also did not like me calling upon a QVD in another folder, it required me to store it in the same folder as the Qvw itself.