DSXchange

Hi ,

I am getting error in while saving the data rule definition, the problem is on joining, the key columns of two tables are different, so while joining in IA, throwing error on joining,

just another way i want solution in IA of below query.

select * from xxx A inner join yyy B
ON CAST( A.ZON_CODE as DECIMAL)) = B.ZON_CODE


please provide solution , waiting for reply.

What have you tried?
Or are you just waiting?

I am not able to find the solution at IA, so just waiting for solution.

Thansk!

Hi,

Have you looked at the TOSTRING or VAL functions?

Hi,

In the data rule , join key tab (selecting as a key field in the join) there is no option to modify datatype of the field.

The doubt is, how to change data type in the joining condition, as we can do to db2 like CAST( A.ZON_CODE as DECIMAL)) = B.ZON_CODE

Thanks//

Create a virtual column on the table, and use that in your join.

Thanks ray