SQL/MX Data Mining Guide

HP NonStop SQL/MX Data Mining Guide—523737-001
A-1
A Creating the Data Mining
Database
The examples presented in this manual use tables created by the execution of
SQL/MX CREATE TABLE statements. These SQL/MX DDL statements enable you to
create the data mining database so that you can use the SQL/MX features shown in
this manual.
-------------------------------------------------------------
-- Data mining database in catalog dmcat and schema whse
-- Run this script in MXCI
-------------------------------------------------------------
CREATE CATALOG dmcat;
CREATE SCHEMA dmcat.whse;
SET SCHEMA dmcat.whse;
-- Create tables CUSTOMERS and ACCT_HISTORY in WHSE schema
-- Create CUSTOMERS table in WHSE schema
DROP TABLE customers;
CREATE TABLE customers
( account NUMERIC (7) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
Heading 'Account Number'
,first_name CHARACTER (15)
DEFAULT ' '
NOT NULL NOT DROPPABLE
HEADING 'First Name'
,last_name CHARACTER (20)
DEFAULT ' '
NOT NULL NOT DROPPABLE
HEADING 'Last Name'
,marital_status CHARACTER (8)
DEFAULT NULL
HEADING 'Marital Status'
,home CHARACTER (4)
DEFAULT NULL
HEADING 'Home'
,income NUMERIC (8, 2) UNSIGNED
DEFAULT NULL
HEADING 'Income'
,gender CHAR(1)
DEFAULT NULL