qvd's are deleted how to identify in qlikview, any function is available

[#1]

Hi,

I have some qvd's are deleted how to identify in qlikview, Is there any method or function to find out 

deleted qvd's

Thanks,

Tejeswara Rao.

[jonathandienst]

I am not sure what you require. How would you identify something that has been deleted?

[#3]

In my environment my qvw associate some qvd tables which are deleted,How do you check

like manual method or any function available in qlikview

[kevpickering]

Are you wanting to check whether the qvd file exists before processing it? If so, use the FILESIZE() function:

IF ISNULL(FILESIZE('<path to qvd file>')) > -1  THEN

  <code to process qvd file>

END IF

[kevpickering]

Sorry, the ISNULL() should be <> -1 (not > -1)

[#6]

Thanks Kevin..

[Magnus_Berg]

In Qlik Deployment framework there is a built in function to validate content:

vL.FileExist sub function validates if a file or folder exists, can be used before load to avoid errors during script load.
Syntax example in the script: call vL.FileExist('$(vG.QVDPath)\*');

Variable vL.FileExist returns true or false.

Example, action exit script after check:

call vL.FileExist ('$(vL.MetaDataQVDPath)\1.NorthWind);
Will Check if1.NorthWind folder exists and return vL.FileExist = true or false

call vL.FileExist ('$(vL.MetaDataQVDPath)\SOE.qvd');
if vL.FileExist = 'false' then; trace '### Did not find file, exit script'; exit script; endif;