RE: 7th bit of a field

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Me, too, Rob. It says 'logical' AND but is actually a 'bitwise' AND. Same 
confusion for LOR and LNOT.

Also, I just discovered these have been around since V3R7!

What a list!

Vern

At 02:56 PM 8/12/2004, you wrote:


> I just read the SQL reference manual and still don't understand land at
> all.
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
> |-----------------------------+-------------------------------------------|
> |   CWilt@xxxxxxxxxxxx        |                                           |
> |   Sent by:                  |                                           |
> |   midrange-l-bounces@midrang|                                         To|
> |   e.com                     |    midrange-l@xxxxxxxxxxxx                |
> |                             |                                         cc|
> |   08/12/2004 02:25 PM       |                                           |
> |                             |                                     Fax to|
> |         Please respond to   |                                           |
> |         Midrange Systems    |                                    Subject|
> |       Technical Discussion  |    RE: 7th bit of a field                 |
> |      <midrange-l@xxxxxxxxxxx|                                           |
> |                m>           |                                           |
> |                             |                                           |
> |                             |                                           |
> |                             |                                           |
> |                             |                                           |
> |-----------------------------+-------------------------------------------|
>
>
>
>
>
>
> Depends on where you're doing the selection.
>
> Since you didn't post in the RPG-L list, how about some SQL.
>
> select * from YCSC1 where land(YSTAT1, x'40')
>
> HTH,
> Charles
>
>
> > -----Original Message-----
> > From: Muralidhar Narayana [mailto:Muralidhar_Narayana@xxxxxxxxxxx]
> > Sent: Thursday, August 12, 2004 3:08 PM
> > To: midrange-l@xxxxxxxxxxxx
> > Subject: 7th bit of a field
> >
> >
> > There is column oriented file YCSC1. One of the field  is
> > YSTAT1 which  is defined as
> >  Type Character  &  Length  1.
> > I need select records from this file YCSC1 when 7th bit of
> > YSTAT1 is "on" .
> > Can some one help me how to go about this and acheive records
> > for this selection.
> >
> >
> > --
> > 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
> --
> 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: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.