People,
I've ventured into the wonderful world of Stored Procedures. My first
experience has been relatively successful however I am stuck on using
host variables to specifiy actualy table or column names in a FROM

We upgraded the Windows ADC V8.1 to fixpack 5 on some Windows 2000
(Dutch Version) professional machines and something strange happened.
When we select decimal columns in our queries the decimal separator of
the decimal columns has become a comma while it was a dot.

I wanted to upgrade my adc to fixpack 5 on Windows XP Professional
(Dutch edition). However after unzipping the cab files the Windows
installer quits with a dialog saying (translated from Dutch):
Incorrect command line parameters.

I have a question here regarding setting the prefetch size. So far we took
the rule that for OLTP, prefetchsize = extent size and for DSS prefetchsize
= extent size * number.
However, especially due to the "Skip Scans" for indexes I started to

Two questions:
Just downloaded and applied fixpak5 for db2 V8 for Windows.
Is it inclusive from the initial release of V8?  Is there a policy
regarding fixpaks and whether they are inclusive?  If they are not,

I'm trying to interpet a db2 explain.  I'm trying to determine if the SQL is
being executed as I expect/hope.
The sql is generally:
select key from table where key1=value and key2 > value2 and key2 < maxkey