I am trying to change part of a field using the substring command in interactive SQL.
To do this I entered the following:
UPDATE LIBRARY/FILE_NAME SET SUBSTR(FIELD_NAME1,194,4) = 'XXXXX' WHERE FIELD_NAME2 = 99999
I get the error token ( was not valid. Valid tokens: = .'
Obviously there is a syntax error but O cannot figure it out.
February 11, 2008 3:50 PM
April 19, 2013 6:52 PM