SQL/MX Data Mining Guide

Inserting Into the Data Mining Database
HP NonStop SQL/MX Data Mining Guide—523737-001
B-3
(2500000,DATE '2003-08-01','Open', 5000, 0, 0, 0),
(2500000,DATE '2003-09-01','Open', 5000, 0, 0, 0),
(2500000,DATE '2003-10-01','Open', 5000, 0, 0, 0),
(2500000,DATE '2003-11-01','Open', 5000, 0, 0, 0),
(2500000,DATE '2003-12-01','Open', 5000, 0, 0, 0);
INSERT INTO acct_history VALUES
(4098124,DATE '2000-10-01','Open', 6000,32000.00,3200.00,0.00),
(4098124,DATE '2000-11-01','Open', 6000, 2300.00,2300.00,0.00),
(4098124,DATE '2000-12-01','Open', 6000, 0.00, 0.00,0.00),
(4098124,DATE '2001-01-01','Open', 6000, 0.00, 0.00,0.00),
(4098124,DATE '2001-02-01','Open', 6000, 4000.00,4000.00,0.00),
(4098124,DATE '2001-03-01','Open', 6000, 1200.00,1200.00,0.00),
(4098124,DATE '2001-04-01','Open', 6000, 320.00, 320.00,0.00),
(4098124,DATE '2001-05-01','Open', 6000, 1000.00,1000.00,0.00),
(4098124,DATE '2001-06-01','Open', 6000, 2300.00,2300.00,0.00),
(4098124,DATE '2001-07-01','Open', 6000, 1200.00,1200.00,0.00),
(4098124,DATE '2001-08-01','Open', 6000, 5400.00,400.00,500.00),
(4098124,DATE '2001-09-01','Open', 6000, 5300.00,300.00,550.00),
(4098124,DATE '2001-10-01','Open', 6000, 6000.00,800.00,720.00),
(4098124,DATE '2001-11-01','Open', 6000, 5920.00,800.00,710.40),
(4098124,DATE '2001-12-01','Open', 6000, 5830.40,800.00,699.65),
(4098124,DATE '2002-01-01','Open', 6000, 5730.04, 800, 687.60),
(4098124,DATE '2002-02-01','Open', 6000, 5617.65, 800, 674.11),
(4098124,DATE '2002-03-01','Open', 6000, 5491.77, 800, 659.01),
(4098124,DATE '2002-04-01','Open', 6000, 5350.78, 800, 642.09),
(4098124,DATE '2002-05-01','Open', 6000, 5192.87, 800, 623.14),
(4098124,DATE '2002-06-01','Open', 6000, 5016.02, 800, 601.92),
(4098124,DATE '2002-07-01','Open', 6000, 4817.94, 800, 578.15),
(4098124,DATE '2002-08-01','Open', 6000, 4596.10, 800, 551.53),
(4098124,DATE '2002-09-01','Open', 6000, 4347.63, 800, 521.71),
(4098124,DATE '2002-10-01','Closed',6000,4069.34, 800, 488.32);
INSERT INTO acct_history VALUES
(2400000,DATE '2002-01-01','Open', 5000, 50.00, 50.00, 0.00),
(2400000,DATE '2002-02-01','Open', 5000, 100.00, 50.00, 0.75),
(2400000,DATE '2002-03-01','Open', 5000, 50.00, 50.00, 0.00),
(2400000,DATE '2002-04-01','Open', 5000, 380.00, 50.00, 4.95),
(2400000,DATE '2002-05-01','Open', 5000, 330.00, 60.00, 4.05),
(2400000,DATE '2002-06-01','Open', 5000, 430.45, 55.00, 5.63),
(2400000,DATE '2002-07-01','Open', 5000, 470.34, 55.00, 6.23),
(2400000,DATE '2002-08-01','Open', 5000, 545.00, 60.00, 7.27),
(2400000,DATE '2002-09-01','Open', 5000, 490.67,490.67, 0),
(2400000,DATE '2002-10-01','Open', 5000, 0.00, 0.00, 0.00),
(2400000,DATE '2002-11-01','Open', 5000, 0.00, 0.00, 0.00),
(2400000,DATE '2002-12-01','Closed',5000, 0.00, 0.00, 0.00);