Inicio Explorar Axuda
Rexistro Iniciar sesión
GlobalCube
/
C11
3
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: f6fedc58f3
Ramas Etiquetas
C11
/
System
/
OPTIMA
/
SQL
/
batch
/
VEH_ORDER_LINE.bat

VEH_ORDER_LINE.bat 2.1 KB
Histórico Raw

12345678 
  1. @echo off 
    2. 

  2. rem ==VEH_ORDER_LINE==
    3. 

  3. del C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_LINE*.* /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_LINE]" 
    5. 

  5. bcp "SELECT T1.[ORDER_NUMBER], T1.[LINE_NUMBER], T1.[UNIT_NUMBER], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[STATE_CODE], T1.[PERSON_CODE], T1.[PROGRAM], T1.[FUNCTION_CODE], T1.[VEHICLE_TYPE_VO], T1.[LAYOUT_TYPE], T1.[REGISTER_NUMBER], T1.[CHASSIS_NUMBER], T1.[DELIVERY_DATE], T1.[TEXT_CODE_1], T1.[TEXT_CODE_2], T1.[TEXT_CODE_3], T1.[PROMISSED_PRICE], T1.[VEHICLE_SUM_OLD], T1.[VEHICLE_SUM_NEW], T1.[OPTION_LINES], T1.[VAT_HANDLING], 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.[LINE_TYPE_VEH], T1.[UPDATE_VO], T1.[SALE_VO], T1.[PRINT_LAYOUT], T1.[MILEAGE], T1.[SALEREF], T1.[VAT_RATE_CODE], T1.[DISC_CODE_1], T1.[DISC_PCT_1], T1.[DISC_PCT_2], T1.[DISC_AMOUNT_1], T1.[DISC_AMOUNT_2], T1.[NOVA_CALC_FLAG], T1.[NOVA_AMOUNT], T1.[NOVA_EXCEPT_CODE], T1.[NOVA_EXCEPT_TEXT], T1.[ACCOUNTING_CODE], T1.[CREATE_MSC], T1.[BOOK_NO], T1.[CONTRACT_NUMBER], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], '1' as \"Client_DB\" FROM [deop01].[dbo].[VEH_ORDER_LINE] T1 " queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_LINE_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_LINE_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_LINE_1.bcp1.log" 
    6. 

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

  7. bcp [import].[VEH_ORDER_LINE] in "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_LINE_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_LINE_1.in.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VEH_ORDER_LINE_1.bcp2.log" 
    8. 

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