Im trying to do a Left outer join sql query for 2 DB2 tables -through aqt editor. Join to happen between char and decimal fields.
皇冠hg0088代理网址For the where clause im providing ,the char and decimal fields always hold only 19 digits - no characters or decimals.
皇冠hg0088代理网址Tried cast function to convert char to decimal so join can happen b/w 2 decimal fields, also tried to cast both char and decimal to integer . Been getting errors like:
皇冠hg0088代理网址cursor is not in a prepared state,arithmetic overflow
皇冠hg0088代理网址other arithmetic exception occured.
It is quite a big query- Here is the line where the error occurs-
left outer join aTable on cast(aTable.charField AS Decimal(19,0)) = bTable.decimalField
皇冠hg0088代理网址bTable.decimalField is Decimal type with Length 19
aTable.charField is Char type with Length 30.