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