The Update Processor can be used to modify existing items (rows) or insert new items into a non-D3 file (table). The TCL copy command can be used to copy data from an ODBC database to D3 or vice versa. Just as on D3, storage for the data (typically called a table) must be created before attempting the copy. For databases such as Microsoft SQL Server and Oracle, the columns also must be defined. In addition to the copy command, other useful TCL commands are clear-file, delete, and search.
Commands not supported
Since the data accessed by OpenDB does not reside on a D3 computer, TCL commands dealing with the size of the file and the hashing are not supported. Thus, commands such as iselect, item and resize are not supported. In addition, commands such as create-index, delete-index, create-file, delete-file and rename-file are not supported.