Oracle_sqlload derivative case

File Address:
Http://115.com/lb/5lbbut5jc6op

The sql_load derivative in the case is common to 5 files, namely bat, CTL, TXT, log, bad 5 files

BAT file:

--Username/user Password @ database sqlldr userid= ODS/ods@AMLDB--Call the CTL control file=d:/import/istaudit/Sx01_business_putout.ctl--Bad file and error detail if wrong derivative=d:/import/istaudit/shell/bad/Sx01_business_putout.bad -- command execution complete generates log log file details log=d:/import/istaudit/shell/log/sx01_business_putout.  Log Errors=99999999             

CTL file:

--Load TXT file dataLOADDatainfile‘D:/import/istaudit/del_file/sx01_org_info. Txt'discardmax 999999999999-- Delete ods.sx01_org_info table and insert TXT file data TRUNCATE into table  Ods. Sx01_org_info--TXT file data fields are separated by |@ field TERMINATED by '|@'-- The following words field and ods.sx01_ Org_info and TXT file data field position consistent TRAILING nullcols (ORGID "trim (: ORGID)", Sortno "trim (: Sortno)", OrgName "trim (: OrgName)") 

TXT file:

 --112| @112| @ Innovation Business Department