SQL/MX Data Mining Guide

Inserting Into the Data Mining Database
HP NonStop SQL/MX Data Mining Guide—523737-001
B-6
(4400000,DATE '2003-02-01','Open',40000, 100.00, 100.00, 0),
(4400000,DATE '2003-03-01','Open',40000, 50.00, 50.00, 0),
(4400000,DATE '2003-04-01','Open',40000, 90.00, 90.00, 0),
(4400000,DATE '2003-05-01','Open',40000, 0.00, 0.00, 0),
(4400000,DATE '2003-06-01','Open',40000, 0.00, 0.00, 0),
(4400000,DATE '2003-07-01','Open',40000, 0.00, 0.00, 0),
(4400000,DATE '2003-08-01','Open',40000, 0.00, 0.00, 0),
(4400000,DATE '2003-09-01','Open',40000, 0.00, 0.00, 0),
(4400000,DATE '2003-10-01','Open',40000, 0.00, 0.00, 0),
(4400000,DATE '2003-11-01','Open',40000, 0.00, 0.00, 0),
(4400000,DATE '2003-12-01','Open',40000, 0.00, 0.00, 0);
INSERT INTO acct_history VALUES
(4500000,DATE '2002-07-01','Open',40000, 50.00, 50.00, 0),
(4500000,DATE '2002-08-01','Open',40000, 100.00, 100.00, 0),
(4500000,DATE '2002-09-01','Closed',40000, 0.00, 0.00, 0);
INSERT INTO acct_history VALUES
(4600000,DATE '2003-01-01','Open',40000, 30.00, 30.00, 0),
(4600000,DATE '2003-02-01','Open',40000, 30.00, 30.00, 0),
(4600000,DATE '2003-03-01','Open',40000, 30.00, 30.00, 0),
(4600000,DATE '2003-04-01','Open',40000, 30.00, 30.00, 0),
(4600000,DATE '2003-05-01','Open',40000, 30.00, 30.00, 0),
(4600000,DATE '2003-06-01','Open',40000, 30.00, 30.00, 0),
(4600000,DATE '2003-07-01','Open',40000, 30.00, 30.00, 0),
(4600000,DATE '2003-08-01','Open',40000, 60.00, 60.00, 0),
(4600000,DATE '2003-09-01','Open',40000, 700.00, 700.00, 0),
(4600000,DATE '2003-10-01','Open',40000, 80.00, 80.00, 0),
(4600000,DATE '2003-11-01','Open',40000, 50.00, 50.00, 0),
(4600000,DATE '2003-12-01','Closed',40000,1000.00,1000.00, 0);
INSERT INTO acct_history VALUES
(4700000,DATE '2003-01-01','Open',40000, 330.00, 330.00, 0),
(4700000,DATE '2003-02-01','Open',40000, 330.00, 330.00, 0),
(4700000,DATE '2003-03-01','Open',40000, 330.00, 330.00, 0),
(4700000,DATE '2003-04-01','Open',40000, 330.00, 330.00, 0),
(4700000,DATE '2003-05-01','Open',40000, 330.00, 330.00, 0),
(4700000,DATE '2003-06-01','Open',40000, 330.00, 330.00, 0),
(4700000,DATE '2003-07-01','Open',40000, 330.00, 330.00, 0),
(4700000,DATE '2003-08-01','Open',40000, 650.00, 650.00, 0),
(4700000,DATE '2003-09-01','Open',40000, 710.00, 710.00, 0),
(4700000,DATE '2003-10-01','Open',40000, 807.00, 807.00, 0),
(4700000,DATE '2003-11-01','Open',40000, 509.00, 509.00, 0),
(4700000,DATE '2003-12-01','Open',40000, 1000.00, 1000.00, 0);