One of my SQL is failing with the below error.I tried using cast function also.But it is not working.here the coli1,col2,col3 are CHAR fileds and the id is DECIMAL(38,0).
Can any one help me to resolve this.
*** Failure 2616 Numeric overflow occurred during computation.
Statement# 1, Info =0
*** Total elapsed time was 17 seconds.
INSERT INTO tableA
WITH RECURSIVE recursive_tbl
( col 1,
( SELECT Table B
FROM Table c
r.recurselevel + 1,
FROM recursive_tbl AS r