RE: Strange problem with SQL function

Tomask,

Is the external reporting software running under the same CCSID/Code Page as your interactive job? You may have to grab the job's CCSID at run time to determine what to convert from.

Gary

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tomasz Skorza
Sent: Wednesday, November 23, 2011 2:25 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Strange problem with SQL function

Hi

I created a SQL function which retrive customer name based on his
number. Because our names has special polish characters I also
implemented a conversion from polish chars to latin using %XLATE.

When I called this function in interactive SQL session on AS400 - all is
correct - means I get customer name with converted polisch chars to latin.

But when I try to call it inside some external reporting software it get
me a name looks like conversion didn't occured.

What is wrong? When I talked with producer of software and they assumed
that problem is with SQL function, but how if on AS400 it get right
converted name?

Regards

Tomek