how to change datatype in the joining field in the IA

Gaurav1 · Post by **Gaurav1** » Mon Jan 20, 2014 6:14 am

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.

stuartjvnorton · Post by **stuartjvnorton** » Mon Jan 20, 2014 6:49 am

What have you tried?
Or are you just waiting?

Gaurav1 · Post by **Gaurav1** » Mon Jan 20, 2014 7:15 am

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

Thansk!

rjdickson · Post by **rjdickson** » Mon Jan 20, 2014 9:46 am

Hi,

Have you looked at the TOSTRING or VAL functions?

Gaurav1 · Post by **Gaurav1** » Tue Jan 21, 2014 12:23 am

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//

ray.wurlod · Post by **ray.wurlod** » Tue Jan 21, 2014 1:58 am

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

Gaurav1 · Post by **Gaurav1** » Tue Jan 21, 2014 3:43 am

Thanks ray