Andrew,
Batch parameters are referred to as %1, %2 etc
%0 is the name of the calling command.
%* refers to all parameters
You can use the shift command to move parameters (do help shift)
As an example:
C:\batch>type param_test.bat
@echo off
echo %1
echo %2
echo %0
echo %*
C:\batch>
C:\batch>
C:\batch>param_test.bat one two three four five
one
two
param_test.bat
one two three four five
C:\batch>
To append the date / time, use the for command to split up the output of
time and date commands.
For example:
C:\batch> test_time.bat
[08504789]
[0604Mon]
-------------------------------------------
@echo off
rem test_time.bat
call :get_timestamp
call :get_datestamp
goto :EOF
:::::::::::::::::::::::::::::::::::::::::::::::::::::::
:get_timestamp
:: get the time in format hhmmssxx, where 'xx' is hundredths of a
second
:: because want ssxx can not use time/t
for /f "tokens=1-8 delims=:. " %%a in ('echo.^| time ^| find "current"')
do (
set zhh=%%e
set zmm=%%f
set zss=%%g
set zxx=%%h
)
if 10 GTR %zhh% set zhh=0%zhh%
:: assign the values to ztimefull
set ztimefull=%zhh%%zmm%%zss%%zxx%
echo [%ztimefull%]
rem cleanup
set zhh=
set zmm=
set zss=
set zxx=
goto :EOF
:::::::::::::::::::::::::::::::::::::::::::::::::::::::
:get_datestamp
:: get the time in format yyyymmdd
for /f "tokens=1-8 delims=:.-/ " %%a in ('echo.^| date ^| find
"current"') do (
set zyyyy=%%h
set zmm=%%g
set zdd=%%f
)
:: assign the values to zdatefull
set zdatefull=%zyyyy%%zmm%%zdd%
echo [%zdatefull%]
rem cleanup
set zyyyy=
set zmm=
set zdd=
goto :EOF
:::::::::::::::::::::::::::::::::::::::::::::::::::::::
-------------------------------------------
A more useful example of parameters might be:
@echo off
rem PURPOSE
rem delete_oldfiles.bat
rem deletes files greater than or equal to x days old
rem Note - directories are not deleted.
rem does not delete read only, hidden or system files
rem 18-Apr-2000 , Bruce Reardon : Creation.
rem USEAGE
rem Parameters - %1 = path , %2 = file mask ,
rem %3 = how many days old , %4 (optional) - recurse
rem ASSUMPTIONS
rem none.
rem REQUIRES
rem forfiles.exe - distributed with NT Resource kit
rem that forfiles.exe be located at c:\nt4reskit
rem SIDE EFFECTS
rem envdelold env variable will be overwritten and deleted if it exists.
rem MODIFICATIONS
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
rem Parameter validation.
IF "%3"=="" goto param_problem :: not enough params
IF NOT "%5"=="" goto param_problem :: too many params
rem check parameter 3 is a valid number
set envdelold=
IF "%3"=="0" goto param3_ok
set /a envdelold = 1*%3 2> nul:
IF "%envdelold%"=="0" goto param3_problem
IF "%envdelold%"=="" goto param3_problem
:param3_ok
IF NOT "%4"=="" IF NOT "%4"=="-s" goto param4_problem :: invalid param 4
IF NOT EXIST %1. goto param1_problem
rem we now have 3 (possibly 4) parameters and they have been
validated.
echo %1 %2 %3 %4
rem the actual command - put quotes around to allow for names with
spaces.
c:\nt4reskit\forfiles -p%1 -m%2 %4 -d-%3 -c"cmd /c if @ISDIR==FALSE del
0x22@FILE0x22"
goto end
:param_problem
echo %0
echo ERROR - Must pass in 3 parameters (4 max)
echo Param 1 is the path
echo Param 2 is file mask
echo Param 3 is number of days
echo Param 4 (optional) : if "-s" then recurse subdir's.
echo.
echo eg "%0 c:\temp *.* 5" would delete ALL files in c:\temp directory 5
or more days old
goto end
:param1_problem
echo "%0 [-->[%1]<--] %2 %3 %4"
echo ERROR - 1st parameter invalid
echo Param 1 is the path and it must exist.
echo.
echo eg "%0 c:\temp *.* 5" would delete ALL files
echo in c:\temp directory 5 or more days old
goto end
:param3_problem
echo "%0 %1 %2 [-->[%3]<--] %4"
echo ERROR - 3rd parameter invalid
echo Param 3 is the number of days and it must be a valid number
echo.
echo eg "%0 c:\temp *.* 5" would delete ALL files
echo in c:\temp directory 5 or more days old
goto end
:param4_problem
echo "%0 %1 %2 %3 [-->[%4]<--]"
echo ERROR - 4th parameter invalid
echo Param 4 (optional) : must be "-s" (to recurse subdir's) or be
blank.
echo.
echo eg "%0 c:\temp *.* 5 -s" would delete ALL files
echo in c:\temp directory (incl subdirs) 5 or more days old
goto end
:end
rem - batch file finished
set envdelold=
-------------------------------------------
-----Original Message-----
Sent: Sunday, 3 June 2001 9:15
Hi,
I have couple of questions about bat file in NT 4.0
for Oracle 8.1.5.
1. how to make bat file take parameters. I had a
backup.bat, and like to pass in Oracle SID, so the
script can backup any database.
2. in the bat file, how to dynamically append
date/time into a directory name, like
backup_06022001121314
Thank you!
Andrea
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
