Hello,
Is this statement correct.
DELETE SOURCE_PACKAGE WHERE DEL_TYPE ne 'LF' or DEL_TYPE ne 'BV' or
DEL_TYPE ne 'NL'.
I have written this statement in start routine and strangely it deletes all the records of the Source_Package though I see there are records with DEL_TYPE = 'LF' and 'BV' and 'NL'.
Finally 0 records are loaded into my ODS. Is there anything nissing.
Appreciate your quick response and will be rewarded.
thanks,
KK