TurboDB Engine Documentation

TurboDB Workbench

Previous  Top  Next


tdbwkb is a small text-based free-ware tool for managing TurboDB tables. It is available for Windows and Linux and can be downloaded at http://www.turbodb.de/. tdbwkb offers commands for

Creating new tables
Modifiying existing tables
Show the table structure of existing tables
Creating indexes for a table
Deleting indexes for a table
Repair a table and its indexes
Deleting a table
Switching between different databases

Running tdbwkb will show the copyright and the tdbwkb prompt where you can enter the different commands. Enter help to show a list of available commands.

Here is a sample tdbwkb session to illustrate the available features.

home/usr1>tdbwkb
dataweb Turbo Database Workbench Version 4.0.1 (TDB 6.1.6)
Copyright (c) 2002-2003 dataweb GmbH, Aicha, Germany
Homepage http://www.dataweb.de, Mail dataweb Team
Type 'help' to get a list of available commands.
 
tdbwkb> help
Abbreviations are not allowed. The commands are:
altertable    Modifies an existing table.
bye           Ends the tdbwkb session.
cd            Changes the current directory.
debug         Toggles debug mode. (Debug mode prints log messages.)
delindex      Deletes an index from a table.
deltable      Deletes all files of a table.
help          Prints this list of commands.
newftindex    Create a new full text index for a table.
newindex      Creates a new index for a table.
newtable      Creates a new table.
pwd           Prints current working directory.
show          Shows a rough preview of the table.
switchdb      Opens another database.
rename        Renames a table.
repair        Rebuilds a table and all its indexes.
tableinfo     Shows the description of a table.
Type help <cmd> to get more specific help for a command.
Note: You may also use tdbwkb in batch mode by appending the command directly
to the call. Example:
tdbwkb tableinfo mytable
 
tdbwkb> newtable animals S40Name,A'Land,Water,Air'Area,PImage,MDescription,N'Name'RecordId
Creating table animals.dat with these columns:
1 S40  Name
2 A    Area, Values = Land,Water,Air
3 P    Image
4 M    Description
5 N    RecordId
tdbwkb> tableinfo animals
Retrieving structure of table animals.dat...
Table columns:
1 S40  Name
2 A    Area, Values = Land,Water,Air
3 P    Image
4 M    Description
5 N    RecordId
Indexes:
animals.inr                   RecordId:4
animals.id                    Name:40
 
tdbwkb> altertable animals n2=S40Family
Restructuring table animals.dat to these columns:
1 S40  Name
2 S40  Family
3 A    Area, Values = Land,Water,Air
4 P    Image
5 M    Description
6 N    RecordId
 
tdbwkb> newindex animals byfamily Family,Name
 
tdbwkb> tableinfo animals
Retrieving structure of table animals.dat...
Table columns:
1 S40  Name
2 S40  Family
3 A    Area, Values = Land,Water,Air
4 P    Image
5 M    Description
6 N    RecordId
Indexes:
animals.inr                   RecordId:4
animals.id                    Name:40
byfamily.ind                  Family:40, Name:40