Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Billy Wheeler — — source: Informix-list mailing list archive (1991-1998)
>
> Here goes : how can I, using the dbimport tool get some tab-delimited
> text-file data into my database ? (the file comes over from PC access
> database)
OK. You wouldn't use dbimport, you would use either dbaccess with a LOAD
command or you would use dbload.
The bluntest way to do what you want (because that's the way I approach remote
support is:
1) vi your_raw_data_file
2) :1,$s/ /|/g
(where the spaces above are a TAB)
3) save the file.
4) dbaccess dbname
q
n
LOAD FROM your_raw_data_file INSERT INTO customer;[ESC]
r
HTH and good luck.
--
Ciao,
Billy
+------------------------------------------------------------------------------+
| Billy Wheeler Chief Cook and Bottlewasher The West Solutions Group |
+------------------------------------------------------------------------------+
| (E) billy@west.co.za (U) http://www.west.co.za/billy.html |
+------------------------------------------------------------------------------+
| Microsoft Word 6.0a to your mother .... |
+------------------------------------------------------------------------------+
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.