SQL/MX Data Mining Guide

HP NonStop SQL/MX Data Mining Guide—523737-001
B-1
B
Inserting Into the Data Mining
Database
The following INSERT statements enable you to populate the data mining database.
Use the following script to populate the CUSTOMERS table and the ACCT_HISTORY
table:
-------------------------------------------------------------
-- Data mining database in catalog dmcat and schema whse
-- Run this script in MXCI
-------------------------------------------------------------
-- POPULATE THE DATA MINING DATABASE TABLES
SET SCHEMA dmcat.whse;
INSERT INTO customers VALUES
(1234567,'MARY', 'JONES', 'Single', 'Own', 65000,'F',34,0),
(2500000,'ALI', 'ABBAS', 'Divorced','Rent', 32000,'M',23,0),
(4098124,'TOMOKO','KANO', 'Divorced','Own', 44000,'M',44,2),
(2400000,'ERIKA', 'LUND', 'Widow', 'Own', 28000,'F',65,0),
(1000000,'ROGER', 'GREEN', 'Married', 'Own', 175500,'M',45,3),
(2300000,'JERRY', 'HOWARD', 'Divorced','Own', 137000,'M',42,2),
(2900000,'JANE', 'RAYMOND','Divorced','Rent',136000,'F',50,0),
(3200000,'THOMAS','RUDLOFF','Divorced','Rent',138000,'M',40,1),
(3900000,'KLAUS', 'SAFFERT','Divorced','Own', 75000,'M',40,2),
(4300000,'DEBBIE','DUNN', 'Married', 'Own', 300000,'F',29,2),
(4400000,'HANNAH','ROSE', 'Single', 'Own', 300000,'F',29,0),
(4500000,'LIZ', 'STONE', 'Married', 'Own', 300000,'F',29,1),
(4600000,'HANS', 'NOBLE', 'Single', 'Own', 300000,'M',48,0),
(4700000,'SEAN', 'FREDRICK','Widow', 'Own', 300000,'M',68,0),
(5000000,'CYNTHIA','TREBLE','Single', 'Own', 65000,'F',34,0),
(5200000,'FRANK', 'KIRBY', 'Married', 'Rent', 32000,'M',23,0),
(5300000,'ROBERT','HOLDER', 'Divorced','Own', 44000,'M',44,2),
(6000000,'VALERIE','RECORD','Widow', 'Own', 28000,'F',65,0),
(7000000,'KARL', 'SMITH', 'Married', 'Own', 175500,'M',45,3),
(7100000,'BRADLEY','RAY', 'Widow', 'Own', 137000,'M',42,2),
(7200000,'KIRSTEN','HOWARD','Married', 'Rent',136000,'F',50,0),
(7300000,'GERALD','CACHMAN','Divorced','Rent',138000,'M',40,1),
(7400000,'MILES', 'KOCH', 'Divorced','Own', 75000,'M',40,2),
(7500000,'SYDNEY','NICOLE', 'Single', 'Own', 200000,'F',25,0),
(7600000,'ERIN', 'MCDONALD','Single', 'Own', 65000,'F',34,0),
(7700000,'MATT', 'STEVENS','Married', 'Rent', 32000,'M',23,0),
(7800000,'SANDY', 'MILLER', 'Divorced','Own', 44000,'M',44,2),