Incremental reload

[vireshkolagimat]

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

[vireshkolagimat]

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

[karthikoffi27se]

Hi Viresh,

Try using below

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

This should work

Many Thanks

Karthik

[vireshkolagimat]

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')

[vireshkolagimat]

--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')

[vireshkolagimat]

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