Cannot append strings to LONG column in JDBC, assistance please

[john doed]

When trying to append (concatenate)to a LONG column I get the following error:
[-7032] (at 39): SQL statement not allowed for column of data type LONG

sql = "UPDATE CHAT_TRANSCRIPTS SET chat_log= chat_log & ? WHERE chat_id=?";

pstmnt = con.prepareStatement(sql);
pstmnt.clearParameters();
pstmnt.setString(1, msg);
pstmnt.setString(2, chatID);
pstmnt.executeUpdate();

Is there any way I can append to chat_log without doing an EXTRA SELECT and including it with "msg" each time?

thanks




_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general