Using dbload with Named Row Types

The procedure for how to use dbload with named row types is somewhat different than for other complex data types because named row types are actually user-defined data types. In fact, you can follow these steps for any user-defined data type.

This example uses a table person that contains one column with a named row type. The person_t named row type contains six fields: name, address, city, state, zip, and bdate.

The following syntax shows how to create the named row type and the table used in this example:

To load data for a named row type

Use the UNLOAD statement to unload the table to an input file. In this example, the input file sees the named row type as six separate fields:

Brown, James|13 First St.|San Francisco|CA|94070|01/04/1940|
Karen Smith|5820 Easy Ave #100|Fremont|CA|94502|01/13/1983|

Use the dbschema utility to capture the schema of the table and the row type. You must use the dbschema -u option to pick up the named row type.
```
dbschema -d stores_demo -u person_t > schema.sql
dbschema -d stores_demo -t person > schema.sql
```
Use DB–Access to re-create the person table in the new database.
For detailed steps, see DB-Access Input from dbschema Output.
Create the dbload command file. This dbload command file inserts two rows into the person table in the new database.
```
FILE person.unl DELIMITER '|' 6;
INSERT INTO person;
```
This dbload example shows how to insert new data rows into the person table. The number of rows in the INSERT statement and the dbload command file must match:
```
FILE person.unl DELIMITER '|' 6; 
   INSERT INTO person 
   VALUES ('Jones, Richard', '95 East Ave.', 
           'Philadelphia', 'PA', 
   '19115', 
   '03/15/97');
```

Execute the dbload command:

dbload -d newdb -c uds_command -l errlog