×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Cool. That should work. Thanks Scott
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Thursday, May 22, 2008 2:21 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: How to use SQL to select data by binary pattern
select * from myfile where land(lw9,x'0000001f')=x'00000013'
The LAND() scalar function performs a logical on the field. So with a
bitmask of x'1f' (which is 11111 binary) the LAND will return only the
rightmost 5 bits of the lw9 field. If those bits are set to
x'00000013' (binary 10011) then you know the rightmost bits of the field
are 10011.
HTH
Lim Hock-Chai wrote:
If the DDS of myFile is as below:
A R RECDHDR
A LW9 4H
Is there a way to query this file where the last 5 bits of LW9 binary
pattern is = 10011?
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
