RE: Search OS/400 Physical Files

----- Original Message -----
From: "Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Subject: RE: Search OS/400 Physical Files
Date: Thu, 10 Jul 2008 14:41:36 -0500


Sure, I could write this. I just didn't want to have to do that for this
one shot search I wanted to run. I was hoping there might be a solution
already out there.

So far I think the RSE find string (which is nothing more than FNDSTRPDM) is
probably the best solution for what I need because I can search an entire
library at once. It's just super slow for me because it's a slow connection
to the server and there are a lot of files to search. I'll probably end up
doing that anyway.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Walter
Sent: Thursday, July 10, 2008 2:32 PM
To: Midrange Systems Technical Discussion
Subject: RE: Search OS/400 Physical Files

Could you roll your own using the combination of Systables and Syscolumns?
I've done stuff like that in SQL Server Windoze programs to dynamically
create SQL Update statements on the fly.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Shannon ODonnell
Sent: Thursday, July 10, 2008 3:10 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Search OS/400 Physical Files

Yup

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Odom
Sent: Thursday, July 10, 2008 1:37 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Search OS/400 Physical Files

Vern, et al,

I think what Shannon is looking for and I for sure am, is a native i5/OS
Search function that allows me to put in a character string or whatever and
*ALL libraries, if I so desire, and have it search ALL files in all
libraries, particularly source or physical files and have it function like
the Search function in Windoz. I have entered STRPDM, I have pulled up a
list of objects from all libraries, I have put in 25 in the option field of
the first on the list (shouldn't have to do this if I want to search all
objects in one or more libraries in the first place) and I pressed enter. I
get "Option 25 not valid". So, I then tried WRKF. I say all files, all
libs, PF. I get a list. I put in 25 in the option field of the first
file, I get "Specified option number not allowed". I have *ALLOBJ and am a
SECADM. So, I don't see ANYTHING that allows me to do a Windoz like search
on all objects for a character string or anything like it. What am I
missing?

Thanks,

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


No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.4.7/1544 - Release Date: 7/10/2008
7:37 AM
--
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.