Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem when i am reloading my QVD for getting data from DB.
I have 2 script both combined by "CONCATENATE".
Script1:
Operationdelay:
SQL Select ContainerNo,EquipmentType,containerstatus,bookNo,VesselCode,Voyage,ServiceCode,Bound,
Wt,CargoType,OprType,status,nxtStatus,agencyCode,datecr,actdate,mode,year(datecr) as DL_year,
month(datecr) as DL_Month,dbo.ISOweek_SunToSat(datecr) as DL_Weekno from operationdetail
where datecr >= '2016-01-01';
Store Operationdelay into Operationdelay.qvd(qvd);
drop table Operationdelay;
Note: From above script i am pulling data from 2016.
My QVD size after reload is around (98 MB).
Script2:
Operationdelay:
Load * from Operationdelay.qvd;
Concatenate
SQL Select ContainerNo,EquipmentType,containerstatus,bookNo,VesselCode,Voyage,ServiceCode,Bound,
Wt,CargoType,OprType,status,nxtStatus,agencyCode,datecr,actdate,mode,year(datecr) as DL_year,
month(datecr) as DL_Month,dbo.ISOweek_SunToSat(datecr) as DL_Weekno from operationdetail;
Store Operationdelay into Operationdelay.qvd(qvd);
drop table Operationdelay;
I am running this script with different DB and getting some more data from that DB. I am concatenating first script with this one. The issue was when run this second script it reloads only limited data and the QVD size becomes (Around 11 MB). How is it possible whe we use "concatenate" in both DB i have same table with same column name i checked twice. Pls help me to fix this problem.
Regards,
Dhana R
try to add (qvd) to this string.
LOAD * from Operationdelay.qvd (qvd);
try to add (qvd) to this string.
LOAD * from Operationdelay.qvd (qvd);
Tnx Andrey, wat a silly mistake i made