I am writing my first SQl in an RPG
The statement I am using is:
UPDATE AQUA20/XNMSGX SET ISTS = 'd', ISTATE = 'a' WHERE ISTS='C'
and ISTATE='C'and idate<20010501
1. Does the statement look okay
2. Can I, and how would I, use a variable in the statement - the date I am checking against will change daily