Hi,
I have a channel with a database connection in the source side.
I want to use 'Run on-update statement' event in order to mark every record sent.
I've created a new table called TRU_INTTB001 where I intend to save the records sent identifier because I can't add a status field in the master table.
The 'on-update SQL' field contains:
INSERT IGNORE INTO TRU_INTTB001 VALUES (${historia},${epi},SYSDATE,'UCI001');
When I deploy and start the channel it seems work fine (no errors, and messages sent well) but nothing happens in TRU_INTTB001 table. There are no records in.
The database user have correct permissions to write in this table.
Anybody knows why?
Thanks a lot.
carles massalle
uci01x.xml (25726 bytes)
I have a channel with a database connection in the source side.
I want to use 'Run on-update statement' event in order to mark every record sent.
I've created a new table called TRU_INTTB001 where I intend to save the records sent identifier because I can't add a status field in the master table.
The 'on-update SQL' field contains:
INSERT IGNORE INTO TRU_INTTB001 VALUES (${historia},${epi},SYSDATE,'UCI001');
When I deploy and start the channel it seems work fine (no errors, and messages sent well) but nothing happens in TRU_INTTB001 table. There are no records in.
The database user have correct permissions to write in this table.
Anybody knows why?
Thanks a lot.
carles massalle
uci01x.xml (25726 bytes)
Comment