SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-54
Examples of import
Data to Input
Suppose you have an input file named X.in , containing the following 10 lines
11,12345678
A8,22345678
11,82345678
14,423456789
17,52345678,9
15,62345678
27,72345678
5,32345678
BZ,XYZ
55,12345678
Execute the following command:
import cat.sch.Xample -i X.in -L 50 -E X.perrs -PM
X.perrmsg \
-XL 5 -XE X.xerrs -XM X.xerrmsg \
-SF X.sum -SI 10
Output
NonStop SQL/MX Import Utility 2.3
(c) Copyright 2007 Hewlett-Packard Development Company, LP.
Rows Imported = 4
Import Completed with some non-fatal errors
A select statement on the table would show the following:
select * from cat.sch.Xample;
C1 C2
-------- --------
11 12345678
15 62345678
27 72345678
55 12345678
--- 4 row(s) selected.