Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[Legacy4]:
Load
WRITTENPREMIUMLEGACY as NewBusinessLegacy
,ACCOUNTINGDTS as AccountingDtsLegacyNewBusiness
,TRANSCODE_EU as TransCodeNewBus
,POLICYNOLEGACY as PolicyNoLegacyNewBus
,CLASSCODELEGACY as ClassCodeNewBus
,RECORDNUMBER as RecordNumberNewBus
,LEGACYPROCESSDATES as LegacyProcessDatesNewBus
,EFFECTIVE as EffectiveNewBus
,EXPIRATION as ExpirationNewBus
,if(LEGACYPROCESSDATES > EFFECTIVE ,LEGACYPROCESSDATES, EFFECTIVE) as NewBusinessDate
,PolicyCancelDate as PolicyCancelDateNewBus
Resident [Legacy3]
where POLICYNOLEGACY in (select PolicyNoLegacy from Legacy3 where TransCode_EU = '01' );
//Connect to your data base
Tmp:
Load * ;
select PolicyNoLegacy
from Legacy3
where TransCode_EU = '01'
[Legacy4]:
Load
WRITTENPREMIUMLEGACY as NewBusinessLegacy
,ACCOUNTINGDTS as AccountingDtsLegacyNewBusiness
,TRANSCODE_EU as TransCodeNewBus
,POLICYNOLEGACY as PolicyNoLegacyNewBus
,CLASSCODELEGACY as ClassCodeNewBus
,RECORDNUMBER as RecordNumberNewBus
,LEGACYPROCESSDATES as LegacyProcessDatesNewBus
,EFFECTIVE as EffectiveNewBus
,EXPIRATION as ExpirationNewBus
,if(LEGACYPROCESSDATES > EFFECTIVE ,LEGACYPROCESSDATES, EFFECTIVE) as NewBusinessDate
,PolicyCancelDate as PolicyCancelDateNewBus
Resident [Legacy3]
where Exists(PolicyNoLegacy,POLICYNOLEGACY);
drop table Tmp;
//Connect to your data base
Tmp:
Load * ;
select PolicyNoLegacy
from Legacy3
where TransCode_EU = '01'
[Legacy4]:
Load
WRITTENPREMIUMLEGACY as NewBusinessLegacy
,ACCOUNTINGDTS as AccountingDtsLegacyNewBusiness
,TRANSCODE_EU as TransCodeNewBus
,POLICYNOLEGACY as PolicyNoLegacyNewBus
,CLASSCODELEGACY as ClassCodeNewBus
,RECORDNUMBER as RecordNumberNewBus
,LEGACYPROCESSDATES as LegacyProcessDatesNewBus
,EFFECTIVE as EffectiveNewBus
,EXPIRATION as ExpirationNewBus
,if(LEGACYPROCESSDATES > EFFECTIVE ,LEGACYPROCESSDATES, EFFECTIVE) as NewBusinessDate
,PolicyCancelDate as PolicyCancelDateNewBus
Resident [Legacy3]
where Exists(PolicyNoLegacy,POLICYNOLEGACY);
drop table Tmp;
thanks