beautypg.com

A empinfo database script, Appendix a: empinfo database script – HP Integrity NonStop J-Series User Manual

Page 319

background image

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 ;
create schema empinfocat.empinfosch AUTHORIZATION "" LOCATION ZSD;

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

This manual is related to the following products:
See also other documents in the category HP Computer hardware: