SqlBase API Functions

forum.sourcecode (2000-2005) & forum.td.sourcecode (2005-2010)
Posts: 2206
Joined: 09 Mar 2017, 05:32
Location: Hyderabad, India

SqlBase API Functions

Post by FRBhote » 25 Apr 2008, 15:51

 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
You do not have the required permissions to view the files attached to this post.

K C Li

Re: SqlBase API Functions

Post by K C Li » 03 Nov 2009, 11:48

 Posted by:  KC Li 


Is it possible to do 'Reorganize', as in Sqltalk

Thanks in advance


Cheung Li

Re: SqlBase API Functions

Post by Cheung Li » 16 Nov 2009, 15:51

 Posted by:  Cheung Li 


Have look in the Unify tech. support :



Return to “td.sourcecode”

Who is online

Users browsing this forum: [Ccbot] and 1 guest