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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!