Halaman utama Jelajahi Bantuan
Daftar Masuk
GlobalCube
/
C11
3
0
Fork 0
Berkas Masalah 0 Permintaan Tarik 0 Wiki
Pohon: f6fedc58f3
Ranting Tag
C11
/
System
/
OPTIMA
/
SQL
/
batch
/
ACCT_DOC_KEY.bat

ACCT_DOC_KEY.bat 2.3 KB
Riwayat Mentahan

123456789 
  1. @echo off 
    2. 

  2. rem ==ACCT_DOC_KEY==
    3. 

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

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

  5. rem Nur in Quelle: SKR51_COST_BEARER;SKR51_KEY
    6. 

  6. bcp "SELECT T1.[UNIQUE_IDENT], T1.[ACCT_NO], T1.[BOOKKEEP_DATE], T1.[BOOKKEEP_PERIOD], T1.[DOCUMENT_NO], T1.[BATCH_NO], T1.[JOURNAL_NO], T1.[BOOK_NO], T1.[ORIGIN], T1.[STATUS], T1.[DEBIT_AMOUNT], T1.[CREDIT_AMOUNT], T1.[DEBIT_QUANTITY], T1.[CREDIT_QUANTITY], T1.[AA_TRTYPE], T1.[SITE], T1.[STRATEGIC_AREA], T1.[DEPARTMENT], T1.[ACTIVITY], T1.[STOCK], T1.[MAKE_FAMILY], T1.[MAKE], T1.[VEHICLE_TYPE], T1.[MODEL_LINE], T1.[FACTORY_MODEL], T1.[WORKSHOP_MODEL], T1.[PRODUCT_GROUP], T1.[REPAIR_GROUP], T1.[KIT_GROUP], T1.[VAT_CODE_ORDER], T1.[TIME_CODE], T1.[INT_EXT_CODE], T1.[DESTINATION], T1.[PRICE_CODE], T1.[REDUCTION_CODE], T1.[VAT_RATE_CODE], T1.[MISC_NO], T1.[BOOKKEEPING_CODE], T1.[COST_REVENUE_CODE], T1.[REASON_CODE], T1.[PART_GROUP], T1.[OWN_DIMENSION_1], T1.[OWN_DIMENSION_2], T1.[OWN_DIMENSION_3], T1.[OWN_DIMENSION_4], T1.[OWN_DIMENSION_5], T1.[INT_VOUCHER_NO], T1.[BALANCING_MARK], T1.[ACCT_SCHEDULE_ID], T1.[REGISTER_NUMBER], T1.[PURCH_ORIGIN_CODE], T1.[USED_VEH_DEST_CODE], T1.[USE_OF_VEHICLE], T1.[ACCT_NO_NEXT_CHART], T1.[DEPARTMENT_NEXT_CHART], T1.[CONV_FLAG], T1.[timestamp], T1.[CL_DET_CODE], T1.[CL_TROUBLE_CODE], T1.[CL_TYPE], T1.[PURCH_SALESMAN], T1.[SALE_SALESMAN], '1' as \"Client_DB\" FROM [deop01].[dbo].[ACCT_DOC_KEY] T1  WHERE T1.[BOOKKEEP_DATE] >= '01.01.2019'" queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\ACCT_DOC_KEY_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\ACCT_DOC_KEY_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA2\ACCT_DOC_KEY_1.bcp1.log" 
    7. 

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

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

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