Table of Contents Previous Next


11 Utilities : 11.2 EDB*Loader : 11.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 11.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)

11 Utilities : 11.2 EDB*Loader : 11.2.8 Updating a Table with a Conventional Path Load

Table of Contents Previous Next