Cast problems (integer to varchar)

[Bastien]

I am trying to get the follwowing sql statement to work

select r.date_to_send, r.note, t.calling_id, t.task_subject, t.due_date, r.record_id, t.record_id from reminder r inner join task t on r.calling_id = cast(t.record_id as varchar(32)) where r.created_by = 'admin'

and I get the following error

[IBM][CLI Driver][DB2/NT] SQL0461N A value with data type "SYSIBM.INTEGER" cannot be CAST to type "SYSIBM.VARCHAR". SQLSTATE=42846

How to fix this? Is there an intermediate cast to char that I need to make first?

TIA



Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[Bastien]

fixed it with an intermediate cast

select r.date_to_send, r.note, t.calling_id, t.task_subject, t.due_date, r.record_id, t.record_id from reminder r inner join task t on r.calling_id = cast(cast(t.record_id as char) as varchar(32)) where r.created_by = 'admin'

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[blom0344]

Did you try:

select r.date_to_send, r.note, t.calling_id, t.task_subject, t.due_date, r.record_id, t.record_id from reminder r inner join task t on r.calling_id =
char(t.record_id) where r.created_by = 'admin'

Ties Blom
Information analyst