loop question to do sql update using two input files

[chapm4]

I am writing a script in qnx to do a sql update and need some help. I am using two input files. Here is what I am doing that obviously doesn't work:

for wid in $(cat workId.txt)
for seqNum in $(cat sequenceNumber.txt)
do
csql -c "update workIdStack SET workId=$wid where_ sequenceNumber=$seqNum"
done
done

The underscore in this case is a line continuation. This may be a simple issue but I am lost.

 

[OraCool]

Try this if the underscore is creating the problem:
I think you would need a space after the word 'where' ?

for wid in $(cat workId.txt)
for seqNum in $(cat sequenceNumber.txt)
do
csql -c "update workIdStack SET workId=$wid where \_ sequenceNumber=$seqNum"
done
done