467,104 Members | 1,029 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Nickname in two phase commit ???

Hi,
I have two databases in the same instance, sourcedb and
targetdb. In sourcedb I created one table (t1). In targetdb I created
another table (t2).

In sourcedb I created one nickname (N2) for T2 table in targetdb.

I can execute this statement OK

db2 "insert into T1 values......"

this statement OK (insert into nickname connected to sourcedb)

db2 "insert into N2 values ....."

but I can't execute both statements in the same transaction

db2 +c "insert into T1 values ......"
db2 +c "insert into N2 values ......"
DB21034E The command was processed as an SQL statement because it was not
a
valid Command Line Processor command. During SQL processing it returned:
SQL30090N Operation invalid for application execution environment. Reason
code = "18". SQLSTATE=25000
What's the problem here ?????
Thanks in advance
Mel

*** Sent From/Enviado desde: http://groups.expo.st ***
Nov 12 '05 #1
  • viewed: 1044
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by William Chan | last post: by
4 posts views Thread by MelApiso | last post: by
3 posts views Thread by Jean-Marc Blaise | last post: by
5 posts views Thread by Ravi Chirawala | last post: by
2 posts views Thread by amoon.ljlj@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.