bldexpfd - Build Export File Description

bldexpfd productline exportfdfile [filename...]

Generate a file description for formatting an export file. It is useful for building user programs to dump user database files and to import them into Lawson database files. The file includes the database file field names and their sizes in a record layout format. Generate the file descriptions for the files you want to export and put them in a COBOL program that writes the export records.

At the command line, specify the information above.

or

  1. From the Database Administration menu, choose Data Export/Import.

  2. From the Data Export/Import menu, choose Build Export File.

  3. Specify or select the following data.

    Field Description
    Product Line Product line you want to build file descriptions for.
    Export FD File Export file description (FD) file (the output file).
    File Name(s)

    File names you are building descriptions for.

    Leave blank to build export file descriptions for the entire product line.
    I/O Options

    Optional. Display the output or redirect it to a file.

    Note: Send the standard output of bldexpfd to a file to capture the size of records built.

    For more information on copying or transferring data, see Lawson Administration: Server Setup and Maintenance.

Example Command and Output

The following command creates a file called gltrans.fd that contains the file description for the gltrans file in the app900 product line.

bldexpfd app900 gltrans.fd gltrans

The following example illustrates a portion of the output from this command:

**************************************************************
*                       GLTRANS-FILE                         *
**************************************************************
 01 EF-GLTRANS-REC.
    02  EF-FILE-NAME            PIC X(10) VALUE "GLTRANS".
     02  EF-GLT-COMPANY          PIC 9(4).
     02  EF-GLT-FISCAL-YEAR      PIC 9(4).
     02  EF-GLT-ACCT-PERIOD      PIC 9(2).
     02  EF-GLT-CONTROL-GROUP    PIC 9(8).
     02  EF-GLT-SYSTEM           PIC X(2).
     02  EF-GLT-JE-TYPE          PIC X(1).
     02  EF-GLT-JE-SEQUENCE      PIC 9(2).
     02  EF-GLT-LINE-NBR         PIC 9(6).
     02  EF-GLT-OBJ-ID           PIC 9(12).
     02  EF-GLT-STATUS           PIC 9(1).