Unicode remediation......

[Former Member]

In the SELECTs tatement below i am getting an error as :-

"SRTFDLOW" and "SRTFD" are not mutually convertible in a Unicode program.

SELECT client

relid

srtfd

srtf2

histo

aedtm

uname

pgmid

versn

clustr INTO

(pcl4-client,

pcl4-relid,

pcl4-srtfd,

pcl4-srtf2,

pcl4-histo,

pcl4-aedtm,

pcl4-uname,

pcl4-pgmid,

pcl4-versn,

pcl4-clustr)

FROM pcl4 WHERE relid EQ relid

===> AND srtfd Between srtfdlow and srtfdhigh <=======

AND srtf2 EQ '00'

AND aedtm IN datum

AND uname IN uname.

Please suggest me any remedy.....

[former_member188827]

wat is the data type of strfdlow and strfd.

write how u have declared dem...

[Former Member]

Hi,

The data type of those variable are not same

i think u r trying to assign currency value to char variable.

Plz chek the type of those two variables.

reward points if it is helpful.

Regards,

Satish