Posted by: F R Bhote I just saw a mail on the Unify forum where someone wanted to unload and load
a table without using Sqltalk. As I can never log into those forums - it says
all my ids / passwords are wrong - and I much prefer this forum, I am
attaching a small program that does this.
It also has functions to create a new database with the same schema (I have
done it for one table in the ISLAND database).
As I have all sorts of SB 11 client stuff installed on my PC, I cannot
really test it - SB 11 gives all sorts of funny errors when on SB < 9.x
works fine. So if there are any goof ups, my apologies. And if anyone can
figure out why these ridiculous errors come on SB 11 I would be grateful for
the information.
Don't want to put too much in, so I have not added functions like
Rollforward ( to end / end ) but it is quite simple and the functions are
defined too - something like:
Code: Select all
sqlcsv( nServer, sServerName, '' ) ! Connect server
sqlind( nServer, sDB, 0 ) ! Install database
sqlrof( nServer, sDB, 0, 1, 0, 0 ) ! Rollforward BEGIN
sqlrlf(nServer, sDB, 0, sLogPath, 0, TRUE, TRUE ) ! Restore logs / Rollforward to end
sqlenr(nServer,sDB,0) ! Rollforward END