Update in SQL
I have a flat file which I want to update starting from position 2 to 4. I used below UPDATE statement: UPDATE FLAT_FILE 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. Thank You.

Answer Question   |  October 1, 2008  12:01 PM
Flat files, SQL/400, SQL0104, UPDATE statement