Open Source Java Frameworks on NonStop User's Guide (Spring 2.5.0, Hibernate 3.2.6, MyFaces 1.2.5, Axis2/Java 1.4.1)

A EmpInfo Database Script
The empinfo_tables_script.sql script file is used to create the SQL/MX database for the
EmpInfo application. The content of this file is as follows:
Log EmpInfo.log;
drop schema empinfocat.empinfosch cascade;
drop catalog empinfocat;
create catalog empinfocat LOCATION <node.$vol>;
create schema empinfocat.empinfosch AUTHORIZATION “<user>” LOCATION ZSD<subvol reference>;
set schema empinfocat.empinfosch;
create table employee(
emp_id int not null,
first_name varchar(30),
last_name varchar(30),
age int,
email varchar(50),
PRIMARY KEY(emp_id)
);
147