Shell Programming and Scripting

Hi

I am a complete newbie in unix. Learning the ropes. I have a task where I have to write a shell script to read a file line by line. I have tried some code from the net like.

The file data looks like this.

FIN427;2010003;2010003
FIN475;2010001;2010003
FIN476;2010001;2010003
FIN474;2010001;2010003

I want the script to read the parm file one by one and result should like this:

DELETE FROM FINDBT40.FIN427 where fiscper between 2010003 and 2010003;

DELETE FROM FINDBT40.FIN475 where fiscper between 2010001 and 2010003;

DELETE FROM FINDBT40.FIN476 where fiscper between 2010001 and 2010003;

DELETE FROM FINDBT40.FIN474 where fiscper between 2010001 and 2010003;

Code:

awk -F';'  '{ printf("DELETE FROM FINDBT40.%s where fiscper between %s and %s\n",
              $1, $2, $3) }'  inputfile > outputfile.sql

Thanks for such a quick reply. What I am trying to do is put the parameter into the delete sql and run it. I am using the BTEQINF file to run the sql.

So my question is, how can I read the paramter value from fiscper.parm and run the DELETE SQL with correct tablename and number values.

Here is what I wrote:

Code:

while read -r tbl_name st_dt en_dt
do
     tbl_name=`cut -d";" -f1 /transfer/sap_fin/sap_rsync/cca/fiscper.parm`
     st_dt=`cut -d";" -f2 /transfer/sap_fin/sap_rsync/cca/fiscper.parm`
     en_dt=`cut -d";" -f3 /transfer/sap_fin/sap_rsync/cca/fiscper.parm`
     /upapps/inf/dev/scripts/bteqinf > /upapps/inf/dev/scripts/sap_bi_fin/findbt40;
     'DELETE FROM FINDBT40."$tbl_name" where fiscper between "$st_dt" and "$en_dt";'
     /upapps/inf/dev/scripts/bteqinf <<-!
done

What this script is doing is putting all the first column values into one

something like

DELETE FROM FIN427
FIN475
FIN474
FIN 476
where fiscper between 2010003
2010001
2010001
2010001

and 2010003
2010003
2010003
2010003


and I want it to be able to run the sql when I run the script.

DELETE FROM FINDBT40.FIN427 where fiscper between 2010003 and 2010003;

DELETE FROM FINDBT40.FIN475 where fiscper between 2010001 and 2010003;

DELETE FROM FINDBT40.FIN476 where fiscper between 2010001 and 2010003;

DELETE FROM FINDBT40.FIN474 where fiscper between 2010001 and 2010003;

edit by bakunin: please note that code-tags around code are a free-of-charge add-on of this forum. Don't be shy to use them yourself from now on.

Code:

sed 's/;/ /g;s/^\(.[^ ]*\)\(.[^ ]*\)\(.[^ ]*\)/DELETE FROM FINDBT40.\1 where fiscper between \2 and \3/' file

Hi,

Can you explain what the command doing?

Code:

sed 's/;/ /g;s/^\(.[^ ]*\)\(.[^ ]*\)\(.[^ ]*\)/DELETE FROM FINDBT40.\1 where fiscper between \2 and \3/' file

edit by bakunin: the same as said above goes here. Thank you for your cooperation.