Nested named row example

To use ClassGenerator for a nested row, you first create the named row on the database server:

create row type manager (emp employee, salary int);

Next, run ClassGenerator. In this case, the setup.std file is not consulted, because you provide all the needed information at the command line:

java ClassGenerator manager -c Manager -u "jdbc:davinci:1528/test:user=scott;
password=tiger;informixserver=picasso_ius"

The preceding command generates the following Java™ class:

import java.sql.*;
import java.math.*;
public class Manager implements SQLData
{
   public employee emp;
   public int salary;
   private String sql_type;

   public String getSQLTypeName() { return "manager"; }

   public void readSQL (SQLInput stream, String type) throws 
      SQLException
   {
      sql_type = type;
      emp = (employee)stream.readObject();
      salary = stream.readInt();
   }

   public void writeSQL (SQLOutput stream) throws SQLException
   {
      stream.writeObject(emp);
      stream.writeInt(salary);
   }
}