OdbcOutput Update and Insert
Posted: Thu Aug 04, 2022 5:15 pm
Hi Expert,
I know how to write the sql for odbcoutput Insert (if I truncated the table).
I know also how to write the Update, if I dont want to truncate the table.
My problem, is that the second one (which I want to use, because I dont want to truncate the table) does not do the inserts for new records.
The TI does not even give me an error when a new record is found in tm1.
what is the way to do both in the TI process.
thanks
I know how to write the sql for odbcoutput Insert (if I truncated the table).
I know also how to write the Update, if I dont want to truncate the table.
My problem, is that the second one (which I want to use, because I dont want to truncate the table) does not do the inserts for new records.
The TI does not even give me an error when a new record is found in tm1.
what is the way to do both in the TI process.
thanks