topic Re: Incremental reload in QlikView

Incremental reload

vireshkolagimat — Sun, 28 Jan 2018 08:25:33 GMT

Hello All,

I am working on incremental load but getting the below error.

SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

ConsOP:

SQL SELECT *

FROM ConsOP

where [ModifiedDate] > '17/01/2018'

Please find the attached qvw file for the reference. when i do the initial reload, it works fine and modifieddate is stored as number like 43109. But when i initiate the incremental realod, the date format i am getting from initial reload is DD/MM/YYYY and its giving the above error. Oracle stored the date format as DD-MMM-YY.

Thanks for the support.

Regards,

Viresh

Re: Incremental reload

vireshkolagimat — Sun, 28 Jan 2018 08:38:39 GMT

The default Dateformat set in main tab is DD/MM/YYYY.

Re: Incremental reload

karthikoffi27se — Sun, 28 Jan 2018 08:41:03 GMT

Hi Viresh,

Try using below

WHERE [ModifiedDate] > TO_DATE'(17/01/2018','DD/MM/YYYY')

This should work

Many Thanks

Karthik

Re: Incremental reload

vireshkolagimat — Sun, 28 Jan 2018 08:47:03 GMT

Hi, i tried the above method but still getting the error.

SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

ConsOP:

SQL SELECT *

FROM ConsOP

where [ModifiedDate] > to_date('17/01/2018','DD/MM/YYYY')

Re: Incremental reload

vireshkolagimat — Sun, 28 Jan 2018 09:03:23 GMT

--Query

$(_qvd_name):

SQL SELECT *

FROM $(_qvd_name)

where [$(vUpdateField)] > to_date('$(vMaxKey)','DD-MMM-YY');

-- Error

SQL##f - SqlState: S1000, ErrorCode: 936, ErrorMsg: [Oracle][ODBC][Ora]ORA-00936: missing expression

ConsOP:

SQL SELECT *

FROM ConsOP

where [ModifiedDate] > to_date('17/01/2018','DD-MMM-YY')

Re: Incremental reload

vireshkolagimat — Sun, 28 Jan 2018 11:01:05 GMT

Hi Karthik,

I was referring the qvd file instead of table from db and hence i was getting error.

I used the above format and it works fine.

Thank you.

Regards,

Viresh