Re: Boolean Values in IBM i SQL

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

DB2 LUW does have a Boolean data type. Maybe the parser is just getting
confused?

On Wed, Feb 28, 2018 at 1:58 PM, Mark Murphy <jmarkmurphy@xxxxxxxxx> wrote:

> 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