Home Explore Help
Register Sign In
GlobalCube
/
C11
3
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: f6fedc58f3
Branches Tags
C11
/
System
/
OPTIMA
/
SQL
/
batch
/
VEH_ORDER_HEADER.bat

VEH_ORDER_HEADER.bat 3.4 KB
History Raw

12345678 
  1. @echo off 
    2. 

  2. rem ==VEH_ORDER_HEADER==
    3. 

  3. del C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_HEADER*.* /Q /F >nul 2>nul 
    4. 

  4. sqlcmd.exe -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -p -Q "TRUNCATE TABLE [import].[VEH_ORDER_HEADER]" 
    5. 

  5. bcp "SELECT T1.[ORDER_NUMBER], T1.[DEBIT_ACCOUNT], T1.[STATUS], T1.[STATE_KEY_DATE], T1.[INVOICE_NUMBER], T1.[DEPARTMENT], T1.[STATE_DELIV_DATE], T1.[STATE_CODE_VO], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[DELIVERY_ACCOUNT], T1.[USER_UPDATE_VO], T1.[SALESMAN], T1.[DEBIT_PERM], T1.[ORDER_DATE], T1.[DELIVERY_DATE], T1.[DELIVERY_PLACE], T1.[INVOICE_DATE], T1.[PMT_TERM], T1.[NEXT_LINE_NUMBER], T1.[PAYMENT_TEXT], T1.[INVOICE_COPY_CODE], T1.[TEXT_CODE_1], T1.[TEXT_CODE_2], T1.[TEXT_CODE_3], T1.[TEXT1_1_VO], T1.[TEXT1_2_VO], T1.[TEXT_FL1_VO], T1.[TEXT2_1_VO], T1.[TEXT2_2_VO], T1.[TEXT_FL2_VO], T1.[TEXT3_1_VO], T1.[TEXT3_2_VO], T1.[TEXT_FL3_VO], T1.[TEXT4_1_VO], T1.[TEXT4_2_VO], T1.[TEXT_FL4_VO], T1.[FLEET_OWNER], T1.[OPTION_SPECIFIC], T1.[VEHICLE_LINES_VO], T1.[ORDER_SUM_VO], T1.[REQ_NO], T1.[REFERENCE_NUMBER], T1.[DUEDATE_1], T1.[TITLE], T1.[NAME], T1.[STREET_ADDR], T1.[ADDR_2], T1.[ZIPCODE], T1.[MAIL_ADDR], T1.[ADDR_3], T1.[COUNTY], T1.[VEHICLE_SOLD], T1.[VEHICLE_SOLD_SUM], T1.[VEHICLE_PURCH], T1.[VEHICLE_PURCH_SUM], T1.[CHAIN_NUMBER], T1.[SYSTEM_INV_PERM], T1.[INTERNAL_CODE], T1.[PREV_STATUS], T1.[CREDIT_ORDER_VEH], T1.[TAX_HANDLING], T1.[TAX_PERC], T1.[DELIVERY_WAY_CODE], T1.[DELIVERY_TERM], T1.[CUSTOMER_GROUP], T1.[PRICE_CODE], T1.[STOCK], T1.[PLACE_CODE_2], T1.[INVOICE_DISC_PERC], T1.[ORDER_ARR_DATE_VO], T1.[OFFER], T1.[VEH_ORDER_TYPE], T1.[MAIN_ORDER_NO], T1.[SUB_ORDER_NO_1], T1.[SUB_ORDER_NO_2], T1.[SUB_ORDER_NO_3], T1.[SUB_ORDER_NO_4], T1.[SUB_ORDER_NO_5], T1.[SUB_ORDER_NO_6], T1.[SUB_ORDER_NO_7], T1.[SUB_ORDER_NO_8], T1.[SUB_ORDER_NO_9], T1.[SUB_ORDER_NO_10], T1.[TO_MICROFICHE], T1.[LANGUAGE_CODE], T1.[TAX_CODE_VO], T1.[INV_ROUNDING_VO], T1.[DEBT_NEW], T1.[CASH_AMOUNT], T1.[CNTRACT_DUE_DATE], T1.[CONTRACT_DATE], T1.[FAC_MODEL_CODE_L], T1.[CUSTOMER_SOLD], T1.[EXP_ARRIVAL_TIME], T1.[BOOK_NO], T1.[BOOK_NO_FLAG], T1.[REFERENCE_DATE], T1.[DEBET_DEPARTMENT], T1.[CUSTOMER_EAN_NUMBER], T1.[EAN_DEPARTMENT], T1.[EAN_REFERENCE], T1.[EAN_INTERNAL_ACCT], T1.[NWFAKT_MARKING], T1.[EXT_ORDER_NUMBER], T1.[DEAL_ID], T1.[PREORDER_ID], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[E_INVOICE], T1.[ACTUAL_INV_DATE_TIME], T1.[INV_FORM_CODE], T1.[START_INTEREST_DATE], T1.[NOVA_CONTACT_ORDER], T1.[REQ_REFERENCE], T1.[CONS_OCR], T1.[DEBIT_NO_CONS], T1.[CORRECTION_ORDER], T1.[DRIVER], T1.[OWNER_CODE], T1.[OWNER_CODE_2], T1.[ORIGINAL_INVOICE_NO], '1' as \"Client_DB\" FROM [deop01].[dbo].[VEH_ORDER_HEADER] T1 " queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_HEADER_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_HEADER_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_HEADER_1.bcp1.log" 
    6. 

  6. type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_HEADER_1.bcp1.log" | findstr -v "1000" 
    7. 

  7. bcp [import].[VEH_ORDER_HEADER] in "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_HEADER_1.csv" -S localhost\GLOBALCUBE -d OPTIMA -U sa -P Mffu3011# -c -C 65001 -m 1000 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_HEADER_1.in.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_HEADER_1.bcp2.log" 
    8. 

  8. type "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_HEADER_1.bcp2.log" | findstr -v "1000" 
    9.