Etusivu Tutki Apua
Rekisteröidy Kirjaudu sisään
GlobalCube
/
C11
3
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Puu: f6fedc58f3
Haarat Tagit
C11
/
System
/
OPTIMA
/
SQL
/
batch
/
CUSTOMER_TRANSACT.bat

CUSTOMER_TRANSACT.bat 2.1 KB
Historia Raaka

123456789 
  1. @echo off 
    2. 

  2. rem ==CUSTOMER_TRANSACT==
    3. 

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

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

  5. rem Nur in Quelle: DEBT_COLLECTION;LS_CONTRACT_NUMBER
    6. 

  6. bcp "SELECT T1.[CUSTOMER_NUMBER], T1.[VOUCHER_NO], T1.[LINE_NO_CU], T1.[TRANSACTION_STATUS], T1.[DUE_DATE], T1.[BOOKKEEP_DATE], T1.[STATE_CODE], T1.[TRANSACT_DATE], T1.[HANDLER], T1.[CREATION_DATE], T1.[CREATION_TIME_8], T1.[STATUS], T1.[MODUL], T1.[BATCH_NUMBER], T1.[JOURNAL_NO], T1.[DOCUMENT_NO], T1.[DOCUMENT_DATE], T1.[DISCOUNT_DATE], T1.[DUNNING_DATE], T1.[START_INT_DATE], T1.[LAST_INT_DATE], T1.[PMT_TERM], T1.[DUNTIMES], T1.[TAX_CODE], T1.[REMINDER_CODE], T1.[SUM_C_U], T1.[TAX_C_U], T1.[CASH_DISCOUNT_C_U], T1.[INTEREST_PERC], T1.[PAID_C_U], T1.[COMMENT_CU], T1.[SETOFF_ACCT], T1.[COLLECT_ACCT], T1.[INTEREST_CALC], T1.[EEC_VAT_WORK_CODE], T1.[EEC_VAT_LIST_NO], T1.[SPLIT_CODE_CU], T1.[PMT_PROPOSAL], T1.[APPROVED], T1.[BOOK_NO], T1.[CHECK_NUMBER], T1.[ACTIVITY_CODE], T1.[SALES_TYPE], T1.[INT_VOUCHER_NO], T1.[DEPARTMENT], T1.[CONV_FLAG], T1.[timestamp], T1.[UNIQUE_IDENT], T1.[FEE_STATUS], '1' as \"Client_DB\" FROM [deop01].[dbo].[CUSTOMER_TRANSACT] T1  WHERE T1.[BOOKKEEP_DATE] >= '01.01.2018'" queryout "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_TRANSACT_1.csv" -S DADE053821 -d deop01 -U sa -P sybjdc -c -C 65001 -e "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_TRANSACT_1.queryout.log" > "C:\GlobalCube\System\OPTIMA\SQL\temp\OPTIMA\CUSTOMER_TRANSACT_1.bcp1.log" 
    7. 

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

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

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