123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399 |
- @echo off & cd /d %~dp0
- del C:\GlobalCube\System\OPTIMA\SQL\temp\*.* /Q /F >nul 2>nul
- echo ==AA_TRTYPE==
- echo AA_TRTYPE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\AA_TRTYPE.bat 1
- echo ==ACCOUNT_INFO==
- echo ACCOUNT_INFO >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCOUNT_INFO.bat 1
- echo ==ACCT_BALANCE==
- echo ACCT_BALANCE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_BALANCE.bat 1
- echo ==ACTIVITY==
- echo ACTIVITY >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ACTIVITY.bat 1
- echo ==APPORTIONED_INV_TIME==
- echo APPORTIONED_INV_TIME >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\APPORTIONED_INV_TIME.bat 1
- echo ==APPORTIONED_USED_TIME==
- echo APPORTIONED_USED_TIME >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\APPORTIONED_USED_TIME.bat 1
- echo ==CALENDAR_EVENT==
- echo CALENDAR_EVENT >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\CALENDAR_EVENT.bat 1
- echo ==CALENDAR_INFO==
- echo CALENDAR_INFO >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\CALENDAR_INFO.bat 1
- echo ==CALENDAR_PATTERN==
- echo CALENDAR_PATTERN >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\CALENDAR_PATTERN.bat 1
- echo ==CAR_STATISTIC==
- echo CAR_STATISTIC >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\CAR_STATISTIC.bat 1
- echo ==COMM_TRANS_UNIT==
- echo COMM_TRANS_UNIT >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\COMM_TRANS_UNIT.bat 1
- echo ==COMM_UNIT==
- echo COMM_UNIT >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\COMM_UNIT.bat 1
- echo ==COURTESY_CAR==
- echo COURTESY_CAR >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\COURTESY_CAR.bat 1
- echo ==CUSTOMER==
- echo CUSTOMER >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\CUSTOMER.bat 1
- echo ==CUSTOMER_TRANSACT==
- echo CUSTOMER_TRANSACT >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\CUSTOMER_TRANSACT.bat 1
- echo ==DEPARTMENT_TYPE==
- echo DEPARTMENT_TYPE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\DEPARTMENT_TYPE.bat 1
- echo ==EMPLOYEE==
- echo EMPLOYEE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\EMPLOYEE.bat 1
- echo ==GLOBAL_MAKE==
- echo GLOBAL_MAKE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\GLOBAL_MAKE.bat 1
- echo ==GM_DRIVE_ORDER==
- echo GM_DRIVE_ORDER >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\GM_DRIVE_ORDER.bat 1
- echo ==ORDER_ACCUMULATION==
- echo ORDER_ACCUMULATION >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ORDER_ACCUMULATION.bat 1
- echo ==ORDER_HEADER==
- echo ORDER_HEADER >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ORDER_HEADER.bat 1
- echo ==ORDER_LINE==
- echo ORDER_LINE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ORDER_LINE.bat 1
- echo ==ORDER_OPEN_ITEMS==
- echo ORDER_OPEN_ITEMS >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ORDER_OPEN_ITEMS.bat 1
- echo ==ORDER_SERVICE_SCHEMES==
- echo ORDER_SERVICE_SCHEMES >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ORDER_SERVICE_SCHEMES.bat 1
- echo ==PERSON==
- echo PERSON >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\PERSON.bat 1
- echo ==PERSON_INFO==
- echo PERSON_INFO >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\PERSON_INFO.bat 1
- echo ==PRODUCT_FILE==
- echo PRODUCT_FILE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\PRODUCT_FILE.bat 1
- echo ==PRODUCT_STOCK_FILE==
- echo PRODUCT_STOCK_FILE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\PRODUCT_STOCK_FILE.bat 1
- echo ==PROFILE==
- echo PROFILE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\PROFILE.bat 1
- echo ==PROFILE_TYPE==
- echo PROFILE_TYPE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\PROFILE_TYPE.bat 1
- echo ==PUNCH==
- echo PUNCH >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\PUNCH.bat 1
- echo ==PURCH_DISCOUNTS==
- echo PURCH_DISCOUNTS >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\PURCH_DISCOUNTS.bat 1
- echo ==PURCH_DISC_TYPES==
- echo PURCH_DISC_TYPES >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\PURCH_DISC_TYPES.bat 1
- echo ==SERVICE_2000_FILE==
- echo SERVICE_2000_FILE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\SERVICE_2000_FILE.bat 1
- echo ==SITE==
- echo SITE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\SITE.bat 1
- echo ==SUPPLIER==
- echo SUPPLIER >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\SUPPLIER.bat 1
- echo ==SUPPLIER_TRANSACT==
- echo SUPPLIER_TRANSACT >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\SUPPLIER_TRANSACT.bat 1
- echo ==TIME_CONTROL_END==
- echo TIME_CONTROL_END >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\TIME_CONTROL_END.bat 1
- echo ==TIME_CONTROL_OPEN==
- echo TIME_CONTROL_OPEN >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\TIME_CONTROL_OPEN.bat 1
- echo ==TIME_CONTROL_TRANS==
- echo TIME_CONTROL_TRANS >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\TIME_CONTROL_TRANS.bat 1
- echo ==TRANSACTION_TYPE==
- echo TRANSACTION_TYPE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\TRANSACTION_TYPE.bat 1
- echo ==UNIT_CHANGE_HIST==
- echo UNIT_CHANGE_HIST >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_CHANGE_HIST.bat 1
- echo ==UNIT_FILE==
- echo UNIT_FILE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_FILE.bat 1
- echo ==UNIT_LINK_EXT==
- echo UNIT_LINK_EXT >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_LINK_EXT.bat 1
- echo ==UNIT_SALES_PRICE_LOG==
- echo UNIT_SALES_PRICE_LOG >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_SALES_PRICE_LOG.bat 1
- echo ==UNIT_STATUS_HIST==
- echo UNIT_STATUS_HIST >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_STATUS_HIST.bat 1
- echo ==UNIT_TEMP_TAB_GRNI==
- echo UNIT_TEMP_TAB_GRNI >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_TEMP_TAB_GRNI.bat 1
- echo ==UNIT_TRANSFER_TAB==
- echo UNIT_TRANSFER_TAB >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_TRANSFER_TAB.bat 1
- echo ==UNIT_TYPE_FILE==
- echo UNIT_TYPE_FILE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_TYPE_FILE.bat 1
- echo ==UPDATE_OPTION==
- echo UPDATE_OPTION >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UPDATE_OPTION.bat 1
- echo ==VEHICLE==
- echo VEHICLE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEHICLE.bat 1
- echo ==VEHICLE_ACCRUALS==
- echo VEHICLE_ACCRUALS >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEHICLE_ACCRUALS.bat 1
- echo ==VEHICLE_DOCKETCARD==
- echo VEHICLE_DOCKETCARD >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEHICLE_DOCKETCARD.bat 1
- echo ==VEHICLE_EXTENSION==
- echo VEHICLE_EXTENSION >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEHICLE_EXTENSION.bat 1
- echo ==VEH_CARGRP_PURCHORIGIN==
- echo VEH_CARGRP_PURCHORIGIN >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_CARGRP_PURCHORIGIN.bat 1
- echo ==VEH_CLASSIFICATION_CODE==
- echo VEH_CLASSIFICATION_CODE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_CLASSIFICATION_CODE.bat 1
- echo ==VEH_IN_TRANSIT==
- echo VEH_IN_TRANSIT >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_IN_TRANSIT.bat 1
- echo ==VEH_LINK_EXT==
- echo VEH_LINK_EXT >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_LINK_EXT.bat 1
- echo ==VEH_MAX_STOCK==
- echo VEH_MAX_STOCK >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_MAX_STOCK.bat 1
- echo ==VEH_ORDER_HEADER==
- echo VEH_ORDER_HEADER >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_ORDER_HEADER.bat 1
- echo ==VEH_ORDER_LINE==
- echo VEH_ORDER_LINE >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_ORDER_LINE.bat 1
- echo ==VEH_ORDER_OPTION==
- echo VEH_ORDER_OPTION >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_ORDER_OPTION.bat 1
- echo ==VEH_TRANSACT_COLUMNS==
- echo VEH_TRANSACT_COLUMNS >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_TRANSACT_COLUMNS.bat 1
- echo ==VEH_TRANSACT_GRID==
- echo VEH_TRANSACT_GRID >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_TRANSACT_GRID.bat 1
- echo ==VEH_TRANSACT_GROUPS==
- echo VEH_TRANSACT_GROUPS >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_TRANSACT_GROUPS.bat 1
- echo ==VEH_TRANSMISSION_CODES==
- echo VEH_TRANSMISSION_CODES >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_TRANSMISSION_CODES.bat 1
- echo ==VPP25==
- echo VPP25 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP25.bat 1
- echo ==VPP28==
- echo VPP28 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP28.bat 1
- echo ==VPP2C==
- echo VPP2C >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP2C.bat 1
- echo ==VPP43==
- echo VPP43 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP43.bat 1
- echo ==VPP48==
- echo VPP48 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP48.bat 1
- echo ==VPP4K==
- echo VPP4K >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP4K.bat 1
- echo ==VPP51==
- echo VPP51 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP51.bat 1
- echo ==VPP53==
- echo VPP53 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP53.bat 1
- echo ==VPP5A==
- echo VPP5A >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP5A.bat 1
- echo ==VPP5M==
- echo VPP5M >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP5M.bat 1
- echo ==VPP5Q==
- echo VPP5Q >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP5Q.bat 1
- echo ==VPP5R==
- echo VPP5R >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP5R.bat 1
- echo ==VPP61==
- echo VPP61 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP61.bat 1
- echo ==VPP65==
- echo VPP65 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP65.bat 1
- echo ==VPP72==
- echo VPP72 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP72.bat 1
- echo ==VPP73==
- echo VPP73 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP73.bat 1
- echo ==VPP74==
- echo VPP74 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP74.bat 1
- echo ==VPP91==
- echo VPP91 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP91.bat 1
- echo ==VPP93==
- echo VPP93 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP93.bat 1
- echo ==VPPT1==
- echo VPPT1 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\VPPT1.bat 1
- echo ==WORKING_PERIOD==
- echo WORKING_PERIOD >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\WORKING_PERIOD.bat 1
- echo ==WORKSHOP_ORDER_SPLIT==
- echo WORKSHOP_ORDER_SPLIT >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\WORKSHOP_ORDER_SPLIT.bat 1
- echo ==WORKSHOP_PLANNING==
- echo WORKSHOP_PLANNING >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\WORKSHOP_PLANNING.bat 1
- echo ==WORKSHOP_TEAMS==
- echo WORKSHOP_TEAMS >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\WORKSHOP_TEAMS.bat 1
- echo ==WORK_LINE_STATUS==
- echo WORK_LINE_STATUS >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\WORK_LINE_STATUS.bat 1
- echo ==WORK_UNITS==
- echo WORK_UNITS >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\WORK_UNITS.bat 1
- echo ==ACCT_DOC_DATA==
- echo ACCT_DOC_DATA >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_DOC_DATA.bat 1
- echo ==ACCT_DOC_DATA_01==
- echo ACCT_DOC_DATA_01 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_DOC_DATA_01.bat 1
- echo ==ACCT_DOC_KEY==
- echo ACCT_DOC_KEY >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_DOC_KEY.bat 1
- echo ==ACCT_DOC_KEY_01==
- echo ACCT_DOC_KEY_01 >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_DOC_KEY_01.bat 1
- echo ==ACCT_DOC_SALESCLAS==
- echo ACCT_DOC_SALESCLAS >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_DOC_SALESCLAS.bat 1
- echo ==UNIT_CLASSIFICAT==
- echo UNIT_CLASSIFICAT >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_CLASSIFICAT.bat 1
- echo ==UNIT_HISTORY==
- echo UNIT_HISTORY >CON
- call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_HISTORY.bat 1
|