Check for existence of QVD

FMDF — Sat, 16 Nov 2024 18:36:29 GMT

I have seen similar posts and I have tried the solutions. Nothing is working. Seems like it should be simple enough.

No matter what method I have used...qvdcreatetime, qvdfilesize...They always return null. The file exists. The path is correct. The capitalization is correct. I don't know what is going wrong with this.

SET vFileName = 'F:\FMCustom\01_Staging\QVD\Oracle\ItemOnhandQtyDetail_HIST.QVD';

//If the snapshot table exists, load it for the last 3 years and append the new snapshot.

IF (NOT isNull(qvdCreateTime($(vFileName)))) THEN

ItemOnhandQtyDetail_HIST:
LOAD
DISTINCT
*
FROM [lib://FM Staging/QVD/Oracle/ItemOnhandQtyDetail_HIST.QVD](qvd)
Where
Year(dateLoaded) >= Year(Today())-2
;

//Append todays data to the HIST table.

Concatenate(ItemOnhandQtyDetail_HIST)
LOAD
itemKey,
organizationId,
inventoryItemId,
subinventoryCode,
primaryTransactionQty,
locatorId,
dateLoaded
FROM [lib://FM Staging/QVD/Oracle/ItemOnhandQtyDetail.QVD](qvd);

ELSE
//Snapshot Table does not exist yet. Load it from the current data load.

ItemOnhandQtyDetail_HIST:
LOAD
*
FROM [lib://FM Staging/QVD/Oracle/ItemOnhandQtyDetail.QVD](qvd);
;
END IF

topic Check for existence of QVD in App Development

Check for existence of QVD