SQL/MX Data Mining Guide

Importing Into the Data Mining Database
HP NonStop SQL/MX Data Mining Guide—523737-001
C-2
Importing Account History Data
1000000,ROGER,GREEN,Married,Own,175500,M,45,3
2300000,JERRY,HOWARD,Divorced,Own,137000,M,42,2
2900000,JANE,RAYMOND,Divorced,Rent,136000,F,50,0
3200000,THOMAS,RUDLOFF,Divorced,Rent,138000,M,40,1
3900000,KLAUS,SAFFERT,Divorced,Own,75000,M,40,2
4300000,DEBBIE,DUNN,Married,Own,300000,F,29,2
4400000,HANNAH,ROSE,Single,Own,300000,F,29,0
4500000,LIZ,STONE,Married,Own,300000,F,29,1
4600000,HANS,NOBLE,Single,Own,300000,M,48,0
4700000,SEAN,FREDRICK,Widow,Own,300000,M,68,0
5000000,CYNTHIA,TREBLE,Single,Own,65000,F,34,0
5200000,FRANK,KIRBY,Married,Rent,32000,M,23,0
5300000,ROBERT,HOLDER,Divorced,Own,44000,M,44,2
6000000,VALERIE,RECORD,Widow,Own,28000,F,65,0
7000000,KARL,SMITH,Married,Own,175500,M,45,3
7100000,BRADLEY,RAY,Widow,Own,137000,M,42,2
7200000,KIRSTEN,HOWARD,Married,Rent,136000,F,50,0
7300000,GERALD,CACHMAN,Divorced,Rent,138000,M,40,1
7400000,MILES,KOCH,Divorced,Own,75000,M,40,2
7500000,SYDNEY,NICOLE,Single,Own,200000,F,25,0
7600000,ERIN,MCDONALD,Single,Own,65000,F,34,0
7700000,MATT,STEVENS,Married,Rent,32000,M,23,0
7800000,SANDY,MILLER,Divorced,Own,44000,M,44,2
7900000,LAUREN,LITTLE,Widow,Own,28000,F,65,0
8000000,BRENT,BLACK,Married,Own,175500,M,45,3
8100000,STEVEN,HUFF,Widow,Own,137000,M,42,2
8200000,ELLIE,RAYMOND,Married,Rent,136000,F,50,0
8300000,PATRICK,ZORO,Divorced,Rent,138000,M,40,1
8400000,SHAWN,JONES,Divorced,Own,75000,M,40,2
8500000,ABBIE,LAUREN,Single,Own,200000,F,19,0
8600000,ELSIE,VANDER,Single,Own,200000,F,30,0
8700000,SARAH,PETERS,Single,Own,200000,F,19,0
8800000,ALLIE,BOWERS,Single,Own,200000,F,40,0
8900000,KELSEY,SMITH,Single,Own,200000,F,28,0
9000000,KIM,TENNEL,Single,Own,200000,F,56,0
9100000,TJ,CASWELL,Single,Own,200000,M,25,0
9200000,HELEN,SPOTS,Single,Own,200000,F,29,0
9300000,JOHN,MOORE,Single,Own,200000,M,43,0
Importing Account History Data
The import command for the Account History table looks like this:
import dmcat.whse.acct_history
-I importdataa.txt -U importfmta.txt