Search Results

Search: Posts Made By: mrAibo
3,229
Posted By RudiC
The overall approach seems a bit complex,...
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...
3,229
Posted By nezabudka
join -12 -22 -o 1.1,2.1 et.tst itid.tst | while...
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
3,229
Posted By nezabudka
Well, I can absolutely accurately reproduce ...
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...
3,229
Posted By nezabudka
eval echo -ne "db2' '-x' \"'select' 'DOCID'...
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...
3,229
Posted By nezabudka
The thing is that the files do not consist of a...
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'...
Showing results 1 to 5 of 5

 

Featured Tech Videos

All times are GMT -4. The time now is 11:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy