Joined: 20 Oct 2006 Posts: 6970 Location: porcelain throne
what does you sql look like?
update table A
uuid = :uuid
even your second post sucks. where is the SET keyword?
top of the page are links to manuals. suggest you get acquainted with them; you are never going to get very far if you can not even copy sql. as a result, you are only going to get guesses.
right is a db2 function. RTFM.
The RIGHT function returns a string consisting of the specified number of rightmost integer characters of string-expression. If string-expression is a character or binary string, a character is a byte. If string-expression is a graphic string, a character is a DBCS character.