SQL/MX Data Mining Guide

Inserting Into the Data Mining Database
HP NonStop SQL/MX Data Mining Guide—523737-001
B-2
(7900000,'LAUREN','LITTLE', 'Widow', 'Own', 28000,'F',65,0),
(8000000,'BRENT', 'BLACK', 'Married', 'Own', 175500,'M',45,3),
(8100000,'STEVEN','HUFF', 'Widow', 'Own', 137000,'M',42,2),
(8200000,'ELLIE', 'RAYMOND','Married', 'Rent',136000,'F',50,0),
(8300000,'PATRICK','ZORO', 'Divorced','Rent',138000,'M',40,1),
(8400000,'SHAWN', 'JONES', 'Divorced','Own', 75000,'M',40,2),
(8500000,'ABBIE', 'LAUREN', 'Single', 'Own', 200000,'F',19,0),
(8600000,'ELSIE', 'VANDER', 'Single', 'Own', 200000,'F',30,0),
(8700000,'SARAH', 'PETERS', 'Single', 'Own', 200000,'F',19,0),
(8800000,'ALLIE', 'BOWERS', 'Single', 'Own', 200000,'F',40,0),
(8900000,'KELSEY','SMITH', 'Single', 'Own', 200000,'F',28,0),
(9000000,'KIM', 'TENNEL', 'Single', 'Own', 200000,'F',56,0),
(9100000,'TJ', 'CASWELL','Single', 'Own', 200000,'M',25,0),
(9200000,'HELEN', 'SPOTS', 'Single', 'Own', 200000,'F',29,0),
(9300000,'JOHN', 'MOORE', 'Single', 'Own', 200000,'M',43,0);
-- Insert into ACCT_HISTORY 12 to 36 records per account
INSERT INTO acct_history VALUES
(1234567,DATE '2003-01-01','Open',10000,1232.50,1232.50, 0.00),
(1234567,DATE '2003-02-01','Open',10000,3000.00,3000.00, 0.00),
(1234567,DATE '2003-03-01','Open',10000,1034.00,1034.00, 0.00),
(1234567,DATE '2003-04-01','Open',10000,2500.00,2500.00, 0.00),
(1234567,DATE '2003-05-01','Open',10000,1050.00,1050.00, 0.00),
(1234567,DATE '2003-06-01','Open',10000,6500.00,6500.00, 0.00),
(1234567,DATE '2003-07-01','Open',10000,3000.00,3000.00, 0.00),
(1234567,DATE '2003-08-01','Open',10000,7800.00,7800.00, 0.00),
(1234567,DATE '2003-09-01','Open',10000,3000.00,3000.00, 0.00),
(1234567,DATE '2003-10-01','Open',10000,2870.00,2870.00, 0.00),
(1234567,DATE '2003-11-01','Open',10000,1200.00,1200.00, 0.00),
(1234567,DATE '2003-12-01','Closed',10000,500.00,500.00, 0.00);
INSERT INTO acct_history VALUES
(2500000,DATE '2002-07-01','Open', 5000, 566.00, 32.00, 8.00),
(2500000,DATE '2002-08-01','Open', 5000, 600.00, 40.00, 9.23),
(2500000,DATE '2002-09-01','Open', 5000, 632.00, 32.00, 8.00),
(2500000,DATE '2002-10-01','Open', 5000, 615.00, 31.00, 8.00),
(2500000,DATE '2002-11-01','Open', 5000, 670.00, 42.00,10.40),
(2500000,DATE '2002-12-01','Open', 5000, 650.00, 37.00,10.00),
(2500000,DATE '2003-01-01','Open', 5000, 703.00, 50.00,13.00),
(2500000,DATE '2003-02-01','Open', 5000, 723.00, 23.00,14.00),
(2500000,DATE '2003-03-01','Open', 5000, 700.00, 20.00,13.75),
(2500000,DATE '2003-04-01','Open', 5000, 745.00, 22.00,13.60),
(2500000,DATE '2003-05-01','Open', 5000, 745.00, 0,89.40),
(2500000,DATE '2003-06-01','Open', 5000, 834.40, 75 ,100.28),
(2500000,DATE '2003-07-01','Open', 5000, 834.40, 834.40, 0),