db2 报错 信息
SQL 错误 [42911]: A decimal divide operation is not valid because the result would have a negative scale.. SQLCODE=-419, SQLSTATE=42911, DRIVER=4.16.53
A decimal divide operation is not valid because the result would have a negative scale.. SQLCODE=-419, SQLSTATE=42911, DRIVER=4.16.53
A decimal divide operation is not valid because the result would have a negative scale.. SQLCODE=-419, SQLSTATE=42911, DRIVER=4.16.53
An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-419", SQLSTATE "42911" and message tokens "42911".. SQLCODE=-727, SQLSTATE=56098, DRIVER=4.16.53
错误代码:SQLCODE=-419 十进制除法运算无效
select a.ywl,rs.rs from temp a;
然后执行的语句:select a.ywl/rs.rs from temp a 就会报以上的错误
通过各种博客记录,提出报错信息的博客很多,但解决问题不太好找,再找到 参考解决办法原博客 得以解决;
解决语句1: select a.ywl/dec(rs.rs,25,2) from temp a,即可进行解决
然后dec着实没有见过,与decimal看起来像,类似,于是使用 cast(rs.rs as decimal(25,2))替代dec(rs.rs,25,2) ,发现也可以解决
解决语句2:select a.ywl/cast(rs.rs as decimal(25,2)) from temp a
发现解决方法着实难找,记录以下,以便日后查询。