Portable SQL (was Re: SQL UDF not found MADNESS)

Chuck,

The V5R4 SQL Reference Manual SQL Syntax Diagram for Cast and Dec require the comma. Is the comma optional or interpreted differently with internationalization? If I'm going to write portable SQL code how best to write it for i18n?

Thanks,
Paul Morgan

Principal Programmer Analyst
IT Supply Chain/Replenishment

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Thursday, August 04, 2011 9:10 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL UDF not found MADNESS

On 04-Aug-2011 12:44 , Charles Wilt wrote:

Note also the space included after the comma so the syntax remains
valid where decimal separator is comma. Including the blank space after
the comma increases the portability of the SQL; e.g. someone in Spain
could copy\paste the above statement snippet without then also having to
add the missing spaces to the quoted snippet, in order to make the SQL
functional. However for the special case of no scale, per zero
specified on each scale provided, then even better to just drop both the
comma and the scale specification entirely, irrespective of the means
utilized to effect the casting to decimal; e.g. showing both forms of
casting with zero-scale defaulted:

select TRUEDATE( dec(fldCC, 2) /* scale defaults to zero */
, cast(fldYY as dec(2)) /* scale defaults to zero */
, ...

Regards, Chuck