Database Tools

DirectTalk includes its own proprietary database system which is used to hold voice and application data. It can also be used for user databases and greatly increases the flexibility and power of the system. Many users keep all user data (accounts, order status, etc.) in a DirectTalk database which is updated periodically. The resultant voice application is usually easier to write that if you have to code the application to interact with another system (3270, AS/400, etc.) to retrieve the information.

While DirectTalk does include interactive tools for viewing the contents of a database and for loading a database with data, I have always found them limited and insufficient for day-to-day work in a production or development environment. Many of the tools I've written deal with DirectTalk databases.

DTIMPORT

DTIMPORT is a stand-alone program that can be used to load a DirectTalk database from any standard ASCII text file. With the appropriate command file or REXX program, DTIMPORT can be used to load updates and additions to a database whenever desired. You can specify if the load should replace or update the contents of an existing database. DTIMPORT can even create the database, if necessary. 

See more information on DTIMPORT.

Download the version for OS/2. (47,064 bytes) 

Download the version for Windows NT (41,892 bytes) 

EXPORT

EXPORT is the companion to DTIMPORT and performs the opposite function - it is used to export the contents of a DirectTalk database to a standard ASCII text file. The contents of the database can be deleted after the export, if desired. Many customers write their applications so any information collected from the caller is placed in a DirectTalk database. The information is then exported nightly using EXPORT to a text file where it is processed further as needed.

See more information on EXPORT. 

Download the version for OS/2. (31,985 bytes)

Download the version for Windows NT. (35,316 bytes)

REXX Interface to DirectTalk Databases

Rexx is an extremely powerful command language that can used to write programs on many different operating systems. It is included with OS/2 and is installed as part of a DirectTalk for Windows installation. (Rexx is now the primary language for writing DirectTalk applications.) Since it's already on your system, why not take advantage of it? The Rexx to DT Interface is a special DLL that allows you to write Rexx programs that can access data inside any DirectTalk database. You can also create new DirectTalk databases from Rexx using this tool.

If you need some more information on Object Rexx, try here.

See more information on the Rexx Interface to DirectTalk Databases.

Download the version for OS/2 (22,928 bytes)

Download the version for Windows NT. (28,832 bytes)

COMPRESS

The nature of DirectTalk databases are such that as records are added and deleted, the database can continue to grow in size. User databases of volatile voice data are notorious for growing in size until all available space on the hard drive is consumed. When a record is deleted from a database, only the internal indexes are changed - no actual data is removed. Therefore, a database will remain the same size after deleting one or more records. To reclaim this "lost" space, the database must be compressed. While DirectTalk does have the facility to compress a database included in the product, it is an interactive part of the Develop facility. No standalone program for compressing a database is provided. COMPRESS corrects this deficiency and allows you to compress every database on a DirectTalk system with a single command. Since it is a standalone program, it is easily used from a command program to compress databases on a periodic basis.

See more information on Compress.

Download the version for OS/2. (40,955 bytes)

Download the version for Windows NT. (Coming soon!)

 

Database Editor

Perhaps the "crown jewel" of the tools here, the Database Editor is a full-featured editor for DirectTalk databases. In addition to the normal functions you'd expect (view, add, change, delete), the editor provides the following capabilities:

view and edit data in either ASCII or hex format
create new databases
delete databases no longer needed
delete all or selected records from databases
view statistics on a database
connect to remote DirectTalk systems
import data from text files
export data to text files
compress databases
copy records from one database to another (On Windows, the data can even be copied across different DirectTalk systems.)
view a list of all databases on the system at one time (On Windows, databases needing to be compressed can be highlighted.)
print records or entire databases

The OS/2 version was written using Hockware's VisProRexx. The Windows version was written using Visual Basic. 

 

Download the version for OS/2. (Version 2.78, 563,799 bytes)

To install:

  1. Unzip the contents of DT2EDIT.ZIP to the same directory as where DirectTalk/2 is installed. 
  2. Run DT2EDIT.EXE to start the editor.
  3. Help for the editor is available by viewing DT2EDIT.INF. Use the OS/2 View command.
  4. If desired, you can create a shadow on the desktop to allow easier execution of the Editor.

 

Download the version for Windows NT. (Version 1.08, 2,937,344 bytes) Click here to see the latest changes.

To install:

  1. Run DTNTEDIT.EXE to extract the files to a temporary directory.
  2. From the temporary directory, run SETUP.EXE. You may have to reboot your system and run SETUP again depending on the versions of some system DLL's on your system.
  3. When SETUP asks for the installation location, specify the same directory as where DirectTalk for Windows is installed.
  4. To run the Editor, click on Database Editor for DirectTalk for Windows in the folder of the same name.

Note: There is no help for the Windows version of the Editor at this time. I am planning on adding it when I find the time.

 

Return to top of page.

Return to the main page.