’SQLCODE=-419 十进制除法运算无效‘ 解决办法

  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

 

发现解决方法着实难找，记录以下，以便日后查询。