Re: SQL question (retriveing n number of rows)
I do a shell script wrapper of the dbaccess stuff, first get
a bunch of keys, put them in a shell variable like:
KEYS=`dbaccess_shell_procedure`
Then I do a shell for loop with a counter to control the number
of iterations:
(syntax not accurate)
for i in $KEYS
do
j=$j+1
another_dbaccess_single_key_select_procedure $i # pass in KEY
test $j -eq 10 && break
done
Slow, ugly, yes. Simple yes. Or use stored procedures.