How to achive qvd using some condition like if

[ManasRout]

Hi,

I have requirement like after creating QVD by using full load if I am using this QVD in 2 different Application it may be corrupt the QVD means the QVD may be become empty data.So that on their I want to apply a condition like if my QVD file size <=0 then doing again full load else QVD size >0 then doing incremental load.How to archive this.

Thanks in advance

[JordyWegman]

Hi ManasRout,

Try this:

// Create a sub so you can reload it again
Sub LoadTable

// Load your table
Table:
Load
  *
From [YourSource] (qvd)
;

End Sub

// Call your load
Call LoadTable

// Check if the table has rows
Let vNoOfRows = NoOfRows( Table ) + 0;

// If it's empty, load the table again
IF $(vNoOfRows) = 0 then

    Call LoadTable

// If not, store the table
ELSE

    STORE Table INTO [YourSource] (qvd);

ENDIF

Jordy

Climber