Re: Weird SQL Problem

Thanks Sue.


Jon

> On May 4, 2026, at 13:34, Sue Romano <slromano-r/[email protected]> wrote:
> 
> We hear you and are discussing the problem and solutions.
> 
> 
> 
>> I understand that - and I really think they should have defined the conversion rules from the start on BOOLEAN
> 
>> 
> 
>> true / *on
> 
>> - for numeric = 1
> 
>> - for CHAR(1) = '1'
> 
>> - for CHAR(>1) = 'TRUE'
> 
>> 
> 
>> false / *off
> 
>> - for numeric = 0
> 
>> - for CHAR(1) = '0'
> 
>> - for CHAR(>1) = 'FALSE'
> 
>> 
> 
>> That would have solved the problem in the first place - would be fully compatible with the conversion from numeric/char to BOOLEAN - and backwards compatible.
> 
>> 
> 
>> But the pre-compiler team has not always been in-line with everything "IBM i" ...
> 
>> 
> 
>> Jon, have you heard something back from your support case? Do you think it would help, if more people open a case?
> 
>> 
> 
>> Regards,
> 
>> Daniel
> 
> Sue Romano
> Db2 for IBM i development
> 
> -- 
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
> 
> Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.
> 

-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.