Startsida Utforska Hjälp
Registrera dig Logga in
GlobalCube
/
C11
3
0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki
Träd: 076767c89e
Grenar Taggar
C11
/
System
/
OPTIMA
/
SQL
/
batch
/
VPP61.bat

VPP61.bat 2.1 KB
Historik Rå

123456789 
  1. @echo off 
    2. 

  2. rem ==VPP61==
    3. 

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

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

  5. rem Nur in Quelle: LEXUS_DEALER;FIAT_DEALER;DACIA_DEALER;BRANCH_NO_2
    6. 

  6. bcp "SELECT T1.[STOCK], T1.[STATE_CODE_PARAM], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[STOCK_NAME], T1.[STOCK_INTEREST], T1.[SERVICE_FACTOR_ALPHA], T1.[SERVICE_FACTOR], T1.[BEH_CHECK], T1.[LOCKED], T1.[LOCKED_TEXT], T1.[LOCKED_TEXT1], T1.[LOCKED_TEXT2], T1.[ZERO_QNT_LIST], T1.[NOCARD_ON_ZERO_LIST], T1.[TOYOTA_DEALER], T1.[VOLVO_DEALER], T1.[CALC_MIN_IN_STOCK], T1.[FORD_DEALER], T1.[GOD_DEALER], T1.[UDAS_HANDLER], T1.[BRANCH_NO], T1.[FORD_STOCK_ID], T1.[FORD_PART_DEALER], T1.[PSA_F_DEALER], T1.[NCG_DEALER], T1.[RENAULT_DEALER], T1.[VO_DEALER], T1.[OPEL_COMM_DEALER], T1.[OPEL_DEALER], T1.[USE_SECTIONS], T1.[USE_TOTAL_CHECK], T1.[USE_FIRST_PART_CHECK], T1.[USE_RE_COUNT], T1.[FREEZE], T1.[FORM_STOCK_VARIANCE], T1.[FORM_INVENTORY], T1.[FUNC_STOCK_CHECK], T1.[LINES_PER_SECTION], T1.[DIFF_LIST_WANTED], T1.[BLOCK_NEGATIVE_STOCK], T1.[LIST_NO_SERIES], T1.[DUMMY_LIST_NO_SERIES], T1.[LIST_EXT_NO_SERIES], T1.[EXT_JOB_NO_SERIES], T1.[APPROVE_BEFORE_INTAKE], T1.[BACK_ORDER_PERM], T1.[IV_SUB_DEALER_NO], T1.[SPEC_PURCH_PRICE], T1.[timestamp], T1.[UNIQUE_IDENT], '1' as \"Client_DB\" FROM [deop01].[dbo].[vPP61] T1 " queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VPP61_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VPP61_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\VPP61_1.bcp1.log" 
    7. 

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

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

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