if exist %statFile2% ( >>%statFile2% set/p=,%%inul ) else ( >>%statFile2% set/p=%%inul )
echo off
set csvpath=測(cè)試數(shù)據(jù)
set sqluldr=D:\sqluldr\sqluldr2sdk\sqluldr2
set sqlpath=導(dǎo)出模板
rem set filename=產(chǎn)品行情
rem sqluldr2 gtcustomer/passwd file=%csvpath%\%filename%.csv text=csv field=, sql=exp%filename%.sql log=%csvpath%\%filename%.log
rem
rem set filename=產(chǎn)品行情更新
rem sqluldr2 gtcustomer/passwd file=%csvpath%\%filename%.csv text=csv field=, sql=exp%filename%.sql log=%csvpath%\%filename%.log
set expfpath=百萬級(jí)
echo 導(dǎo)出%expfpath%數(shù)據(jù):
for %%i in (%sqlpath%\%expfpath%\exp*.sql) do (
set /p="導(dǎo)出數(shù)據(jù): %%~ni"nul
%sqluldr% gtcustomer/passwd file=%csvpath%\%expfpath%\%%~ni.csv text=csv field=, sql=%%i log=%csvpath%\%expfpath%\%%~ni.log
echo ............ok.
)
set expfpath=千萬級(jí)
echo 導(dǎo)出%expfpath%數(shù)據(jù):
for %%i in (%sqlpath%\%expfpath%\exp*.sql) do (
set /p="導(dǎo)出數(shù)據(jù): %%~ni"nul
%sqluldr% gtcustomer/passwd file=%csvpath%\%expfpath%\%%~ni.csv text=csv field=, sql=%%i log=%csvpath%\%expfpath%\%%~ni.log
echo ............ok.
)
pause