MVSFORUMS.com

pkrish_18 · Beginner Joined: 08 Apr 2005 Posts: 12 Topics: 7

Hi ,

Am running the following query,

SELECT *
FROM Qualifier.T1 SD,
Qualifier.T2 PA
WHERE PA.PICK_CAND_ORD_HDR = SD.FK_SALES_ORDER_NUM
AND INTEGER(PA.PICK_CAND_ORD_LINE) =
SD.FK_SALES_ITEM_RAN
WITH UR;

It errors out with SQLCODE = -686.

Note that Column definitions for PA.PICK_CAND_ORD_LINE and SD.FK_SALES_ITEM_RAN are CHAR's.

My objective is to use the integer value of PA.PICK_CAND_ORD_LINE to compare with SD.FK_SALES_ITEM_RAN(which is a char column).

Can anyone provide me a solution.

Thanks,

PK

dbzTHEdinosauer · Posted: Wed Feb 21, 2007 4:38 pm Post subject:

why not INTEGER the ...item_ran col?
_________________
Dick Brenholtz
American living in Varel, Germany

pkrish_18 · Beginner Joined: 08 Apr 2005 Posts: 12 Topics: 7

Am really sorry. Column defn for SD.FK_SALES_ITEM_RAN is INTEGER. And when we try to compare PA.PICK_CAND_ORD_LINE(which is defined as CHAR), it throughs an error. So the only choice is to compare by converting the Datatype of PA.PICK_CAND_ORD_LINE to INTEGER.

kolusu · Posted: Thu Feb 22, 2007 11:49 am Post subject:

dbzTHEdinosauer · Posted: Thu Feb 22, 2007 12:04 pm Post subject:

are you sure that your incompatibility is not in the other half of the where clause? or possibly, are there dec and not int?
suggest you run the query twice, each time only using half of the where clause.
_________________
Dick Brenholtz
American living in Varel, Germany