_OPTIMA.bat 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399
  1. @echo off & cd /d %~dp0
  2. del C:\GlobalCube\System\OPTIMA\SQL\temp\*.* /Q /F >nul 2>nul
  3. echo ==AA_TRTYPE==
  4. echo AA_TRTYPE >CON
  5. call C:\GlobalCube\System\OPTIMA\SQL\batch\AA_TRTYPE.bat 1
  6. echo ==ACCOUNT_INFO==
  7. echo ACCOUNT_INFO >CON
  8. call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCOUNT_INFO.bat 1
  9. echo ==ACCT_BALANCE==
  10. echo ACCT_BALANCE >CON
  11. call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_BALANCE.bat 1
  12. echo ==ACTIVITY==
  13. echo ACTIVITY >CON
  14. call C:\GlobalCube\System\OPTIMA\SQL\batch\ACTIVITY.bat 1
  15. echo ==APPORTIONED_INV_TIME==
  16. echo APPORTIONED_INV_TIME >CON
  17. call C:\GlobalCube\System\OPTIMA\SQL\batch\APPORTIONED_INV_TIME.bat 1
  18. echo ==APPORTIONED_USED_TIME==
  19. echo APPORTIONED_USED_TIME >CON
  20. call C:\GlobalCube\System\OPTIMA\SQL\batch\APPORTIONED_USED_TIME.bat 1
  21. echo ==CALENDAR_EVENT==
  22. echo CALENDAR_EVENT >CON
  23. call C:\GlobalCube\System\OPTIMA\SQL\batch\CALENDAR_EVENT.bat 1
  24. echo ==CALENDAR_INFO==
  25. echo CALENDAR_INFO >CON
  26. call C:\GlobalCube\System\OPTIMA\SQL\batch\CALENDAR_INFO.bat 1
  27. echo ==CALENDAR_PATTERN==
  28. echo CALENDAR_PATTERN >CON
  29. call C:\GlobalCube\System\OPTIMA\SQL\batch\CALENDAR_PATTERN.bat 1
  30. echo ==CAR_STATISTIC==
  31. echo CAR_STATISTIC >CON
  32. call C:\GlobalCube\System\OPTIMA\SQL\batch\CAR_STATISTIC.bat 1
  33. echo ==COMM_TRANS_UNIT==
  34. echo COMM_TRANS_UNIT >CON
  35. call C:\GlobalCube\System\OPTIMA\SQL\batch\COMM_TRANS_UNIT.bat 1
  36. echo ==COMM_UNIT==
  37. echo COMM_UNIT >CON
  38. call C:\GlobalCube\System\OPTIMA\SQL\batch\COMM_UNIT.bat 1
  39. echo ==COURTESY_CAR==
  40. echo COURTESY_CAR >CON
  41. call C:\GlobalCube\System\OPTIMA\SQL\batch\COURTESY_CAR.bat 1
  42. echo ==CUSTOMER==
  43. echo CUSTOMER >CON
  44. call C:\GlobalCube\System\OPTIMA\SQL\batch\CUSTOMER.bat 1
  45. echo ==CUSTOMER_TRANSACT==
  46. echo CUSTOMER_TRANSACT >CON
  47. call C:\GlobalCube\System\OPTIMA\SQL\batch\CUSTOMER_TRANSACT.bat 1
  48. echo ==DEPARTMENT_TYPE==
  49. echo DEPARTMENT_TYPE >CON
  50. call C:\GlobalCube\System\OPTIMA\SQL\batch\DEPARTMENT_TYPE.bat 1
  51. echo ==EMPLOYEE==
  52. echo EMPLOYEE >CON
  53. call C:\GlobalCube\System\OPTIMA\SQL\batch\EMPLOYEE.bat 1
  54. echo ==GLOBAL_MAKE==
  55. echo GLOBAL_MAKE >CON
  56. call C:\GlobalCube\System\OPTIMA\SQL\batch\GLOBAL_MAKE.bat 1
  57. echo ==GM_DRIVE_ORDER==
  58. echo GM_DRIVE_ORDER >CON
  59. call C:\GlobalCube\System\OPTIMA\SQL\batch\GM_DRIVE_ORDER.bat 1
  60. echo ==ORDER_ACCUMULATION==
  61. echo ORDER_ACCUMULATION >CON
  62. call C:\GlobalCube\System\OPTIMA\SQL\batch\ORDER_ACCUMULATION.bat 1
  63. echo ==ORDER_HEADER==
  64. echo ORDER_HEADER >CON
  65. call C:\GlobalCube\System\OPTIMA\SQL\batch\ORDER_HEADER.bat 1
  66. echo ==ORDER_LINE==
  67. echo ORDER_LINE >CON
  68. call C:\GlobalCube\System\OPTIMA\SQL\batch\ORDER_LINE.bat 1
  69. echo ==ORDER_OPEN_ITEMS==
  70. echo ORDER_OPEN_ITEMS >CON
  71. call C:\GlobalCube\System\OPTIMA\SQL\batch\ORDER_OPEN_ITEMS.bat 1
  72. echo ==ORDER_SERVICE_SCHEMES==
  73. echo ORDER_SERVICE_SCHEMES >CON
  74. call C:\GlobalCube\System\OPTIMA\SQL\batch\ORDER_SERVICE_SCHEMES.bat 1
  75. echo ==PERSON==
  76. echo PERSON >CON
  77. call C:\GlobalCube\System\OPTIMA\SQL\batch\PERSON.bat 1
  78. echo ==PERSON_INFO==
  79. echo PERSON_INFO >CON
  80. call C:\GlobalCube\System\OPTIMA\SQL\batch\PERSON_INFO.bat 1
  81. echo ==PRODUCT_FILE==
  82. echo PRODUCT_FILE >CON
  83. call C:\GlobalCube\System\OPTIMA\SQL\batch\PRODUCT_FILE.bat 1
  84. echo ==PRODUCT_STOCK_FILE==
  85. echo PRODUCT_STOCK_FILE >CON
  86. call C:\GlobalCube\System\OPTIMA\SQL\batch\PRODUCT_STOCK_FILE.bat 1
  87. echo ==PROFILE==
  88. echo PROFILE >CON
  89. call C:\GlobalCube\System\OPTIMA\SQL\batch\PROFILE.bat 1
  90. echo ==PROFILE_TYPE==
  91. echo PROFILE_TYPE >CON
  92. call C:\GlobalCube\System\OPTIMA\SQL\batch\PROFILE_TYPE.bat 1
  93. echo ==PUNCH==
  94. echo PUNCH >CON
  95. call C:\GlobalCube\System\OPTIMA\SQL\batch\PUNCH.bat 1
  96. echo ==PURCH_DISCOUNTS==
  97. echo PURCH_DISCOUNTS >CON
  98. call C:\GlobalCube\System\OPTIMA\SQL\batch\PURCH_DISCOUNTS.bat 1
  99. echo ==PURCH_DISC_TYPES==
  100. echo PURCH_DISC_TYPES >CON
  101. call C:\GlobalCube\System\OPTIMA\SQL\batch\PURCH_DISC_TYPES.bat 1
  102. echo ==SERVICE_2000_FILE==
  103. echo SERVICE_2000_FILE >CON
  104. call C:\GlobalCube\System\OPTIMA\SQL\batch\SERVICE_2000_FILE.bat 1
  105. echo ==SITE==
  106. echo SITE >CON
  107. call C:\GlobalCube\System\OPTIMA\SQL\batch\SITE.bat 1
  108. echo ==SUPPLIER==
  109. echo SUPPLIER >CON
  110. call C:\GlobalCube\System\OPTIMA\SQL\batch\SUPPLIER.bat 1
  111. echo ==SUPPLIER_TRANSACT==
  112. echo SUPPLIER_TRANSACT >CON
  113. call C:\GlobalCube\System\OPTIMA\SQL\batch\SUPPLIER_TRANSACT.bat 1
  114. echo ==TIME_CONTROL_END==
  115. echo TIME_CONTROL_END >CON
  116. call C:\GlobalCube\System\OPTIMA\SQL\batch\TIME_CONTROL_END.bat 1
  117. echo ==TIME_CONTROL_OPEN==
  118. echo TIME_CONTROL_OPEN >CON
  119. call C:\GlobalCube\System\OPTIMA\SQL\batch\TIME_CONTROL_OPEN.bat 1
  120. echo ==TIME_CONTROL_TRANS==
  121. echo TIME_CONTROL_TRANS >CON
  122. call C:\GlobalCube\System\OPTIMA\SQL\batch\TIME_CONTROL_TRANS.bat 1
  123. echo ==TRANSACTION_TYPE==
  124. echo TRANSACTION_TYPE >CON
  125. call C:\GlobalCube\System\OPTIMA\SQL\batch\TRANSACTION_TYPE.bat 1
  126. echo ==UNIT_CHANGE_HIST==
  127. echo UNIT_CHANGE_HIST >CON
  128. call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_CHANGE_HIST.bat 1
  129. echo ==UNIT_FILE==
  130. echo UNIT_FILE >CON
  131. call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_FILE.bat 1
  132. echo ==UNIT_LINK_EXT==
  133. echo UNIT_LINK_EXT >CON
  134. call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_LINK_EXT.bat 1
  135. echo ==UNIT_SALES_PRICE_LOG==
  136. echo UNIT_SALES_PRICE_LOG >CON
  137. call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_SALES_PRICE_LOG.bat 1
  138. echo ==UNIT_STATUS_HIST==
  139. echo UNIT_STATUS_HIST >CON
  140. call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_STATUS_HIST.bat 1
  141. echo ==UNIT_TEMP_TAB_GRNI==
  142. echo UNIT_TEMP_TAB_GRNI >CON
  143. call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_TEMP_TAB_GRNI.bat 1
  144. echo ==UNIT_TRANSFER_TAB==
  145. echo UNIT_TRANSFER_TAB >CON
  146. call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_TRANSFER_TAB.bat 1
  147. echo ==UNIT_TYPE_FILE==
  148. echo UNIT_TYPE_FILE >CON
  149. call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_TYPE_FILE.bat 1
  150. echo ==UPDATE_OPTION==
  151. echo UPDATE_OPTION >CON
  152. call C:\GlobalCube\System\OPTIMA\SQL\batch\UPDATE_OPTION.bat 1
  153. echo ==VEHICLE==
  154. echo VEHICLE >CON
  155. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEHICLE.bat 1
  156. echo ==VEHICLE_ACCRUALS==
  157. echo VEHICLE_ACCRUALS >CON
  158. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEHICLE_ACCRUALS.bat 1
  159. echo ==VEHICLE_DOCKETCARD==
  160. echo VEHICLE_DOCKETCARD >CON
  161. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEHICLE_DOCKETCARD.bat 1
  162. echo ==VEHICLE_EXTENSION==
  163. echo VEHICLE_EXTENSION >CON
  164. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEHICLE_EXTENSION.bat 1
  165. echo ==VEH_CARGRP_PURCHORIGIN==
  166. echo VEH_CARGRP_PURCHORIGIN >CON
  167. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_CARGRP_PURCHORIGIN.bat 1
  168. echo ==VEH_CLASSIFICATION_CODE==
  169. echo VEH_CLASSIFICATION_CODE >CON
  170. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_CLASSIFICATION_CODE.bat 1
  171. echo ==VEH_IN_TRANSIT==
  172. echo VEH_IN_TRANSIT >CON
  173. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_IN_TRANSIT.bat 1
  174. echo ==VEH_LINK_EXT==
  175. echo VEH_LINK_EXT >CON
  176. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_LINK_EXT.bat 1
  177. echo ==VEH_MAX_STOCK==
  178. echo VEH_MAX_STOCK >CON
  179. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_MAX_STOCK.bat 1
  180. echo ==VEH_ORDER_HEADER==
  181. echo VEH_ORDER_HEADER >CON
  182. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_ORDER_HEADER.bat 1
  183. echo ==VEH_ORDER_LINE==
  184. echo VEH_ORDER_LINE >CON
  185. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_ORDER_LINE.bat 1
  186. echo ==VEH_ORDER_OPTION==
  187. echo VEH_ORDER_OPTION >CON
  188. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_ORDER_OPTION.bat 1
  189. echo ==VEH_TRANSACT_COLUMNS==
  190. echo VEH_TRANSACT_COLUMNS >CON
  191. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_TRANSACT_COLUMNS.bat 1
  192. echo ==VEH_TRANSACT_GRID==
  193. echo VEH_TRANSACT_GRID >CON
  194. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_TRANSACT_GRID.bat 1
  195. echo ==VEH_TRANSACT_GROUPS==
  196. echo VEH_TRANSACT_GROUPS >CON
  197. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_TRANSACT_GROUPS.bat 1
  198. echo ==VEH_TRANSMISSION_CODES==
  199. echo VEH_TRANSMISSION_CODES >CON
  200. call C:\GlobalCube\System\OPTIMA\SQL\batch\VEH_TRANSMISSION_CODES.bat 1
  201. echo ==VPP25==
  202. echo VPP25 >CON
  203. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP25.bat 1
  204. echo ==VPP28==
  205. echo VPP28 >CON
  206. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP28.bat 1
  207. echo ==VPP2C==
  208. echo VPP2C >CON
  209. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP2C.bat 1
  210. echo ==VPP43==
  211. echo VPP43 >CON
  212. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP43.bat 1
  213. echo ==VPP48==
  214. echo VPP48 >CON
  215. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP48.bat 1
  216. echo ==VPP4K==
  217. echo VPP4K >CON
  218. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP4K.bat 1
  219. echo ==VPP51==
  220. echo VPP51 >CON
  221. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP51.bat 1
  222. echo ==VPP53==
  223. echo VPP53 >CON
  224. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP53.bat 1
  225. echo ==VPP5A==
  226. echo VPP5A >CON
  227. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP5A.bat 1
  228. echo ==VPP5M==
  229. echo VPP5M >CON
  230. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP5M.bat 1
  231. echo ==VPP5Q==
  232. echo VPP5Q >CON
  233. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP5Q.bat 1
  234. echo ==VPP5R==
  235. echo VPP5R >CON
  236. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP5R.bat 1
  237. echo ==VPP61==
  238. echo VPP61 >CON
  239. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP61.bat 1
  240. echo ==VPP65==
  241. echo VPP65 >CON
  242. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP65.bat 1
  243. echo ==VPP72==
  244. echo VPP72 >CON
  245. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP72.bat 1
  246. echo ==VPP73==
  247. echo VPP73 >CON
  248. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP73.bat 1
  249. echo ==VPP74==
  250. echo VPP74 >CON
  251. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP74.bat 1
  252. echo ==VPP91==
  253. echo VPP91 >CON
  254. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP91.bat 1
  255. echo ==VPP93==
  256. echo VPP93 >CON
  257. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPP93.bat 1
  258. echo ==VPPT1==
  259. echo VPPT1 >CON
  260. call C:\GlobalCube\System\OPTIMA\SQL\batch\VPPT1.bat 1
  261. echo ==WORKING_PERIOD==
  262. echo WORKING_PERIOD >CON
  263. call C:\GlobalCube\System\OPTIMA\SQL\batch\WORKING_PERIOD.bat 1
  264. echo ==WORKSHOP_ORDER_SPLIT==
  265. echo WORKSHOP_ORDER_SPLIT >CON
  266. call C:\GlobalCube\System\OPTIMA\SQL\batch\WORKSHOP_ORDER_SPLIT.bat 1
  267. echo ==WORKSHOP_PLANNING==
  268. echo WORKSHOP_PLANNING >CON
  269. call C:\GlobalCube\System\OPTIMA\SQL\batch\WORKSHOP_PLANNING.bat 1
  270. echo ==WORKSHOP_TEAMS==
  271. echo WORKSHOP_TEAMS >CON
  272. call C:\GlobalCube\System\OPTIMA\SQL\batch\WORKSHOP_TEAMS.bat 1
  273. echo ==WORK_LINE_STATUS==
  274. echo WORK_LINE_STATUS >CON
  275. call C:\GlobalCube\System\OPTIMA\SQL\batch\WORK_LINE_STATUS.bat 1
  276. echo ==WORK_UNITS==
  277. echo WORK_UNITS >CON
  278. call C:\GlobalCube\System\OPTIMA\SQL\batch\WORK_UNITS.bat 1
  279. echo ==ACCT_DOC_DATA==
  280. echo ACCT_DOC_DATA >CON
  281. call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_DOC_DATA.bat 1
  282. echo ==ACCT_DOC_DATA_01==
  283. echo ACCT_DOC_DATA_01 >CON
  284. call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_DOC_DATA_01.bat 1
  285. echo ==ACCT_DOC_KEY==
  286. echo ACCT_DOC_KEY >CON
  287. call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_DOC_KEY.bat 1
  288. echo ==ACCT_DOC_KEY_01==
  289. echo ACCT_DOC_KEY_01 >CON
  290. call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_DOC_KEY_01.bat 1
  291. echo ==ACCT_DOC_SALESCLAS==
  292. echo ACCT_DOC_SALESCLAS >CON
  293. call C:\GlobalCube\System\OPTIMA\SQL\batch\ACCT_DOC_SALESCLAS.bat 1
  294. echo ==UNIT_CLASSIFICAT==
  295. echo UNIT_CLASSIFICAT >CON
  296. call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_CLASSIFICAT.bat 1
  297. echo ==UNIT_HISTORY==
  298. echo UNIT_HISTORY >CON
  299. call C:\GlobalCube\System\OPTIMA\SQL\batch\UNIT_HISTORY.bat 1