1. Unload .DBS, or
2. Create .DBS & LOAD, or
3. LOAD into existing .DBS, or
4. UNLOAD, DROP .DBS, CREATE .DBS, LOAD = Reorganize
16 bit VERSION ONLY:
32 bit VERSION ONLY:
Servername must ALWAYS be typed in. LOCAL32 is assumed by program
- Compiled SBCAPI.EXE can be run from command line like this using
C:\WINDOWS C:\yourdir\SBCAPInn.EXE A B C D E F G H
where the A can be 1, 2, 3 or 4
A = 1 = Unload .DBS
2 = Create .DBS & LOAD
3 = LOAD into existing .DBS
4 = Reorganize
B can be 0 or 1, 0 = stay in windows, 1 = shut down windows.
C = YOURDB
D = USER
E = PASSWORD
F = C:\DIR\YOURDB.SQL
G = SERVERNAME
H = SERVERPASSWORD
16 bit only: The SERVERNAME & SERVERPASSWORD can be omitted. Omit it if you run local .DBS [Batch-processing NOT testet in W'95]
32 bit only, or 16 bit aginst 32 bit backend: The SERVERNAME must be filled
16 bit backend: Omit the SERVERNAME & SERVERPASSWORD as a start. = the job will run local.
Also: the dbname should be typed in without the .DBS extension
and the .SQL-filename must be FULLY qualified.
16 bit & 16 bit backend: If servername is omitted, .LOG,.OK1, .OK2 & .OK3 files will be created in dir of .SQL file
USE SQL or C/API
Both methods for load & unload are available
Which do you think is the fastets method ?
If your .SQL is located on the server it must be specified by volume/directory instead by mapped devices.
All components are named SBCAPI*.*, simply remove them.
ver 1.00 - The trial run.
ver 1.01 - Small cosmetic fixes, correct calculation off runtime.
ver 1.02 - Options for customizing unload/load
ver 1.03 - NoRecovery removed from unload (no benefit).
Workaround for show/print big .OK? files, due to limitations
off NOTEPAD.EXE, Show/print .OK? changed to an option.
ver 1.04 - CTD version, Dialog-box to pickup .SQL filenames,
New filenames: SBCAPI16.APT & SBCAPI32.APT, Documentation available from formwindow
Have fun, comments are welcome ;--))
Carsten Barner Nielsen
ISS Data A/S, Copenhagen, Denmark
Return to http://gupta.narod.ru/ctd/