Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
personally i solved sorry
personally i solved sorry
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.