Try OpenEdge Now
skip to main content
Basic Database Tools
Table Tasks : Creating a bulk loader description file
 

Creating a bulk loader description file

You use the bulk loader description file with the Bulk Loader utility to load data (.d) files into an OpenEdge database quicker than you can using the Data Dictionary Load utility.
You must create a bulk loader description file before you can run the Bulk Loader utility. For more information about bulk loader description files, see the chapter on dumping and loading in OpenEdge Data Management: Database Administration.
To create a bulk loader description file:
1. Choose Admin > Create Bulk Loader Description File. The Data Dictionary alphabetically lists all the tables defined for your database.
2. Select the tables for which you want to create bulk loader description files and press GO. The Data Dictionary prompts you for the bulk load filename.
3. Specify a bulk load filename. The default filename is table-name.fd.
4. If your load contains large objects, accept the Include LOB default of yes; otherwise, choose no.
5. If you choose yes in Step 4, type in the LOB directory field the name of the directory that contains the LOB.
6. Specify the code page.
7. Choose OK. After dumping the table contents to the specified file, the Data Dictionary displays a status message and prompts you to continue.