A view is built on the database A
The create view st as (a)
Select a from B.d bo. St
LiBiao B.d bo. St is another database, building A DW1 PB in the data source is A st, connected transaction is A, to watch B.d DW1 save bo. St matters is how to control?

CodePudding user response:

The transaction dbtrans
Dbtrans=create transaction

Dbtrans. DMBS="odbc"
.
Join another database,

According to the need to select the corresponding transaction data window:
Dw_1. Settransobject (sqlca)

Or
Dw_1. Settransobject (dbtrans)

CodePudding user response:

The transaction SQLCB
SQLCB=create transaction

As with the default SQLCA usage,,

The two database operations, COMMITUSINGSQLCB;
COMMITUSINGSQLCA,
Submitted separately!!!!!!

CodePudding user response:

I also want to know, is looking for this information ~ ~ ~ ~ ~