topic Re: Incremental load using QVC - Oracle DB in QlikView

Incremental load using QVC - Oracle DB

anithashivalingappa — Mon, 01 Jul 2013 04:57:09 GMT

Hi,

Am getting error while trying to setup incremental load using qlikview components. suggest me to fix this. connecting oracle DB, for SQL DB its working fine.

Re: Incremental load using QVC - Oracle DB

tresB — Mon, 01 Jul 2013 05:13:39 GMT

It seems that there is a format issue. please check if your date/timestamp format(withing quotes) is similar to the one in database.

Re: Incremental load using QVC - Oracle DB

perumal_41 — Mon, 01 Jul 2013 05:30:47 GMT

Try this code

Select *

FROM Table1 b where

to_date(b.last_modified_dt, 'dd/mm/yyyy hh:mi PM')

<=to_date('02/04/2013 6:58 PM', 'dd/mm/yyyy hh:mi PM');

Re: Incremental load using QVC - Oracle DB

anithashivalingappa — Thu, 04 Jul 2013 03:53:53 GMT

thanks for your response. the format is same

am using qvs file and calling the incremental function. the script is like this..

SET Qvc.Loader.v.QvdDirectory='F:\IAS_DB\Data';

LET Qvc.Loader.v.BaseValue = num (MakeDate (2013, 01, 01));

SET Qvc.Loader.v.DatabaseDatetimeMask = 'M/D/YYYY h: mm:ss TT';

// Calling parameters are Tablename, UpdateColumn, QVD_PrimaryKey.CALL Qvc.IncrementalSetup ('VIW_MONTHLY_INCIDENT_NODATE', 'LASTMDFDDATE', 'IND_CALL_NO');
Directory;
[$(Qvc.Loader.v.Tablename)]:

LOAD *;
SQL SELECT *
FROM NEWWCCC."VIW_MONTHLY_INCIDENT_NODATE"
WHERE $(Qvc.Loader.v.IncrementalExpression);

Call Qvc.Log ('$(Qvc.Loader.v.Tablename) loaded, rows=' &

Num (NoOfRows ('$(Qvc.Loader.v.Tablename)'), '#,##0'));

CALL Qvc.IncrementalStore

CALL Qvc.Cleanup;

Also i tried the below script also but its not working. help me out to fix this..

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'; Let vThisExecTime=Now();

Let vQvd=isnull(QvdCreateTime());

if(vQvd=-1) then

VIW_MONTHLY_INCIDENT_NODATE:
SQL SELECT *
FROM NEWWCCC."VIW_MONTHLY_INCIDENT_NODATE";

Else

SQL SELECT *
FROM NEWWCCC."VIW_MONTHLY_INCIDENT_NODATE" where Trunc(LASTMDFDDATE) >=$(vLastExecTime) and Trunc(LASTMDFDDATE) <$(vThisExecTime);

Concatenate

LOAD * FROM
[..\Data\VIW_MONTHLY_INCIDENT_NODATE.qvd]
(qvd) where not Exists(id,id);
ENDIF

Store VIW_MONTHLY_INCIDENT_NODATE into ..\Data\ VIW_MONTHLY_INCIDENT_NODATE.qvd;

DROP Table VIW_MONTHLY_INCIDENT_NODATE;

Re: Incremental load using QVC - Oracle DB

techvarun — Tue, 10 Sep 2013 09:52:17 GMT

facing this same problem please post the answer

Anitha Shivalingappa

Regards