Creating the Exported Database File Using expsysdb

Use expsysdb to export system data from all database files of a specific system code, or an entire data area or data ID, including any related attachment files. For syntax and other details about the utility, see the System Utilities Reference Guide.

Files are assigned to a system during database definition. For example, the Lawson Inventory Control (IC) application owns the Inventory file; therefore, the system code for the Inventory file is IC. A system can also use files that belong to other systems. For example, because the IC application uses the Glmaster file , which belongs to the Lawson General Ledger (GL) application, you might also need to include Glmaster.

The system has two methods for determining which files a system uses:

  • Program files include all files that programs in a system use. Lawson does not deliver program file records with source code. You must create the program files before using the program files export method. To create program file records, compile the system using the Compile System option on the Compile Tools submenu of the Programmer Utilities menu. For more information, see Doc for Developers: Application Development Workbench.

  • System files include all files used by the programs in an application system, as well as all files that are directly related to those files.

Creating the Exported Database File Using an Import/Export Program

You use the Application Development Workbench tool to build an import/export program that exports one or more selected files. You can also define parameters and record selection conditions for the import/export program, making the program import or export only the records that satisfy these parameters and conditions.

You do not have to compile the import/export program you define; simply run it in prototype mode and the system creates your dump file. For more information on 4GL import/export programs, see Doc for Developers: Application Development Workbench.

Creating the Exported Database File Using a COBOL Program

Use bldexpfd to generate COBOL file descriptions. You can then put the file descriptions in a COBOL program to create an export file.