Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
While implementing incremental load source from Oracle database.
vMaxDate = Peek ('Maxdate ',0) and also tried ('MaxDate', 0,'Table name '
Table:
Load
Status_Date,
AAAA,
BBBB,
CCCC;
SELECT
Status_Date,
AAAA,
BBBB,
CCCC
FROM Table
Where Status _Date >'20230131' ; and tried ( where Status_Date > '$(vMaxDate)' but no use...I need this date format 20230131 as variable which responds to select statement.
Instead of Date I need to store Max date from QVD which is stored in variable . But it's not working.
Hi, you can give that format to the vMaxDate variable using the Date() function:
vMaxDate = Date(Peek ('MaxDate',0),'YYYYMMDD')
You also need to confirm that the max date has been loaded on the table where MaxDate field is loaded.
Hi, you can give that format to the vMaxDate variable using the Date() function:
vMaxDate = Date(Peek ('MaxDate',0),'YYYYMMDD')
You also need to confirm that the max date has been loaded on the table where MaxDate field is loaded.
Thank you so much I got it ....