home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 11 Util
/
11-Util.zip
/
BACKRE.ZIP
/
SQLDBACK.CMD
< prev
next >
Wrap
OS/2 REXX Batch file
|
1990-09-11
|
4KB
|
120 lines
/*
***********************************************************************
* WARNING * WARNING * WARNING * WARNING * WARNING * WARNING * WARNING *
***********************************************************************
IBM HAS DEDICATED THIS PROGRAM TO THE PUBLIC AND CLAIMS NO RIGHTS
AND PROVIDES NO WARRANTIES WHATSOEVER. IBM PROVIDES THIS PROGRAM
"AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
***********************************************************************
* WARNING * WARNING * WARNING * WARNING * WARNING * WARNING * WARNING *
***********************************************************************
Rexx Command File for Alternate Backup Database Utility
This command file is called by an alternate backup.exe that intercepted
the Database Manager call to the OS/2 Backup (C:\OS2\BACKUP.EXE) using
the same parameters passed in by the Database Manager.
This command file must be in the current directory that contains the
intercept alternate backup.exe (any directory in PATH).
The say '...' rexx commands lines can be removed from this file without
affecting the execution, there will be no screen comments.
The user of this command file is responsible for verifying any changes
made to this file. SEE WARNING!
Input parameters: D:\path\*.* drive /s </m/a>
*/
arg dbdir drivei option1 option2
say ' '
say 'SQLDBACK.CMD' dbdir drivei option1 option2
say ' '
/*******************************************************/
/* SELECT A METHOD TO DO BACKUP BY MOVING COMMENT LINE */
/*******************************************************/
/* METHOD 1. IS SELECTED ......................................................
BACKUP THE DATABASE AS DBM DOES CURRENTLY
MOVE THIS 'COMMENT LINE' BEFORE 'C:\OS2\BACKUP... ' TO SELECT METHOD 1, OR */
'C:\OS2\BACKUP.EXE' dbdir drivei option1 option2
/* MOVE 'COMMENT LINE' BEFORE THIS LINE TO DESELECT METHOD 1................ */
/* METHOD 2. ..................................................................
BACKUP THE DATABASE TO INPUT DRIVE, BUT ALSO USE XCOPY TO COPY TO MEDIA
BEGIN: BACKUP UP TO DISKETTE ONLY THOSE FILE NEEDED TO FOOL DBM.
1. DBM CREATES SQLxxxxx.UIF DIR
2. OS/2 BACKUP.EXE CREATES BACKUP.001 AND CONTROL.001
3. DBM CHECKS SQLxxxxx.UIF DIR AND CONTROL.001 FILE
4. XCOPY ALL FILES TO DESIRED DIRECTORY
END: MOVE 'COMMENT LINE' AFTER HERE TO SELECT ALTERNATE METHOD 2
drivec = FILESPEC("DRIVE", dbdir)
pathc = FILESPEC("PATH", dbdir)
namec = FILESPEC("NAME", dbdir)
filec = "SQL00001.*"
dbdirc = drivec||pathc||filec
'C:\OS2\BACKUP.EXE' dbdirc drivei option1 option2
'XCOPY' dbdir 'E:\'
MOVE THIS 'COMMENT LINE' AFTER 'END: MOVE ...' LINE TO SELECT METHOD 2 , OR */
/* MOVE 'COMMENT LINE' BEFORE THIS LINE TO DESELECT METHOD 2................ */
/* METHOD 3. ..................................................................
BACKUP THE DATABASE TO INPUT DRIVE, BUT ALSO USE _____ TO COPY TO MEDIA
BEGIN: BACKUP UP TO DISKETTE ONLY THOSE FILE NEEDED TO FOOL DBM.
1. DBM CREATES SQLxxxxx.UIF DIR
2. OS/2 BACKUP.EXE CREATES BACKUP.001 AND CONTROL.001
3. DBM CHECKS SQLxxxxx.UIF DIR AND CONTROL.001 FILE
4. USER PROVIDED PROGRAM CAN BE EXECUTED HERE
END: MOVE 'COMMENT LINE' AFTER HERE TO SELECT ALTERNATE METHOD 3
drivec = FILESPEC("DRIVE", dbdir)
pathc = FILESPEC("PATH", dbdir)
namec = FILESPEC("NAME", dbdir)
filec = "SQL00001.*"
dbdirc = drivec||pathc||filec
'C:\OS2\BACKUP.EXE' dbdirc drivei option1 option2
say '_USER_PROGRAM_HERE_'
MOVE THIS 'COMMENT LINE' AFTER 'END: MOVE ...' LINE TO SELECT METHOD 3 , OR */
/* MOVE 'COMMENT LINE' BEFORE THIS LINE TO DESELECT METHOD 3................ */
exit RC