1. The createrowtype.sql creates different row types

create row type employee ( name char (20), age int);
create row type manager (emp employee, salary int);
create row type fullname (first varchar(50), last varchar(50));
create row type residence ( door numeric(6), street varchar(100), city varchar(50), occupant employee);
create row type person (name fullname, height numeric, weight decimal,
home residence);
create row type student  (gpa float) under person;

2. Once these row types are created run the ClassGenerator as
java ClassGenerator rowtypename [-u URL] [-c classname]

2.1 If the URL is not specified as cmd line arg it will be picked from setup.std2.2 If the classname is not specified the classname will be defaulted to the datatype name.

e.g. java ClassGenerator employee 
     will generate employee.java

     java ClassGenerator employee -c Emp1 
     will generate Emp1.java
 
     java ClassGenerator employee -c Emp1 -u "jdbc:davinci:1528/test:user=gbasedbt;password=1RDSRDS;gbasedbtserver=picasso_ius" 
     will use the URL specified and will generate Emp1.java.

3. ClassGenerator will generate the classes for only the datatypes that exist in system catalogs.

5. How to test
5.1 Run createrowtype.sql to create row types using dbaccess.
    The user should have resource privilege to create the datatypes.
5.2 Create the setup.std file. (don't forget the database field)
    URL <jdbc:hostname:portno> 
    database <database>
    user <username>
    passwd <passowrd>
    gbasedbtserver <gbasedbtservername>
5.3 run the following
    java ClassGenerator employee 
    java ClassGenerator manager 
    java ClassGenerator fullname
    java ClassGenerator residence 
    java ClassGenerator person
    java ClassGenerator student 

5.4 Compare the generated files with the  .req files.
5.5 The generated files should complie without any error.

