SQL/MX Data Mining Guide

HP NonStop SQL/MX Data Mining Guide—523737-001

C-1

Importing Into the Data Mining

Database

The format file, data file, and the import command provided in this appendix enable

you to populate the data mining database. You cannot execute the import utility

command through MXCI or in programs. You must run import at the command prompt.

For further information, see the import Utility entry in the NonStop SQL/MX Reference

Manual.

Importing Customers Data

The import command for the Customers table looks like this:

IMPORT dmcat.whse.customers

-I importdatac.txt -U importfmtc.txt

Customers Format File

This file is named importfmtc.txt and is the format file specified in the preceding

IMPORT command:

[DATE FORMAT]

DecimalSymbol=.

[COLUMN FORMAT]

col=account,N

col=first_name,N

col=last_name,N

col=marital_status,N

col=home,N

col=income,N

col=gender,N

col=age,N

col=number_children,N

[DELIMITED FORMAT]

FieldDelimiter=,

Customers Data File

This file is named importdatac.txt and is the data file specified in the preceding

import command:

1234567,MARY,JONES,Single,Own,65000,F,34,0

2500000,ALI,ABBAS,Divorced,Rent,32000,M,23,0

4098124,TOMOKO,KANO,Divorced,Own,44000,M,44,2

2400000,ERIKA,LUND,Widow,Own,28000,F,65,0