470,821 Members | 2,041 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,821 developers. It's quick & easy.

DB2 Z/OS - Cross Region Alias Not Working v8 Clients ?

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
Oct 13 '06 #1
0 1126

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Tim Pascoe | last post: by
2 posts views Thread by Kim Noer | last post: by
3 posts views Thread by Klint Gore | last post: by
6 posts views Thread by =?Utf-8?B?bGpsZXZlbmQy?= | last post: by
reply views Thread by Mahesh K. Anajni | last post: by
3 posts views Thread by Jake G | last post: by
4 posts views Thread by WT | last post: by
1 post views Thread by =?Utf-8?B?U0FM?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.