Re: Boolean Values in IBM i SQL

Nothing listed in the SQL reference.

On Wed, Feb 28, 2018 at 11:49 AM, <dlclark@xxxxxxxxxxxxxxxx> wrote:

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