|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.