Quote:
Originally Posted by
zaxxon
You wrote your own answer -> check you matching code for those keys. Maybe put a "set -x" in front of the the line where the error occurs and check what it does. Or echo your variable names to see what's stored in them.
I can't try to fix it, because I have no access to your code since you did not post it, nor am I sure if I could
So the next logical thing would be to fix that code or ask someone who can fix it.
GL
Hi,
Thanks for the Reply.
I am getting the same Error.Table name is correct.
Code on line no. 485 is:
table1_entry()
{
new_table=''
while [ -z "$new_table" ]
do
echo " "
echo "Enter name of table 1:"
read new_table
echo "t2::$new_table"
done
}
If I remove this functionality then I am getting correct ans without any Errors.But if I am comparing data for Primary key then I am getting that Error. there is additional code in this function to match other columns which r not primary key.It works fine for them.
key_query()
{
bteq<<-EOD
.logon $PASSWORD;
.set width 64000
.export report file=$path/match1.msq
.titledashes off
((select $pk_key
from $new_database.$new_table
minus
select $pk_key
from $base_database.$base_table) UNION
(select $pk_key
from $base_database.$base_table
minus
select $pk_key
from $new_database.$new_table));
.export reset
}