×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I am running the following SQL statement in STRSQL (green screen) on V5r4.
update rjsimage/docs00
set chkdate =
timestamp(date(substr(keyword4,1,10)),time('00:00 AM')),
expdate = chkdate + 2 years
where doctype2 = 'GENERALMTHSTMNT'
Looking at each individual row, the CHKDATE column is updating perfectly.
However, the EXPDATE is not being updated, OR it is updating prior to the new CHKDATE timestamp calculation.
If I include a WHERE clause targeting one specific row, then it works well.
Any idea why EXPDATE (expiration date) is not updating to be CHKDATE plus two years?
Thanks!
______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit
http://www.symanteccloud.com
______________________________________________________________________
midrange.com
