topic Sql Loader Help in Operating System - HP-UX

Sql Loader Help

Rajkumar_3 — Sat, 03 Nov 2001 10:35:16 GMT

Hai All,

I have a text file which contains the data to be inserted into table called INFO..

I have attached that txt file for reference.
I want to insert the data into the following table INFO into 6 different columns

Create table info
(a number,
b number
c number
d number
e number
f number);

For Eg:
-----------

4 2 120 106 24.07 43
442 2 106 104 20.49 35

using SQL LOADER

Any help is Appretiated..

B/Regds
Raj

Re: Sql Loader Help

Thierry Poels_1 — Sat, 03 Nov 2001 11:08:19 GMT

Hi,

how about first processing this file through sed or awk, and replacing all '->' and ':' by whitespace?? Afterwards you can use a very simple sql loader control file (fields seperated by whitespace).

good luck,
Thierry.

Re: Sql Loader Help

Rajkumar_3 — Sat, 03 Nov 2001 11:31:56 GMT

Hai,

Thank you for your reply..Presently this database is running on NT.

Is there any alternative method???

B/Regds
Raj

Re: Sql Loader Help

Thierry Poels_1 — Sat, 03 Nov 2001 12:10:08 GMT

hi,
how about a perl script then ?

You could try this, I'll use the '>' as a separator, and consider the '-' as a negative sign, and then use its absolute value:

LOAD DATA
INFILE 'yourfile'
APPEND
INTO TABLE info
FIELDS TERMINATED BY whitespace
(a integer external terminated by '>' "abs(:a)" ,
b,
c terminated by ':',
d,
e,
f)

hmmm, not sure about the whole syntax, but gives you something to play with :)

good luck,
Thierry.