SQL/MX Data Mining Guide

Inserting Into the Data Mining Database
HP NonStop SQL/MX Data Mining Guide—523737-001
B-5
(2900000,DATE '2003-11-01','Open',15000, 2000.00, 2000.00, 0),
(2900000,DATE '2003-12-01','Open',15000, 5890.00, 5890.00, 0);
INSERT INTO acct_history VALUES
(3200000,DATE '2002-07-01','Open', 10000, 2345.00, 2345.00, 0),
(3200000,DATE '2002-08-01','Open', 10000, 0, 0, 0),
(3200000,DATE '2002-09-01','Open', 10000, 150.00, 150.00, 0),
(3200000,DATE '2002-10-01','Open', 10000, 5678.00, 5678.00, 0),
(3200000,DATE '2002-11-01','Open', 10000, 2000.00, 2000.00, 0),
(3200000,DATE '2002-12-01','Open', 10000, 50.00, 50.00, 0),
(3200000,DATE '2003-01-01','Open', 10000, 0, 0, 0),
(3200000,DATE '2003-02-01','Open', 10000, 800.00, 800.00, 0),
(3200000,DATE '2003-03-01','Open', 10000, 0, 0, 0),
(3200000,DATE '2003-04-01','Open', 10000, 0, 0, 0),
(3200000,DATE '2003-05-01','Open', 10000, 0, 0, 0),
(3200000,DATE '2003-06-01','Open', 10000, 0, 0, 0 );
INSERT INTO acct_history VALUES
(3900000,DATE '2001-12-01','Open', 5000, 800.00, 800.00, 0),
(3900000,DATE '2002-01-01','Open', 5000, 300.00, 300.00, 0),
(3900000,DATE '2002-02-01','Open', 5000, 230.00, 230.00, 0),
(3900000,DATE '2002-03-01','Open', 5000, 789.00, 789.00, 0),
(3900000,DATE '2002-04-01','Open', 5000, 600.00, 600.00, 0),
(3900000,DATE '2002-05-01','Open', 5000, 500.00, 500.00, 0),
(3900000,DATE '2002-06-01','Open', 5000,1800.00,1800.00, 0),
(3900000,DATE '2002-07-01','Open', 5000,4800.00,4800.00, 0),
(3900000,DATE '2002-08-01','Open', 5000, 0, 0, 0),
(3900000,DATE '2002-09-01','Open', 5000, 0, 0, 0),
(3900000,DATE '2002-10-01','Open', 5000, 0, 0, 0),
(3900000,DATE '2002-11-01','Open', 5000, 0, 0, 0);
INSERT INTO acct_history VALUES
(4300000,DATE '2003-01-01','Open',40000, 0, 0, 0),
(4300000,DATE '2003-02-01','Open',40000,18000.00,18000.00, 0),
(4300000,DATE '2003-03-01','Open',40000, 459.99, 459.99, 0),
(4300000,DATE '2003-04-01','Open',40000, 9876.00, 9876.00, 0),
(4300000,DATE '2003-05-01','Open',40000, 4354.00, 4354.00, 0),
(4300000,DATE '2003-06-01','Open',40000, 9000.00, 9000.00, 0),
(4300000,DATE '2003-07-01','Open',40000, 0, 0, 0),
(4300000,DATE '2003-08-01','Open',40000, 6700.00, 6700.00, 0),
(4300000,DATE '2003-09-01','Open',40000, 7800.00, 7800.00, 0),
(4300000,DATE '2003-10-01','Open',40000, 1200.00, 1200.00, 0),
(4300000,DATE '2003-11-01','Open',40000, 8000.00, 8000.00, 0),
(4300000,DATE '2003-12-01','Open',40000, 9050.00, 9050.00, 0);
INSERT INTO acct_history VALUES
(4400000,DATE '2003-01-01','Open',40000, 0.00, 00.00, 0),