SQL/MX Data Mining Guide

Importing Into the Data Mining Database
HP NonStop SQL/MX Data Mining Guide—523737-001
C-4
Account History Data File
2500000,2003-07-01,Open,5000,834.40,834.40,0
2500000,2003-08-01,Open,5000,0,0,0
2500000,2003-09-01,Open,5000,0,0,0
2500000,2003-10-01,Open,5000,0,0,0
2500000,2003-11-01,Open,5000,0,0,0
2500000,2003-12-01,Open,5000,0,0,0
4098124,2000-10-01,Open,6000,32000.00,3200.00,0.00
4098124,2000-11-01,Open,6000,2300.00,2300.00,0.00
4098124,2000-12-01,Open,6000,0.00,0.00,0.00
4098124,2001-01-01,Open,6000,0.00,0.00,0.00
4098124,2001-02-01,Open,6000,4000.00,4000.00,0.00
4098124,2001-03-01,Open,6000,1200.00,1200.00,0.00
4098124,2001-04-01,Open,6000,320.00,320.00,0.00
4098124,2001-05-01,Open,6000,1000.00,1000.00,0.00
4098124,2001-06-01,Open,6000,2300.00,2300.00,0.00
4098124,2001-07-01,Open,6000,1200.00,1200.00,0.00
4098124,2001-08-01,Open,6000,5400.00,400.00,500.00
4098124,2001-09-01,Open,6000,5300.00,300.00,550.00
4098124,2001-10-01,Open,6000,6000.00,800.00,720.00
4098124,2001-11-01,Open,6000,5920.00,800.00,710.40
4098124,2001-12-01,Open,6000,5830.40,800.00,699.65
4098124,2002-01-01,Open,6000,5730.04,800,687.60
4098124,2002-02-01,Open,6000,5617.65,800,674.11
4098124,2002-03-01,Open,6000,5491.77,800,659.01
4098124,2002-04-01,Open,6000,5350.78,800,642.09
4098124,2002-05-01,Open,6000,5192.87,800,623.14
4098124,2002-06-01,Open,6000,5016.02,800,601.92
4098124,2002-07-01,Open,6000,4817.94,800,578.15
4098124,2002-08-01,Open,6000,4596.10,800,551.53
4098124,2002-09-01,Open,6000,4347.63,800,521.71
4098124,2002-10-01,Closed,6000,4069.34,800,488.32
2400000,2002-01-01,Open,5000,50.00,50.00,0.00
2400000,2002-02-01,Open,5000,100.00,50.00,0.75
2400000,2002-03-01,Open,5000,50.00,50.00,0.00
2400000,2002-04-01,Open,5000,380.00,50.00,4.95
2400000,2002-05-01,Open,5000,330.00,60.00,4.05
2400000,2002-06-01,Open,5000,430.45,55.00,5.63
2400000,2002-07-01,Open,5000,470.34,55.00,6.23
2400000,2002-08-01,Open,5000,545.00,60.00,7.27
2400000,2002-09-01,Open,5000,490.67,490.67,0
2400000,2002-10-01,Open,5000,0.00,0.00,0.00
2400000,2002-11-01,Open,5000,0.00,0.00,0.00
2400000,2002-12-01,Closed,5000,0.00,0.00,0.00
1000000,2002-07-01,Open,20000,3678.67,3678.67,0.00
1000000,2002-08-01,Open,20000,6780.00,6780.00,0.00
1000000,2002-09-01,Open,20000,2300.78,2300.78,0.00
1000000,2002-10-01,Open,20000,8000.00,8000.00,0.00