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.
September 30, 2008 12:01 PM
October 1, 2008 3:17 PM