Hi All,
I have a cross region alias defined - DB2 Z/OS v8
When I execute 'SELECT * FROM AAA.X_REGION_ALIAS' I get the following
results;
SPUFI - works fine
DB2 Client v7 - works fine - (query executed via JAVA & MS Excel)
DB2 Client v8 - fails - (query executed via JAVA & MS Excel)
[IBM][CLI DRIVER][DB2] SQL0204N "AAA.X_REGION_ALIAS" is an undefined name.
SQLSTATE=42704
I've tried this on multiple desktop machines / connecting to multiple
servers. All exhibit the same symptoms.
- Any idea what could be wrong with the v8 client set-up ?
(All other functionality apart from querying x-region alias appears to be
working fine)
TIA
Bill