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.