DB2 - Problem description
Problem IT34588 | Status: Closed |
SQL30090N WHEN WE USE UPDATE WITH PLACEHOLDER (VARIABLE) VIA JDBC | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
UPDATE XXX.YYY SET COLUMN1 = WHERE COLUMN1 = 1; ==> Works UPDATE XXX.YYY SET COLUMN1 = :0 WHERE COLUMN1 = :1; ==> generate SQL30090N you can simulate it with and update from select like: db2 "update XXX.YYY set ("COLUMN2") = (select * from (values (''))) where "COLUMN2" = ''" DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL30090N Operation invalid for application execution environment. Reason code = "21" | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.1 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5.5.1 or higher * **************************************************************** | |
Comment | |
Upgrade to Db2 11.5.5.1 or higher | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.10.2020 06.04.2021 06.04.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |