Strange problem with SQL function -- MIDRANGE-L

Subject: Strange problem with SQL function
From: Tomasz Skorża <t.skorza@xxxxxxxxxxx>
Date: Wed, 23 Nov 2011 11:25:06 +0100
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

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

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

RE: Strange problem with SQL function , Monnier, Gary
Re: Strange problem with SQL function , rob
Re: Strange problem with SQL function , rob

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.