[Squirrel-sql-users] sql result table is not readable and problem with update statement for DB2 database

[arihan <ari...@gm...>]

Hi All,

FOR DB2 database
=============
When I am executing the sql command as SELECT * FROM STM.LOAN where ID =
72000695; and try to edit the sql results table it doesnot allow me. 

I've sql results as editable table in new session properties -> Genral .
Also even if you don't make it editable then you can right click on the
column and it would give me the option to make editable. I tried both and it
doesn't work

Could you please let me know if I am facing this problem. 
When I click the objects -> table name > content tab and try to edit it then
it works fine. It gives me "make editable" option by right click on the
column.

Actually I am trying to use the update statement by taking different
combinations

UPDATE STM.LOAN SET ADDRESS = 'XYZ' WHERE ID = 72000695;
UPDATE "STM"."LOAN" SET ADDRESS = 'XYZ' WHERE ID = 72000695;
UPDATE STM.LOAN A SET A.ADDRESS = 'XYZ' WHERE A.ID = 72000695;

it gives the error as 
Error: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501,
SQLERRMC=APPTEST;UPDATE;STM.LOAN, DRIVER=3.50.152
SQLState:  42501
ErrorCode: -551

Is anything wrong in the syntax of update statement. Any quick help would be
highly appreciable.

Cheers
Arihan

-- 
View this message in context: http://old.nabble.com/sql-result-table-is-not-readable-and-problem-with-update-statement-for-DB2-database-tp32097939p32097939.html
Sent from the squirrel-sql-users mailing list archive at Nabble.com.