As indicated by the text of the error message, you can only update against
two databases simultaneously if your execution environment supports it. In
general, this means executing under the control of a suitable transaction
monitor - either an external one (recommended) or the DB2-provided one (last
resort measure). Review the documentation on configuring and using
transaction monitors.

The db2 command line processor is not a transaction monitor, so your case
won't work.

"MelApiso" <Mel_Apiso@hotmail.com> wrote in message
news:b4154ebb02141cb8b38caf1ef7246faa$1@groups.exp o.st...
> 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 ***
>
>