echo see README.TXT for usage.


rem parameters:
rem 1 connection string
rem 
rem c:\>fdbp5v4ClientServerReload orange/rvfdb

echo on
cls
echo ------------------------------------------------------------
set day=%DATE:~0,3%
SET HOUR=%TIME:~0,2%
IF "%HOUR:~0,1%" == " " SET HOUR=0%HOUR:~1,1%
SET MIN=%TIME:~3,2%
IF "%MIN:~0,1%" == " " SET MIN=0%MIN:~1,1%
SET SECS=%TIME:~6,2%
IF "%SECS:~0,1%" == " " SET SECS=0%SECS:~1,1%
SET YEAR=%DATE:~-4%
SET MONTH=%DATE:~4,2%
IF "%MONTH:~0,1%" == " " SET MONTH=0%MONTH:~1,1%
SET DAY=%DATE:~7,2%
IF "%DAY:~7,1%" == " " SET DAY=0%DAY:~1,1%
SET logname=fdbp5v44_%YEAR%.%MONTH%.%DAY%.%HOUR%.%MIN%.%SECS%.log

echo Reloading all FDB data. 
echo .
echo Truncating tables...
sqlplus.exe -S fdbp5/country@%1 @truncatealltables.sql >%logname%
echo .
echo Populating FDB data.
sqlldr control=ctl\fdbahfsmonographgs.ctl log=log\fdbahfsmonographgs.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbahfsmonographclass.ctl log=log\fdbahfsmonographclass.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbahfsclassificationlink.ctl log=log\fdbahfsclassificationlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbahfsmonograph.ctl log=log\fdbahfsmonograph.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbahfssection.ctl log=log\fdbahfssection.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbahfstitle.ctl log=log\fdbahfstitle.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdballergenextvocablink.ctl log=log\fdballergenextvocablink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdballergengroup.ctl log=log\fdballergengroup.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdballergenpicklistsearch.ctl log=log\fdballergenpicklistsearch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdballergycrosssensitivity.ctl log=log\fdballergycrosssensitivity.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclassification.ctl log=log\fdbclassification.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclassificationclasslink.ctl log=log\fdbclassificationclasslink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclassificationdruglink.ctl log=log\fdbclassificationdruglink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkdfi.ctl log=log\fdbclinicallinkdfi.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkdpt.ctl log=log\fdbclinicallinkdpt.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkgeri.ctl log=log\fdbclinicallinkgeri.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinklact.ctl log=log\fdbclinicallinklact.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkpedi.ctl log=log\fdbclinicallinkpedi.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkpem.ctl log=log\fdbclinicallinkpem.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkpreg.ctl log=log\fdbclinicallinkpreg.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkahfsmono.ctl log=log\fdbclinicallinkahfsmono.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkdamalgrp.ctl log=log\fdbclinicallinkdamalgrp.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkdaming.ctl log=log\fdbclinicallinkdaming.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkdamxsen.ctl log=log\fdbclinicallinkdamxsen.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkdamrelhitalg.ctl log=log\fdbclinicallinkdamrelhitalg.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkdamrelhiting.ctl log=log\fdbclinicallinkdamrelhiting.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkdamrelhitxsn.ctl log=log\fdbclinicallinkdamrelhitxsn.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkddc.ctl log=log\fdbclinicallinkddc.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkind.ctl log=log\fdbclinicallinkind.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbclinicallinkside.ctl log=log\fdbclinicallinkside.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcmmlink1.ctl log=log\fdbcmmlink1.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcmmlink2.ctl log=log\fdbcmmlink2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcmmlink3.ctl log=log\fdbcmmlink3.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcmmmessage1.ctl log=log\fdbcmmmessage1.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcmmmessage2.ctl log=log\fdbcmmmessage2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcmmmessage3.ctl log=log\fdbcmmmessage3.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcodedefinition4.ctl log=log\fdbcodedefinition4.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcodedefinitionexpanded4.ctl log=log\fdbcodedefinitionexpanded4.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcodetype4.ctl log=log\fdbcodetype4.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustomallergenpicklstsrch.ctl log=log\fdbcustomallergenpicklstsrch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustomattributename.ctl log=log\fdbcustomattributename.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustomattributevalue.ctl log=log\fdbcustomattributevalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustomclinicaldrug.ctl log=log\fdbcustomclinicaldrug.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustomclinicalexclusion.ctl log=log\fdbcustomclinicalexclusion.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustomddimdruglinkcat.ctl log=log\fdbcustomddimdruglinkcat.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustomddimseverity.ctl log=log\fdbcustomddimseverity.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\NO_DATA.ctl log=log\NO_DATA.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\NO_DATA.ctl log=log\NO_DATA.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\NO_DATA.ctl log=log\NO_DATA.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\NO_DATA.ctl log=log\NO_DATA.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\NO_DATA.ctl log=log\NO_DATA.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustomdptallowance.ctl log=log\fdbcustomdptallowance.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\NO_DATA.ctl log=log\NO_DATA.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustomindication.ctl log=log\fdbcustomindication.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\NO_DATA.ctl log=log\NO_DATA.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustommonograph.ctl log=log\fdbcustommonograph.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbcustommonographlink.ctl log=log\fdbcustommonographlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbddc.ctl log=log\fdbddc.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbddiminactivelink.ctl log=log\fdbddiminactivelink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbddimlink.ctl log=log\fdbddimlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbddiminteraction.ctl log=log\fdbddiminteraction.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdfiminteraction.ctl log=log\fdbdfiminteraction.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdisclaimer.ctl log=log\fdbdisclaimer.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdispensable.ctl log=log\fdbdispensable.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdispensableclnclqty.ctl log=log\fdbdispensableclnclqty.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdispensablegenlink.ctl log=log\fdbdispensablegenlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdispensablelabeler.ctl log=log\fdbdispensablelabeler.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdispensablepackageddrug.ctl log=log\fdbdispensablepackageddrug.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdispensablesearch.ctl log=log\fdbdispensablesearch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdispensablesearchterm.ctl log=log\fdbdispensablesearchterm.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdispensablevalue.ctl log=log\fdbdispensablevalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfcsdispensablevalue.ctl log=log\fdbfcsdispensablevalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdosetype.ctl log=log\fdbdosetype.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdosing.ctl log=log\fdbdosing.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdosingexclusionreason.ctl log=log\fdbdosingexclusionreason.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdosingminmax.ctl log=log\fdbdosingminmax.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdosingminmaxpatparam.ctl log=log\fdbdosingminmaxpatparam.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdosingpatparam.ctl log=log\fdbdosingpatparam.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdosingrenal.ctl log=log\fdbdosingrenal.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdosingrenalpatparam.ctl log=log\fdbdosingrenalpatparam.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdosingseveritylevel.ctl log=log\fdbdosingseveritylevel.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdruggendrugname.ctl log=log\fdbdruggendrugname.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdruggennamedlink.ctl log=log\fdbdruggennamedlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdruginactiveingred.ctl log=log\fdbdruginactiveingred.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdruginactivestudy.ctl log=log\fdbdruginactivestudy.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdrugname.ctl log=log\fdbdrugname.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdrugnamegenlink.ctl log=log\fdbdrugnamegenlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdrugnamesearch.ctl log=log\fdbdrugnamesearch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbdrugnamevalue.ctl log=log\fdbdrugnamevalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbduplicatetherapy.ctl log=log\fdbduplicatetherapy.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextallergenvocablink.ctl log=log\fdbextallergenvocablink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextproductcddesc.ctl log=log\fdbextproductcddesc.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextproductcode.ctl log=log\fdbextproductcode.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextvocab.ctl log=log\fdbextvocab.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextvocabcategorylink.ctl log=log\fdbextvocabcategorylink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextvocabdataversion.ctl log=log\fdbextvocabdataversion.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextvocabextlink.ctl log=log\fdbextvocabextlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextvocabextlinkvalue.ctl log=log\fdbextvocabextlinkvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextvocabfdblink.ctl log=log\fdbextvocabfdblink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextvocabfdblinkvalue.ctl log=log\fdbextvocabfdblinkvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextvocabreplacement.ctl log=log\fdbextvocabreplacement.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextvocabtypecd.ctl log=log\fdbextvocabtypecd.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbextvocabvalue.ctl log=log\fdbextvocabvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfcsextvocabvalue.ctl log=log\fdbfcsextvocabvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfcsscheduledea.ctl log=log\fdbfcsscheduledea.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfcsunivfedschedule.ctl log=log\fdbfcsunivfedschedule.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfcsunivstate.ctl log=log\fdbfcsunivstate.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfcsunivstatepdmp.ctl log=log\fdbfcsunivstatepdmp.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfcsdeamaster.ctl log=log\fdbfcsdeamaster.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfcsstatemulticode.ctl log=log\fdbfcsstatemulticode.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfdaapprelationship.ctl log=log\fdbfdaapprelationship.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfrequencyinterval.ctl log=log\fdbfrequencyinterval.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendispingstrtype.ctl log=log\fdbgendispingstrtype.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendispensable.ctl log=log\fdbgendispensable.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendispensableingstr.ctl log=log\fdbgendispensableingstr.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendispensablelink.ctl log=log\fdbgendispensablelink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendispensablesearch.ctl log=log\fdbgendispensablesearch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendispensablevalue.ctl log=log\fdbgendispensablevalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendrugname.ctl log=log\fdbgendrugname.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendrugnameingred.ctl log=log\fdbgendrugnameingred.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendrugnamelink.ctl log=log\fdbgendrugnamelink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendrugnamesearch.ctl log=log\fdbgendrugnamesearch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgendrugnamevalue.ctl log=log\fdbgendrugnamevalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgenrouteddfdrug.ctl log=log\fdbgenrouteddfdrug.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgenrouteddfdruglink.ctl log=log\fdbgenrouteddfdruglink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgenrouteddfdrugsearch.ctl log=log\fdbgenrouteddfdrugsearch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgenrouteddfdrugvalue.ctl log=log\fdbgenrouteddfdrugvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgenrouteddrug.ctl log=log\fdbgenrouteddrug.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgenrouteddruglink.ctl log=log\fdbgenrouteddruglink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgenrouteddrugsearch.ctl log=log\fdbgenrouteddrugsearch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbgenrouteddrugvalue.ctl log=log\fdbgenrouteddrugvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhraction.ctl log=log\fdbhraction.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhradditionaltext.ctl log=log\fdbhradditionaltext.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhrassocinfobyteaction.ctl log=log\fdbhrassocinfobyteaction.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhrassocinfobyte.ctl log=log\fdbhrassocinfobyte.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhrassocmitigation.ctl log=log\fdbhrassocmitigation.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhrxriskmono.ctl log=log\fdbhrxriskmono.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhrxuniv.ctl log=log\fdbhrxuniv.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhrinfobyte.ctl log=log\fdbhrinfobyte.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhrmonograph.ctl log=log\fdbhrmonograph.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhrmonodetail.ctl log=log\fdbhrmonodetail.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhrreplacement.ctl log=log\fdbhrreplacement.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbhrrisk.ctl log=log\fdbhrrisk.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptimprint.ctl log=log\fdbiptimprint.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptclaritylist.ctl log=log\fdbiptclaritylist.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptcoatinglist.ctl log=log\fdbiptcoatinglist.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptcolorlist.ctl log=log\fdbiptcolorlist.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptcolorpalette.ctl log=log\fdbiptcolorpalette.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptcolorxref.ctl log=log\fdbiptcolorxref.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptdoseformlist.ctl log=log\fdbiptdoseformlist.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptflavorlist.ctl log=log\fdbiptflavorlist.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptimage.ctl log=log\fdbiptimage.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptmfrlist.ctl log=log\fdbiptmfrlist.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptscoringlist.ctl log=log\fdbiptscoringlist.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptshapelist.ctl log=log\fdbiptshapelist.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptshapepalette.ctl log=log\fdbiptshapepalette.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptimprinttext.ctl log=log\fdbiptimprinttext.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbiptimprinttextxref.ctl log=log\fdbiptimprinttextxref.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbind.ctl log=log\fdbind.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbingredallergengroup.ctl log=log\fdbingredallergengroup.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbingredient.ctl log=log\fdbingredient.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdblabeler.ctl log=log\fdblabeler.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdblblwlink.ctl log=log\fdblblwlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdblblwtext1.ctl log=log\fdblblwtext1.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdblblwtext2.ctl log=log\fdblblwtext2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdblblwtext3.ctl log=log\fdblblwtext3.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdblblwvendor.ctl log=log\fdblblwvendor.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmasterdosageform.ctl log=log\fdbmasterdosageform.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmasterdosageformgendf.ctl log=log\fdbmasterdosageformgendf.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmasterdosageformmeddf.ctl log=log\fdbmasterdosageformmeddf.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmasterroute.ctl log=log\fdbmasterroute.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\NO_DATA.ctl log=log\NO_DATA.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmasterroutesingleroute.ctl log=log\fdbmasterroutesingleroute.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmasterunit.ctl log=log\fdbmasterunit.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmcinclusionreason.ctl log=log\fdbmcinclusionreason.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmcmeasure.ctl log=log\fdbmcmeasure.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmcmeasuretimeframe.ctl log=log\fdbmcmeasuretimeframe.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmcproductattr.ctl log=log\fdbmcproductattr.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmcproductattrdesc.ctl log=log\fdbmcproductattrdesc.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmcproductattrtype.ctl log=log\fdbmcproductattrtype.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmcproductattrvalue.ctl log=log\fdbmcproductattrvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmcproductdose.ctl log=log\fdbmcproductdose.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcond.ctl log=log\fdbmedcond.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondext.ctl log=log\fdbmedcondext.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondext2.ctl log=log\fdbmedcondext2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondextbestfit.ctl log=log\fdbmedcondextbestfit.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondextbillablehist.ctl log=log\fdbmedcondextbillablehist.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondextexclusion.ctl log=log\fdbmedcondextexclusion.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondextexclusion2.ctl log=log\fdbmedcondextexclusion2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondexthierarchy.ctl log=log\fdbmedcondexthierarchy.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondextlink.ctl log=log\fdbmedcondextlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondextlink2.ctl log=log\fdbmedcondextlink2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondextvalue.ctl log=log\fdbmedcondextvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondextvalue2.ctl log=log\fdbmedcondextvalue2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondhierarchy.ctl log=log\fdbmedcondhierarchy.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondrelated.ctl log=log\fdbmedcondrelated.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondreplacement.ctl log=log\fdbmedcondreplacement.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondsynonym.ctl log=log\fdbmedcondsynonym.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmedcondvalue.ctl log=log\fdbmedcondvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmonographddim1.ctl log=log\fdbmonographddim1.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmonographddim2.ctl log=log\fdbmonographddim2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmonographdfim1.ctl log=log\fdbmonographdfim1.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmonographdfim2.ctl log=log\fdbmonographdfim2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmonographdosing.ctl log=log\fdbmonographdosing.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmonographpem1.ctl log=log\fdbmonographpem1.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmonographpem2.ctl log=log\fdbmonographpem2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbmonographpem3.ctl log=log\fdbmonographpem3.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpackageddrug.ctl log=log\fdbpackageddrug.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpackageddrugclnclqty.ctl log=log\fdbpackageddrugclnclqty.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpackageddrugdisphist.ctl log=log\fdbpackageddrugdisphist.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpackageddrugdisphistrsn.ctl log=log\fdbpackageddrugdisphistrsn.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpackageddrugprice.ctl log=log\fdbpackageddrugprice.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpackageddrugsearch.ctl log=log\fdbpackageddrugsearch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbfcsvalue.ctl log=log\fdbfcsvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpackageddrugvalue.ctl log=log\fdbpackageddrugvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpackageddrugvalue1.ctl log=log\fdbpackageddrugvalue1.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpediatricweight.ctl log=log\fdbpediatricweight.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbprecgeri.ctl log=log\fdbprecgeri.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpreclact.ctl log=log\fdbpreclact.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbprecpedi.ctl log=log\fdbprecpedi.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbprecpreg.ctl log=log\fdbprecpreg.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbprecpregmono.ctl log=log\fdbprecpregmono.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbprecpregreflink.ctl log=log\fdbprecpregreflink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbproduct.ctl log=log\fdbproduct.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbproductprice.ctl log=log\fdbproductprice.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbproductpriceattrdesc.ctl log=log\fdbproductpriceattrdesc.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbproductpriceattrtype.ctl log=log\fdbproductpriceattrtype.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbproductpriceattribute.ctl log=log\fdbproductpriceattribute.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbproductpricetype.ctl log=log\fdbproductpricetype.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbpropertyname.ctl log=log\fdbpropertyname.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbreference.ctl log=log\fdbreference.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrelatedroute.ctl log=log\fdbrelatedroute.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbreplacement.ctl log=log\fdbreplacement.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbreplacementalgrp.ctl log=log\fdbreplacementalgrp.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbreplacementing.ctl log=log\fdbreplacementing.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbreplacementxsen.ctl log=log\fdbreplacementxsen.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrouteddfdrug.ctl log=log\fdbrouteddfdrug.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrouteddfdruggenlink.ctl log=log\fdbrouteddfdruggenlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrouteddfdrugsearch.ctl log=log\fdbrouteddfdrugsearch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrouteddfdrugvalue.ctl log=log\fdbrouteddfdrugvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrouteddrug.ctl log=log\fdbrouteddrug.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrouteddruggenlink.ctl log=log\fdbrouteddruggenlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrouteddrugsearch.ctl log=log\fdbrouteddrugsearch.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrouteddrugvalue.ctl log=log\fdbrouteddrugvalue.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrxnormconcept.ctl log=log\fdbrxnormconcept.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrxnormcsexception.ctl log=log\fdbrxnormcsexception.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrxnormcslink.ctl log=log\fdbrxnormcslink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrxnormterm1.ctl log=log\fdbrxnormterm1.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrxnormterm2.ctl log=log\fdbrxnormterm2.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrxnormterm3.ctl log=log\fdbrxnormterm3.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrxnormterm4.ctl log=log\fdbrxnormterm4.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbrxnormtermdesc.ctl log=log\fdbrxnormtermdesc.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbsctlink.ctl log=log\fdbsctlink.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbsctvalueset.ctl log=log\fdbsctvalueset.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbsctvaluesetdesc.ctl log=log\fdbsctvaluesetdesc.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbside.ctl log=log\fdbside.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbuomconversion.ctl log=log\fdbuomconversion.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbuomtypedescription.ctl log=log\fdbuomtypedescription.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbushik.ctl log=log\fdbushik.log userid=fdbp5/country@%1 >>%logname%
sqlldr control=ctl\fdbversion.ctl log=log\fdbversion.log userid=fdbp5/country@%1 >>%logname%

echo Process complete.
