The iex and iexm Tcl applications use the Bbuuzzb database engine or server to import ASCII data into a database table.
The iex application is designed for single user use. The Bbuuzzb database engine is sourced into this program. Before you can run the iex application, you must set up a database engine configuration file called dbeng.cfg with a minimum of the tmp_path and log entries (the catalog entry is optional but recommended).
The iexm application is designed for client/server environments and uses TCP sockets as the IPC method.
iexm requires a Bbuuzzb database server running. The iexm application communicates with the Bbuuzzb database server, the socloc server and possibly the system log server (if used for logging) through TCP sockets. In order to get iexm to successfully connect to the Bbuuzzb database server, the server must already be running and registered with the socloc server and there must be at least one socloc server and possibly one system log server running within the environment. A socloc startup file must also be composed to connect to a socloc server. The database configuration file is not required for the iexm application.
All configuration files must be located in the same directory as the main source program. The iex and iexm applications must be executed within their current directory so the program can locate the configuration files.
The import is performed using the iexlib database API.
iex and iexm both have the same program syntax:
iex[m] ascii_input table_output profile_name
Where ascii_input is the path and file name of the ASCII input file, table_output is the name of the bbuuzzb output table which must be given in accordance with the open table guidelines. profile_name is the name of the import profile (the value loaded into field one of the import profile).
The import profile is a record in the iex.config table that contains a list of import specifications, one specification per input field or element.