Database member Cross reference in Qsys? – Where’s it hidden?

5,520 pts.
Tags:
AS/400
i5
iSeries
Physical Files
V5R4
A number of useful objects are in Qsys these days. Items like QADBIFLD are very useful when you want a system wide search for a field.

I've been looking for the equivalent for file members.

Specifically, I want to search for all occurrences of a given file member name across the system's many libraries/files.

Can't find a file that gives that information - Anyone know if a) there is one and b) what its name is? Thanks



Software/Hardware used:
i5 v5r4
ASKED: October 8, 2009  10:39 AM
UPDATED: October 8, 2009  7:06 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

QSYS2/SYSTABLES

////////////

I’ve dowlnoaded an utility named FINDMBR that do exactly what do you want to (and more). I can’t find the origin but basically it do a query over file QADBXREF and select all records with DBXTYP = ‘S’ (source files) and for each record uses QUSRMBRD to verify/retrieve Member text. This utility makes a SFL and let you do some actions over members found like copy, view, edit, etc. It’s VERY useful.

I found the original .zip with all the code and put it on our web server. You can download it from

<a href=”http://www.wminformatica.com/PDFS/find_source.zip”>http://www.wminformatica.com/PDFS/find_source.zip</a>

Regards,
Wislon

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dasi4jpm
    I cannot find a column in this table (QSYS2/SYSTABLES) that shows the member name for all members in the file.
    85 pointsBadges:
    report
  • Littlepd
    The SYS* physical files in the QSYS2 library are, basically, the catalog for the database that the system uses to track other database objects. Members are not a type of object that a database catalog knows about, so I doubt you would be able to find anything about members in those files. But I've been wrong before (once or twice ;)
    1,130 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following