Re: Weird SQL Problem

Sue Romano <slromano-r/[email protected]> Mon, 4 May 2026 17:34:05 +0000

Newsgroups	gmane.comp.lang.as400.rpg
Message-ID	<CO1PR15MB497266D1B5ED548ECF812301F4312@CO1PR15MB4972.namprd15.prod.outlook.com>

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.