高手帮忙把这段转换成bat

Ann725 2011-05-18 04:47:48
#!/usr/bin/ksh

# Input Parameters
# 1) T2_SYS_PWD
# 2) T2_TNSNAME
# 3) T2_SCHEMA_NAME
# 4) T2_SCHEMA_PWD
# 5) AR_SCHEMA_NAME
# 6) AR_SCHEMA_PWD

T2_SYS_PWD=$1
T2_TNSNAME=$2
T2_SCHEMA_NAME=$3
T2_SCHEMA_PWD=$4
AR_SCHEMA_NAME=$5
AR_SCHEMA_PWD=$6

usage()
{
echo ""
echo "USAGE:"
echo 'Full_Build_AR.sh T2_SYS_PWD T2_TNSNAME T2_SCHEMA_NAME T2_SCHEMA_PWD AR_SCHEMA_NAME AR_SCHEMA_PWD'
echo ' '
}

if (( $# < 6 ))
then
echo "Not enough parameters passed in!"
usage
exit 1
fi

start_time=`date`
echo ------* THE compile script BEGIN $start_time *------

echo Executing AR_USERSCHEMA.sql
sqlplus -L -S SYS/$T2_SYS_PWD@$T2_TNSNAME as SYSDBA @AR_USERSCHEMA.sql $AR_SCHEMA_NAME $AR_SCHEMA_PWD $T2_SCHEMA_NAME
echo .

echo Executing RPS_AR_FILE_AUTHORING.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_AUTHORING.sql
echo .

echo Executing GRANT_AUTHORING.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @GRANT_AUTHORING.sql $T2_SCHEMA_NAME $AR_SCHEMA_NAME
echo .

echo Executing Recompile_AR_Processing.sql
sqlplus -L -S $T2_SCHEMA_NAME/$T2_SCHEMA_PWD@$T2_TNSNAME @Recompile_AR_Processing.sql
echo .

echo Executing RPS_AR_FILE_FAR001.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_FAR001.sql
echo .

echo Executing RPS_AR_FILE_SAF001.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_SAF001.sql
echo .

echo Executing RPS_AR_FILE_SWC500.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_SWC500.sql
echo .

echo Executing RPS_AR_FILE_TXU3003.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_TXU3003.sql
echo .

echo Executing RPS_AR_FILE_UNI002.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_UNI002.sql
echo .

echo Executing RPS_AR_FILE_WFM151.sql
sqlplus -L -S $AR_SCHEMA_NAME/$AR_SCHEMA_PWD@$T2_TNSNAME @execute_and_exit.sql RPS_AR_FILE_WFM151.sql
echo .

end_time=`date`
echo ------* THE compile package END $end_time *--------

exit
...全文
79 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
alalei_ice 2011-05-23
  • 打赏
  • 举报
回复
新建文本文档 把代码贴进去
然后另存为.bat 文件就行
以后都这么做
hmklove 2011-05-20
  • 打赏
  • 举报
回复
学习下
everyday725 2011-05-20
  • 打赏
  • 举报
回复
进来学习下
Ann725 2011-05-19
  • 打赏
  • 举报
回复
[Quote=引用 1 楼 ljc007 的回复:]
BatchFile code
@echo off
rem Input Parameters
rem 1) T2_SYS_PWD
rem 2) T2_TNSNAME
rem 3) T2_SCHEMA_NAME
rem 4) T2_SCHEMA_PWD
rem 5) AR_SCHEMA_NAME
rem 6) AR_SCHEMA_PWD

set T2_SYS_PWD=%1
se……
[/Quote]
有错误 ,很多错,该打印的都没打印
ljc007 2011-05-19
  • 打赏
  • 举报
回复
[code=BatchFile]@echo off
rem Input Parameters
rem 1) T2_SYS_PWD
rem 2) T2_TNSNAME
rem 3) T2_SCHEMA_NAME
rem 4) T2_SCHEMA_PWD
rem 5) AR_SCHEMA_NAME
rem 6) AR_SCHEMA_PWD

