Db2 for i SQL does not include an boolean data type.
In your example true and false are handled as character strings.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
dlclark@xxxxxxxxxxxxxxxx
Sent: Mittwoch, 28. Februar 2018 17:49
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://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
