I read my DB2 manual for positioned update (update .... current of)
it says for positioned update:
You cannot use an UPDATE statement to modify the rows of a created
temporary table. However, you can use an UPDATE statement to modify
the rows of a declared temporary table.
so what does it mean? what is created temporary table and what is declared temporary table?
Anyone knows?
it says for positioned update:
You cannot use an UPDATE statement to modify the rows of a created
temporary table. However, you can use an UPDATE statement to modify
the rows of a declared temporary table.
so what does it mean? what is created temporary table and what is declared temporary table?
Anyone knows?