Hi,
I feel I am going nuts trying to figure out something and get into other problems.
I have a DB2 UDB Enterprise Edition version 7.1. I recently upgraded to FixPack 14.
I try to update a column for a table, but it doesn't happen anything.
I used the following command in the Command Center:
UPDATE USER.T2 SET TEST = 'A'
And sometimes the result says:
------------------------------ Command Entered ------------------
UPDATE USER.T2 SET TEST = 'A'
-----------------------------------------------------------------------------
and nothing else.
When I try to see the content of the table, I type a simple command:
SELECT * FROM USER.T2
and the table shows the column TEST with the old values. Nothing changed.
Sometimes for either the UPDATE or the SELECT command, I get this error:
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014
SQL0952N Processing was cancelled due to an interrupt.
(For example when I have this error for the SELECT command, and I try to press CTRL + ENTER the second time to execute the command, it will show the results. But still the UPDATE command doesn't change anything)
Does it mean that it is something wrong with my DB2 installation?
Best Regards,
Steven