Neoview Database Administrator's Guide (R2.3)

1. Use a text editor to create a DDL file with definitions for as many tables as you want to
create. It might look like this:
CREATE TABLE CUST_FILE
( custnum DECIMAL (6,0) UNSIGNED NO DEFAULT NOT NULL,
custname CHARACTER (25) NO DEFAULT,
PRIMARY KEY (custnum) NOT DROPPABLE )
STORE BY PRIMARY KEY;
CREATE TABLE CUST_FILE2
( custnum DECIMAL (6,0) UNSIGNED NO DEFAULT NOT NULL,
custname CHARACTER (25) NO DEFAULT,
PRIMARY KEY (custnum) NOT DROPPABLE )
STORE BY PRIMARY KEY;
Save the file on your workstation or on the HP system. For information on SQL syntax, see
the HP Neoview SQL Reference Manual.
2. Start DB Admin and log on using any user ID allowed to create tables. The DBA role is
intended for this task.
3. Click the Database tab, then select the schema, owned by your user ID role, in which you
want the table created.
4. Right-click the Schema name and select Create Table Tool. DB Admin displays the Create
Table Tool screen:
Tables 49