RE: 7th bit of a field

[CWilt@xxxxxxxxxxxx]

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.
>