I have a flat file which I want to update starting from position 2 to 4. I used below UPDATE statement:
SET SUBSTR(FLAT_FILE,2,2)= 'AA'
WHERE SUBSTR(FLAT_FILE,1,2) = 'HH'
The above SQL Query is throwing an error SQL0104 for missing token.
Can anybody suggest me on the above.
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!