AJM1958
15th May 2012, 23:14
All our purchased items have an order interval of 28 days in session tcibd2100s000 and we want to set them to 14 days. Does anybody know how to do this using an update script?

bdittmar
16th May 2012, 09:46
All our purchased items have an order interval of 28 days in session tcibd2100s000 and we want to set them to 14 days. Does anybody know how to do this using an update script?

Hello,

write an normal update session like :



retry.point()

select field
from table for update
where
selectdo

newfieldvalue = 14
db.update(table, MODE)
commit.transaction()

endselect



Use a proper forum in future, please.
(Not general discussion and chat)

Regards

NvpBaaN
22nd May 2012, 02:53
If using an update script is not an absolute requirement, you could even carry out this simple update using GTM.