SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

ManualsBrandsHP ManualsServerHP NonStop G-Series

541

542

543

544

545

546

547

548

549

550

SQL/MX Utilities

HP NonStop SQL/MX Reference Manual—523725-004

5-33

Examples of import

DateDelimiter=/

TimeDelimiter=:

FourDigitYear=Y

DecimalSymbol=.

[COLUMN FORMAT]

col=id,N

col=company,N

col=phone,N

col=fax,N

[DELIMITED FORMAT]

FieldDelimiter=,

RowDelimiter=\n

Qualifier="

import Load Command

This import command imports data into the COMPANY table from the delimited input

file named COINPUT using the format file FORMFILE:

import cat.sch.company -I coinput -U formfile -W DELIM

•

This example shows how to import data from a fixed width import file:

Data to Input

The input file, COINPUT, contains records like this:

1,ibm,408-111-2222408-222-3333

2,apple,408-222-1111408-333-2222

3,tandem,408-285-5000408-285-2227

4,diyatech,510-111-2222510-222-3333

Format File Describing the Data

[DATE FORMAT]

DateOrder=MDY