Hi,

My query is as follows:

(1) I want to write a Schell Script which will first read multiple files.Each file contains multiple lines/records.
(2) Each line /record in a file starts with 'H' , 'D' or 'P'
(3) So want a shell script - which will read the FIRST CHARACTER of each line in a file.
(4) If the first character is 'H' , it will insert that line/record in database TABLE1
(5) If the first character is 'D' , it will insert that line/record in database TABLE2
(6) If the first character is 'P' , it will insert that line/record in database TABLE3

So depending on the FIRST CHARACTER of each line in a file , that line/record will be inserted into different oracle database tables.

-- Abhay

--Abhay

Hi ,
I am just putting a sample of the Lines in a file:

H|820020080422|AAA|03/27/2008|3.0.5
D|99.114|ADLT|1|60.00||60.00|60.00
D|99.683|ADLT|1|28.00||28.00|28.00
P|03/27/2008|CS|KKKK|HHHHH|||70.00
P|03/27/2008|CC|kkk|kkkk|1111||18.00
P|03/27/2008|CS|KKKK|HHHHH|||-28.00

So shell script will read each line and then depending on first character of the line - will insert into different tables.

Thanks

--Abhay

Your shell script cannot insert into Oracle tables. SQL*Loader (sqlldr) can read your file and insert into the various tables.

if you can download and install gawk from here:
http://gnuwin32.sourceforge.net/pac...

save the below code as script.awk

BEGIN{FS="|";q="\047"}
/^H/{ t=table1}
/^D/{ t=table2}
/^P/{ t=table3}
{
  sql="insert " t "values("q$1q","q$2q","q$3q","q$4q","q$5q")"
  cmd="sqlplus blah blah " sql
  print cmd
#   system(cmd) #uncomment when needed.
}

on the command line:

c:\test> gawk -f script.awk inputfile
sqlplus blah blah insert values('H','820020080422','AAA','03/27/2008','3.0.5')
sqlplus blah blah insert values('D','99.114','ADLT','1','60.00')
sqlplus blah blah insert values('D','99.683','ADLT','1','28.00')
sqlplus blah blah insert values('P','03/27/2008','CS','KKKK','HHHHH')
sqlplus blah blah insert values('P','03/27/2008','CC','kkk','kkkk')
sqlplus blah blah insert values('P','03/27/2008','CS','KKKK','HHHHH')

of course, i have created a fictitious command for inserting your tables. you have to modify it your own to use with oracle(?) , accordingly.