Shell Programming and Scripting

Hi ghostdog,

As far i know there is no design issue.For your understanding let me explain.

I have One input file SOURCEFILE,keyfields=1|2|3,delimiter=|
I have three lookupfiles JOINFILE1,JOINFILE2,JOINFILE3 which are having the keyfields 3,4,5 and delimiters :,;,| respectively

based on the above files,i have to make one script file.
the sample script file shows like this
SCRIPTFILE
-------------
update table crn_ras_disc_dtl a set a.a5=SOURCEFILE.2,a.a1=JOINFILE1.3,a.a2=JOINFILE3.5,a.a3=JOINFILE2.3,a.a4=JOINFILE1.2;

For each lookup file
Join source file and the lookupfile with the keyfields and the respective delimiters
Append the Outpufield(s) by referring the SCRIPTFILE and its field (Append $3 of JOINFILE1 with the at the last of the input file) at the last of input file.
Change the sample script file and change the position
[ Assume SOURCEFILE has 20 fields. Eg: update table crn_ras_disc_dtl a set a.a5=SOURCEFILE.2,a.a1=JOINFILE1.3,a.a2=JOINFILE3.5,a.a3=JOINFILE2.3,a.a4=JOINFILE1.2;
to be replaced as update table crn_ras_disc_dtl a set a.a5=SOURCEFILE.2,a.a1=SOURCEFILE.21,a.a2=JOINFILE3.5,a.a3=JOINFILE2.3,a.a4=JOINFILE1.2;
]
done

Run the SCRIPTFILE by referring the LAST JOIN and its position.

Please suggest me.

cskumar to be honest, I didn't understand very well your last explanation. However, have you thinked about inserting all the informations in database's tables and do the joins inside the db? As I said before I didn't get the point of your problem very well and maybe this approach isn't possible but... I wished to share my thought

hi
some observations:

1) i think in all sql-dialects you must enclose a string in some kind of quotes
2) the result of executing such a sql-file will be the same as executing only the last update, perhaps you want to insert the data
3) if you want to insert data most database systems have tool to load text-files efficiently, e.g oracle has sqlldr

mfg guenter

probably shouldn't say this but, cat is useless here.

cskumar , can you please elaborate more on the question please ????

your last explanation with sample confused a lot.......

Perhaps this.

Code:

[/tmp]$ cat file1
update table crn_ras_disc_dtl a set a.a5=$1,a.a1=$2,a.a2=$3,a.a3=$4,a.a4=$5;
[vivarkey@/tmp]$ cat file2
10|KUMAR|23|MALE|US
20|RAJ|24|MALE|AU
[/tmp]$ cat try.sh
#! /bin/sh

FINAL="$(<file1)"

while read line
do
    set -- ${line//|/ }
    eval echo $FINAL
done < file2
[/tmp]$ ./try.sh
update table crn_ras_disc_dtl a set a.a5=10,a.a1=KUMAR,a.a2=23,a.a3=MALE,a.a4=US
update table crn_ras_disc_dtl a set a.a5=20,a.a1=RAJ,a.a2=24,a.a3=MALE,a.a4=AU
[/tmp]$