2.8 Updating a Table with a Conventional Path Load

Table of Contents Previous Next


2 EDB*Loader : 2.8 Updating a Table with a Conventional Path Load

To perform an UPDATE, use the same steps as when performing a conventional path load:
1.
Create a data file that contains the rows you wish to UPDATE or INSERT
2.
Define a control file that uses the INFILE keyword to specify the name of the data file. For information about building the EDB*Loader control file, see Section 2.3.
The following example uses the emp table that is distributed with the Advanced Server sample data. By default, the table contains:
The following control file (emp_update.ctl) specifies the fields in the table in a comma-delimited list. The control file performs an UPDATE on the emp table:
The data that is being updated or inserted is saved in the emp_update.dat file. emp_update.dat contains:
Invoke EDB*Loader, specifying the name of the database (edb), the name of a database superuser (and their associated password) and the name of the control file (emp_update.ctl):
edbldr -d edb userid=user_name/password control=emp_update.ctl
The rows containing information for the three employees that are currently in the emp table are updated, while rows are added for the new employees (BAKER and MILLS)

2 EDB*Loader : 2.8 Updating a Table with a Conventional Path Load

Table of Contents Previous Next