Re: Build a logical using a partial key and select certain records

Hi Pat
I think this is what you are looking for - SST

A R CALNDARR PFILE(CALENDAR)
A CALNDATE
A CALNDTMM 2 I SST(CALNDATE 1 2)
A CALNDTDD 2 I SST(CALNDATE 3 2)
A CALNDTYY 2 I SST(CALNDATE 5 2)
A CALNTELUPD
A CALNSBMDT
A CALNSBMTM
A K CALNDTYY
A K CALNDTMM
A K CALNDTDD



Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill



Pat Barber
<mboceanside@att.
net> To
Sent by: Midrange Systems Technical
midrange-l-bounce Discussion
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc

03/19/2010 01:33 Subject
PM Build a logical using a partial key
and select certain records

Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>






I have done this in the past, but I can't find my example.

I want to create a logical using a portion of a field and
I want to be able to select or omit on that partial field.


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