I think for syntax correctness with IBM i DB2 I would use ACS RSS (at least at 1.1.7.3) numeric colors purple in italic where Boolean looks just like a normal identifier. True and false both color to blue.
All the SQL editors I have in RDi do not color Boolean the same as it does for numeric or other datatypes. I wonder which "RSE Editor" you are using because I don't have one of those.
-Matt
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of dlclark@xxxxxxxxxxxxxxxx
Sent: Wednesday, February 28, 2018 9:49 AM
To: Midrange-L <midrange-l@xxxxxxxxxxxx>
Subject: Boolean Values in IBM i SQL
How do you declare and use a Boolean value in an SQL Stored Procedure on the IBM i? I've searched the online references and can't find anything about it. There is even a page showing the SQL equivalent data type for ILE RPG data types but the RPG IND data type is omitted from that page.
Without testifying that they do what I expect (yet), I've at least found that SQL doesn't complain about the following statements in a stored
procedure:
SET variable = True;
SET variable = False;
And though I found that it won't let me use the first statement syntax, below, at least it doesn't complain about the second.
If CursorOpen Then ...
If CursorOpen = True Then ...
However, it won't let me use data type Boolean or Default False in a variable declaration statement (yet). But the RSE editor does show the words Boolean and False in blue -- indicating it thinks they are part of the SQL syntax.
Declare CursorOpen Boolean Default False;
Anyone know how to define a Boolean variable in an IBM i SQL Stored Procedure? Thanks.
Sincerely,
Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300
Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331
*********************************************************************************************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or proprietary information. If you have received this message in error, please immediately notify the sender and delete and destroy the message and all copies. All unauthorized direct or indirect use or disclosure of this message is strictly prohibited. No right to confidentiality or privilege is waived or lost by any error in transmission.
*********************************************************************************************
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=RyZcdjeo9C1jp8VR0Rnngj7D0SB2DZNclwA5fsGaFD4&s=MeNZr1tU9R_mZTSC8u_T1O3gqzfayH4GgxcJRlyo0is&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=RyZcdjeo9C1jp8VR0Rnngj7D0SB2DZNclwA5fsGaFD4&s=2N32HaqOKE5cMMqVuR-d2GYiGXv7Xp1lpP0NPi1I74c&e=.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=RyZcdjeo9C1jp8VR0Rnngj7D0SB2DZNclwA5fsGaFD4&s=3hNg_jg5eLLY7lN8te5nJ7GvMYzgEw0Tnmaqh6ODzwA&e=
midrange.com
