Exchange compared to Database Management

The Database Management module of LN Tools also enables you to create ASCII files from LN data and to load data from an ASCII file into LN. You can use these tools for basic data exchanges that do not require any special handling. These tools are contained in the Create Sequential Dump of Table (ttaad4226m000) and Create Table from Sequential Dump (ttaad4227m000) sessions. You can also activate these tools from the UNIX prompt (bdbpre6.2 and bdbpost6.2).

If you use both tools one after the other, then you can transfer data from one LN company to another.

The main difference between the Database Management and Exchange modules is that the Exchange module provides more flexibility. You can specify which data must be read or written and in which format. In the Database Management module, you must import or export entire tables. The advantages of using the Exchange module in stead of the database tools include the ability to:

• Specify the exact data to be exchanged by table and field.
• Convert and calculate data during an exchange.
• Export based on an audit only the data that has changed since the last exchange.
• Specify the order in which fields are imported.
• Read data from other tables.