Re: Weird SQL Problem

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Thanks Sue.


Jon

> On May 4, 2026, at 13:34, Sue Romano <slromano@xxxxxxxxxx> 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: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.