HP Integrity NonStop J-Series - Manual (Page 319)

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)
);
319