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

5580 pts.
Tags:
AS/400
i5
IBM iSeries
iseries v5r4
Physical File
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

Answer Wiki

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

QSYS2/SYSTABLES

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

I’ve downloaded 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.

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