How to check whether data is fetched or not..

[engr_farhanqadr]

Hi Folks,

Can any one guide me how can I create a qvw file which shows that others qvws runs are executed successfully and whether data is fetched correctly or not.?

Thanks,

Farhan

[swuehl]

How would you determine that data is fetched correctly or not? I mean, if there is no script error?

Do you have any test on data volumen etc. in mind?

To track the completed reloads, I remember an application by Rob Wunderlich some time ago, that checked the reload timestamps of the QVWs (scanning the files in the application folder). Just can't find his app right now, but the idea sounds quite straight forward.

[engr_farhanqadr]

Lets take an eg if I am generating qvd and its having the size as previous then there is no data fetch even if the script is run correctly.

[manojkulkarni]

Let vOldCount= QvdNoOfRecords('OldData\Sample.qvd');
Let vNewCount= QvdNoOfRecords('NewData\Sample.qvd');

if( vOldCount =vNewCount) then

'No Update'

Else

'Updated'

End if;

[mohammadkhatimi]

Hie..

LOAD

'Tablename' as QvdName,

QvdCreateTime('$(Path)Tablename.QVD') as QvdTime

AutoGenerate 1;

Hope this will helps u..!!

Regards,

Mohammad

[manojkulkarni]

Get Meta data info of any QVD

Set QvdFileName = 'Sample.qvd';

LET vFileSize = FileSize(QvdFileName);

LET vQvdCreateTime = QvdCreateTime(QvdFileName);

LET vQvdNoOfRecords = QvdNoOfRecords(QvdFileName);

LET vQvdNoOfFields = QvdNoOfFields(QvdFileName);