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