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


  1.  Home
  2. WDSCI-L
  3. August 2020

Re: Search for date line of code changed

Here's a bit of ancient RPG code that might spark an idea

fqrpglesrc ip f 112 disk infds(infds)
fqsysprt o f 132 printer oflind(*inof)

dINFDS ds
d FILE_NAME 83 92
d LIBRARY 93 102
d MEMBER 129 138

iqrpglesrc aa 01
i 1 6 2srcseq
i 7 12 0srcdat
i 13 112 srcdta

RPG will read every member in QRPGLESRC if you do

ovrdbf qrpglesrc mbr(*all)

You can put whatever calculations you'd like in the RPG, and then you
can print out the library, file, member, and line of code that meets
your criteria.
If the mood strikes you, create a new table with lib, file, mbr,
srcseq, srcdat, srcdta, run this RPG code and build a queryable
'all-in-one' table instead of having to fight through individual
members. (You might find that the initial criteria weren't quite the
ones you needed).

Alas, SQL does not care much for MBR(*ALL) in an ovrdbf; that would be
much easier.
CPYF does not work with MBR(*ALL) either.

--buck

On Tue, 4 Aug 2020 at 13:37, K Crawford <kscx3ksc@xxxxxxxxx> wrote:

If I am following that correctly, you will get a list based on the Last
Modified date. Yes, I can do that.

What I am really looking for is something like this. Open the 'iSphere
Source File Search' as normal. (I think most of us know that a source file
has 3 columns SrcSeq, SrcDat, SrcDta). Then be able to somewhere on that
screen say search by SrcDat not SrcDta. Then put in a date or date range.
Then get a list of all of the members that meet that criteria. Just like
we get now.
I guess being able to combine the Data and Date search might be useful
sometimes.

By the way I could not do my job without iSphere. Great product.

Kerwin

On Tue, Aug 4, 2020 at 11:16 AM Steve Ferrell via WDSCI-L <
wdsci-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi Kerwin,

On 9.6.0.2 and beyond, the Object Table view in RDi allows the user to use
quick filters. Then if you change the settings to include the Last Modified
date (use the down facing triangle to change column settings), you can
order the list by Last Modified. Just leave the Member and File as *. You
can select to view ALL columns, or make a custom list of columns for your
table view. (If you do the later, just be aware there are two flavors.
Object and Member. Select the Member view, and then don't forget to go back
and select the "Show Columns" -> "Customized to see your new list of
customized columns.

Quick filters that use Last modified or created dates do take longer to
query, so many users chose to keep those columns off. But they should come
in handy to see changes for a certain date/time.

HTH

Steve Ferrell
w. www.helpsystems.com



-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of K Crawford
Sent: Monday, August 3, 2020 3:38 PM
To: wdsci-l@xxxxxxxxxxxxxxxxxx
Subject: [WDSCI-L] Search for date line of code changed

External: Pause and review the sender's email address, any URLs before
clicking links, opening attachments, or following requests. When in doubt,
contact the Service Desk.


What I want to do is search all source in a library/filter for any line
that was changed in a date range.
I am looking for a list of source members.
I am open to RDi or SQL or...

We know the program was changed the first few days of the year. But do
not know exactly what program.

I know if that line has been changed after that it will have a later date,
that is okay.

--
Kerwin Crawford
--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/wdsci-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com



--
KCrawford
--
This is the Rational Developer for IBM i (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/wdsci-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.