SQL/MX Data Mining Guide

Importing Into the Data Mining Database
HP NonStop SQL/MX Data Mining Guide—523737-001
C-3
Account History Format File
Account History Format File
This file is named importfmta.txt and is the format file specified in the preceding
import command:
[DATE FORMAT]
DateOrder=YMD
DateDelimiter=-
[COLUMN FORMAT]
col=account,N
col=year_month,N
col=status,N
col=cust_limit,N
col=balance,N
col=payment,N
col=finance_charge,N
[DELIMITED FORMAT]
FieldDelimiter=,
Account History Data File
This file is named importdataa.txt and is the data file specified in the preceding
import command:
1234567,2003-01-01,Open,10000,1232.50,1232.50,0.00
1234567,2003-02-01,Open,10000,3000.00,3000.00,0.00
1234567,2003-03-01,Open,10000,1034.00,1034.00,0.00
1234567,2003-04-01,Open,10000,2500.00,2500.00,0.00
1234567,2003-05-01,Open,10000,1050.00,1050.00,0.00
1234567,2003-06-01,Open,10000,6500.00,6500.00,0.00
1234567,2003-07-01,Open,10000,3000.00,3000.00,0.00
1234567,2003-08-01,Open,10000,7800.00,7800.00,0.00
1234567,2003-09-01,Open,10000,3000.00,3000.00,0.00
1234567,2003-10-01,Open,10000,2870.00,2870.00,0.00
1234567,2003-11-01,Open,10000,1200.00,1200.00,0.00
1234567,2003-12-01,Closed,10000,500.00,500.00,0.00
2500000,2002-07-01,Open, 5000,566.00,32.00,8.00
2500000,2002-08-01,Open,5000,600.00,40.00,9.23
2500000,2002-09-01,Open,5000,632.00,32.00,8.00
2500000,2002-10-01,Open,5000,615.00,31.00,8.00
2500000,2002-11-01,Open,5000,670.00,42.00,10.40
2500000,2002-12-01,Open,5000,650.00,37.00,10.00
2500000,2003-01-01,Open,5000,703.00,50.00,13.00
2500000,2003-02-01,Open,5000,723.00,23.00,14.00
2500000,2003-03-01,Open,5000,700.00,20.00,13.75
2500000,2003-04-01,Open,5000,745.00,22.00,13.60
2500000,2003-05-01,Open,5000,745.00,0,89.40
2500000,2003-06-01,Open,5000,834.40,75,100.28