Need help to run sql query from a script..which takes input from a file

Shell Programming and Scripting
1

I need to run sql script from shell script which takes the input from a file and contents of file will be like :

12345
34567
78657

and query will be like :

select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr from bus_event where event_nbr='78657';

the letters in bold will be taken from file..
:confused:
Can anyone please help me out in this..

2 
$ cat fil
12345
34567
78657

Query output:

$ awk '{print "select seq_nbr from bus_event where event_nbr="q$0q";";}' q="'" fil
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr from bus_event where event_nbr='78657';

Guru.