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 ***