set T2_SYS_PWD=%1
set T2_TNSNAME=%2
set T2_SCHEMA_NAME=%3
set T2_SCHEMA_PWD=%4
set AR_SCHEMA_NAME=%5
set AR_SCHEMA_PWD=%6

if "%6" equ "" (
echo "Not enough parameters passed in!"
goto :usage
exit 1
)


set start_time=%date% %time%
echo ------* THE compile script BEGIN %start_time% *------

echo Executing AR_USERSCHEMA.sql
sqlplus -L -S SYS/%T2_SYS%_PWD@%T2_TNSNAME% as SYSDBA @AR_USERSCHEMA.sql %AR_SCHEMA_NAME% %AR_SCHEMA_PWD% %T2_SCHEMA_NAME%
echo,

echo Executing RPS_AR_FILE_AUTHORING.sql
sqlplus -L -S %AR_SCHEMA_NAME%/%AR_SCHEMA_PWD%@%T2_TNSNAME% @execute_and_exit.sql RPS_AR_FILE_AUTHORING.sql
echo,

echo Executing GRANT_AUTHORING.sql
sqlplus -L -S %AR_SCHEMA_NAME%/%AR_SCHEMA_PWD%@%T2_TNSNAME% @GRANT_AUTHORING.sql %T2_SCHEMA_NAME% %AR_SCHEMA_NAME%
echo,

echo Executing Recompile_AR_Processing.sql
sqlplus -L -S %T2_SCHEMA_NAME%/%T2_SCHEMA_PWD%@%T2_TNSNAME% @Recompile_AR_Processing.sql
echo,

echo Executing RPS_AR_FILE_FAR001.sql
sqlplus -L -S %AR_SCHEMA_NAME%/%AR_SCHEMA_PWD%@%T2_TNSNAME% @execute_and_exit.sql RPS_AR_FILE_FAR001.sql
echo,

echo Executing RPS_AR_FILE_SAF001.sql
sqlplus -L -S %AR_SCHEMA_NAME%/%AR_SCHEMA_PWD%@%T2_TNSNAME% @execute_and_exit.sql RPS_AR_FILE_SAF001.sql
echo,

echo Executing RPS_AR_FILE_SWC500.sql
sqlplus -L -S %AR_SCHEMA_NAME%/%AR_SCHEMA_PWD%@%T2_TNSNAME% @execute_and_exit.sql RPS_AR_FILE_SWC500.sql
echo,

echo Executing RPS_AR_FILE_TXU3003.sql
sqlplus -L -S %AR_SCHEMA_NAME%/%AR_SCHEMA_PWD%@%T2_TNSNAME% @execute_and_exit.sql RPS_AR_FILE_TXU3003.sql
echo,

echo Executing RPS_AR_FILE_UNI002.sql
sqlplus -L -S %AR_SCHEMA_NAME%/%AR_SCHEMA_PWD%@%T2_TNSNAME% @execute_and_exit.sql RPS_AR_FILE_UNI002.sql
echo,

echo Executing RPS_AR_FILE_WFM151.sql
sqlplus -L -S %AR_SCHEMA_NAME%/%AR_SCHEMA_PWD%@%T2_TNSNAME% @execute_and_exit.sql RPS_AR_FILE_WFM151.sql
echo,

set end_time=%date% %time%
echo ------* THE compile package END %end_time% *--------

exit

:usage
echo,
echo "USAGE:"
echo "Full_Build_AR.sh T2_SYS_PWD T2_TNSNAME T2_SCHEMA_NAME T2_SCHEMA_PWD AR_SCHEMA_NAME AR_SCHEMA_PWD"
echo,
[/code]

6,849

社区成员

发帖
与我相关
我的任务
社区描述
Windows 2016/2012/2008/2003/2000/NT
社区管理员
  • Windows Server社区
  • qishine
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