Search Results

The overall approach seems a bit complex, selecting rows with identical criteria from a few different tables. How about serving a single db2 invocation a script, selecting all the criteria with an...

join -12 -22 -o 1.1,2.1 et.tst itid.tst |
while read a b; do
db2 -x "select DOCID from ICMADMIN.$a where ITEMID='$b'"
done
Reread I fixed the code

Well, I can absolutely accurately reproduce
eval echo -ne "db2' '-x' \"'select' 'DOCID' 'from' 'ICMADMIN.{$(paste -sd, et.tst)}' where ITEMID='\'{$(paste -sd, itid.tst)}\''\"\n'"
db2 -x "select...

eval echo -ne "db2' '-x' \"'select' 'DOCID' 'from' \"'ICMADMIN.{$(paste -sd, ITEMID.txt)}'\" where ITEMID=\"'{$(paste -sd, et.txt)}'\n'" | bash

--- Post updated at 14:07 ---

Another variant...

The thing is that the files do not consist of a list as stated, but of the lines!

--- Post updated at 13:37 ---

it is very easy to solve
eval echo -ne "echo' '-x' \"'select' 'DOCID' 'from'...