Re: 7th bit of a field

[rob@xxxxxxxxx]

I'd suggest using a UDF.

For a sample of a UDF see:
http://faq.midrange.com/data/cache/185.html

Then you could do
Select * from myfile
When MyUdf(YSTAT1)='1'

I checked the SQL reference and there doesn't seem to be a whole lot of bit
picking operations.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com


|-----------------------------+-------------------------------------------|
|   "Muralidhar Narayana"     |                                           |
|   <Muralidhar_Narayana@infos|                                           |
|   ys.com>                   |                                         To|
|   Sent by:                  |                                     <midra|
|   midrange-l-bounces@midrang|                                     nge-l@|
|   e.com                     |                                     midran|
|                             |                                     ge.com|
|   08/12/2004 02:07 PM       |                                     >     |
|                             |                                         cc|
|         Please respond to   |                                           |
|         Midrange Systems    |                                     Fax to|
|       Technical Discussion  |                                           |
|      <midrange-l@xxxxxxxxxxx|                                    Subject|
|                m>           |                                     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.