Shell Programming and Scripting

Hi Unix Gurus,

I need your help in below mentioned problem:

$input_file -----> This file has number of SELECT COUNT(*) statements. Ther could be 1 statement or more than 1, it is not fixed.

[B][U]I need to implement the following logic.....

for i in `cat $input_file`
do
calculate count of SELECT COUNT(*) statement
(if possible, I need to store the count of each statement in a variable)
if count >= 200000
then
exit processing
fi
done


Thanks in advance !!!

Are all your select count(*) statements single line statements?
&
Which database you are using?

I am using db2 database.....
following is the example of SQLs present in the input file:


select count(*) from F0547DBA.TEST_LOAD where TRXN_CODE='1';
select count(*) from F0547DBA.TEST_LOAD where TRXN_CODE='2';
select count(*) from F0547DBA.TEST_LOAD where TRXN_CODE='3';
select count(*) from F0547DBA.TEST_LOAD where TRXN_CODE='4';
select count(*) from F0547DBA.TEST_LOAD where TRXN_CODE='5';
select count(*) from F0547DBA.TEST_LOAD where TRXN_CODE='6';
select count(*) from F0547DBA.TEST_LOAD where TRXN_CODE='7';
select count(*) from F0547DBA.TEST_LOAD where TRXN_CODE='8';
select count(*) from F0547DBA.TEST_LOAD where TRXN_CODE='9';

Not sure how to connect with db2. I will give you a sample with sqlplus (connects to oracle). Please edit the corresponding code as per db2:

Code:

for i in `cat $input_file`
do
count=$(sqlplus id/password@connect_string <<EOSQL
$i
exit
EOSQL
)
[ $count -gt 200000 ] && exit
done

But this is will slow down the processing. because you have to connect and disconnect with the database in every iteration. Just check if this works in your case.

thanks for helping me.....
i'll try this but I need to know the command used to execute in DB@ in place of sqlplus...

Any ideas of a client tool you are using in the box to connect to the database. If, then please give the exact command with arguments. I can try based on that.

i'm using db connect to <databse-name> user <user_name> using <password> command to connect to database....
i need not to connect to databse inside the loop as I am already establishing a connection in my script

all I need is the command to execute the SQL