Kbase P74017: How to bulk load multiple .d files for one table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/10/2008 |
|
Status: Verified
GOAL:
How to bulk load multiple .d files for one table
GOAL:
Is it possible to bulk load multiple .d files for a single table?
FACT(s) (Environment):
UNIX
Windows
Progress 9.x
OpenEdge 10.x
FIX:
If you need to load multiple .d files from one table using the bulk load utility, you can edit the .fd file to load the data. Using the customer table from the sports2000 database as an example, perform the following operations:
1) From a sports2000 database, dump the customer.df, customer.fd and customer.d
2) Create an empty database from the sports2000.st and procopy the $DLC/empty database.
3) Using a text editor to break the customer.d file into two files (customer1.d and customer2.d) using the copy and paste utility. Remember to also copy the codepage information.
4) Edit the customer.fd file to load both .d files:
# Database: C:\wrk91d\test
# Date/Time: 2004/03/26-15:24:04
Customer c:\wrk91d\customer.d c:\wrk91d\customer.e
CustNum
Country
Name
Address
Address2
City
State
PostalCode
Contact
Phone
SalesRep
CreditLimit
Balance
Terms
Discount
Comments
Fax
EmailAddress
.
Customer c:\wrk91d\customer1.d c:\wrk91d\customer1.e
CustNum
Country
Name
Address
Address2
City
State
PostalCode
Contact
Phone
SalesRep
CreditLimit
Balance
Terms
Discount
Comments
Fax
EmailAddress
# end-of-file