QVD Incremental load from Stored Procedure using Cookbook

Anonymous — Fri, 20 Jul 2012 21:56:24 GMT

I am new to clickview but have learned about Rob's Cookbook. I have created some QVD's that load incrementally that pull directly from a table but can someone help me in getting that to work with a stored procedure where parameters are being passed.

//Setup

SET vQvdFile='..\ExtractQVD\QVDNAME.qvd';

SET vTableName='TABLENAME';

SET vPK='PRIMARYKEY';

LET vQvdExists = if(FileSize('$(vQvdFile)') > 0, -1, 0);

IF $(vQvdExists) THEN

maxdateTab:

LOAD max(OrderDate) as maxdate

FROM $(vQvdFile) (qvd);

LET vIncrementalExpression = 'WHERE OrderDate >=' & peek('maxdate');

DROP table maxdateTab;

ELSE

LET vIncrementalExpression = '';

END IF

//Load Script

$(vTableName):

Directory;

LOAD SystemOrderDetailID, //Primary Key

OrderDate, // Row Modification date

OrderNumber,

ReceiptNumber,

CustomerID

FROM

'..\Desktop\gcjrptphonesales.csv'

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

$(vIncrementalExpression)

;

//Update QVD

Directory;

IF $(vQvdExists) THEN

CONCATENATE ($(vTableName)) LOAD * FROM $(vQvdFile) (qvd)

WHERE NOT exists($(vPK))

;

END IF

INNER JOIN ($(vTableName))

LOAD $(vPK)

FROM

'..\Desktop\gcjrptphonesales.csv '

(ansi, txt, delimiter is ',', embedded labels, msq)

;

STORE $(vTableName) INTO $(vQvdFile);

Call log('$(vQvdFile) updated, rows=' & QvdNoOfRecords('$(vQvdFile)'))

---------------------------

Now here is the Stored Procedure I would like to insert into the scrip above but not sure how as I have yet to get it to work.

Sales:

LOAD SystemOrderDetailID, //Primary Key

OrderDate, // Row Modification date

OrderNumber,

ReceiptNumber,

CustomerID

SQL

EXEC DB..sp_CustomerSales '$(DATEFROM)', '$(DATETO)';

Thanks for your help.

topic QVD Incremental load from Stored Procedure using Cookbook in QlikView

QVD Incremental load from Stored Procedure using Cookbook