One more example of problems which can raise from uneven DB2 software levels:
[list bull-blueball][*]tested in development/test system => works[/list][list bull-redball][*]execution in production => fails with SQLCODE -206[/list]
Reason: DB2 software maintenance applied on development/test system, but currently not on production system.
DB2 returns SQLCODE206 (or precompiler message DSNH4702I) for an UPDATE statement which contains multiple assignments in the SET assignment clause, and an assignment containing a scalar subquery with a JOIN is followed by an assignment in which the target column name is qualified with the correlation-name.Â Which is a fault. Â Â Â Â Â Â Â
RA10 PSY UK78352Â Â UP12/05/15 P F205
R910 PSY UK78353Â Â UP12/05/15 P F205