|
| Alias gives sqlcode=-512 on bind |
 |
Mon, 04 Feb 2008 04:26:48 EST |
Hi,<br />
We are running DB2 UDB V8 for z/OS. We have an application accesing table on
remote DB2 UDB for z/OS using an alias.Tried binding with DBPROTOCOL(DRDA) and
still get error. The scenario is <br />
DSNA-LOC1<br />
create alias user2.myalias for LOC2.user1.table1<br />
<br />
On DSNB- LOC2, we have<br />
table user1.table, and select has been granted to public on all locations on
user1.table1.<br />
<br />
|
| Post Reply
|
| Re: Alias gives sqlcode=-512 on bind |
 |
Mon, 11 Feb 2008 14:44:47 -000 |
In article
<1968112237.1202117239427.JavaMail.wassrvr@ltsgwas010.sby.ibm.com>,
vusumzi.kopo@googlemail.com says...
> Any ideas?
>
IIRC, You need to define the alias on both the local and remote systems
with protocol(DRDA).
--
Dougie Lawson
|
| Post Reply
|
|
|
|
|
|
|
|
|
|