Update a single row with current date value 1

[bitsinc]

Within Decision Stream, I need to update rows in a table that has two fields - one 3 character text field and one date/time field. The 3 character text field will be the key and a row will exist for each jobstream within Decision Stream. In our environment, we have six distinct jobstreams. At the end of each jobstream, I want to update the row for that particular jobstream with the current date and time. This way, any reporting from the database (Oracle in our case) can query this table to know exactly when Decision Stream last successfully copied transaction production data. Can anyone help with this or does anyone know a better way?

 

[MattOh]

Probably the easiest way to do this is to add a SQL Node to the end of your JobStream that simply performs a SQL Update to that row in the table. You might also look at the Audit and Run tables in the DS catalog (e.g.DS_jobnode_run). These provide some automatic information.

 

[bitsinc]

Thanks MattOh. This is what we did and it worked perfectly.

 

[MattOh]

Great! Good luck.