Progress
Database Administration
Guide and Reference
Modifying a Bulk Loader Description File
You can use a text editor to change a Bulk Loader description (FD) file. Table 13–4 lists the tasks and actions.
Using a text editor, change the description file to appear as follows:
In this example, the Bulk Loader utility loads the Cust-num, Name, City, St, and Phone fields, since they are the only fields specified in the description file. The carat ( ^ ) directs the Bulk Loader to skip a field. The Bulk Loader does not load any of the fields after Phone because they do not appear in the description file. The customer table name appears by itself on the top line.
By default, the Bulk Loader adds .d and .e extensions to the table name to produce the two file names it requires to operate. It assumes that both of the files (the data file and the error file) begin with the table name. If this assumption is false, you must specify the different filenames. For example, if you dump the customer table into
cust.d
instead ofcustomer.d
, you must specify the namecust.d
in the bulk loader description file. Otherwise, the Bulk Loader searches the current directory forcustomer.d
:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |