topic Re: Unicode remediation...... in Application Development and Automation Discussions

Unicode remediation......

Former Member — Fri, 17 Aug 2007 10:43:27 GMT

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 — Fri, 17 Aug 2007 10:51:42 GMT

wat is the data type of strfdlow and strfd.

write how u have declared dem...

Former Member — Fri, 17 Aug 2007 11:03:14 GMT

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