How Can tDBRow Other Database!?

[Anonymous]

My Query(tDBRow)

DROP TABLE IF EXISTS CSTMRDB.CSV100_rown;
CREATE TABLE CSTMRDB.CSV100_rown
AS
SELECT ROW_NUMBER() OVER( ORDER BY A.cust_id) AS "NO", A.*
FROM DEV2.CSV100 AS A;

usually, if i need sql query(update, delete, create ...)

i used tDBrow. but this have one target DB

but my query is using two DB( CSTMR, DEV2 )

is it possible?

[Anonymous · Accepted solution]

personally i solved sorry

[Banupriya]

Could you please share the steps?I want to load data from one (source) database to another (target)database using insert query in tdbrow. But I can select only one db connection in tdbrow. How to achieve this? ​It's giving the error table does not exist because I have selected the target db connect so it's failed to get data from source DB.