DSXchange

Code: Select all

@Echo OFF
REM ***************************************************************************
REM ** Accept the name of a DataStage Project and create the backup of that  **
REM ** project in the current directory with the Date and Time appended to   **
REM ** project name.                                                         **
REM **                                                                       **
REM ** Revision: $Id$                                                        **
REM ** CR: 01422892                                                          **
Rem **                                                                       **
REM ** Vers. Date       User     Comments                                    **
REM ** ===== ========== ======== ============================================**
Rem ** 1.0.0 18-05-2005 AWussing Initial coding, testing & Implementation.   **
Rem ** 1.0.1 26-05-2005 AWussing Changed filenames around.                   **
Rem **                                                                       **
REM ***************************************************************************
   Rem ** Define constants **
   Rem **********************
   Set DataStageUserId=dsdev
   Set DataStagePassword=NoWayAreYouGettingMyPassword
   Set DataStageServer=mucfsd11
   Set CURRDATE=CurrentDate.Tmp
   Set CURRTIME=CurrentTime.Tmp
   Set LogFile=BackupLogFile

   Rem *************************
   Rem ** Begin program logic **
   Rem *************************
   TITLE BackupProjects
   IF %1.==. GoTo USAGE

   Rem ****************************************************
   Rem ** temporarily write current date & time to files **
   Rem ****************************************************
   DATE /T > %CURRDATE%
   TIME /T > %CURRTIME%

   Set PARSEARG="eol=; tokens=1,2,3,4* delims=/, "
   For /F %PARSEARG% %%i in (%CURRDATE%) Do SET YYYYMMDD=%%l%%k%%j

   Set PARSEARG="eol=; tokens=1,2,3* delims=:, "
   For /F %PARSEARG% %%i in (%CURRTIME%) Do Set HHMM=%%i%%j%%k

   c:\Progra~1\Ascential\DataST~1.5\dsexport.exe /H=%DataStageServer% /U=%DataStageUserId% /P=%DataStagePassword% %1 %YYYYMMDD%%HHMM%_%1.dsx
   GoTo END


:USAGE
   Echo Usage: ProjectBackup.bat {ProjectName }
   Echo Backs up DataStage project {ProjectName} to local file YYYYMMDDHHMMSS{ProjectName}.dsx
   Echo This is designed to be run at night as it does no error checking, i.e. when users are 
   Echo still logged into the project.

   GoTo END

:END
REM
TITLE Command Prompt