Home > IT Answers > AS/400 > Database member Cross reference in Qsys? - W...
Yorkshireman
3210 pts.
Q:
Database member Cross reference in Qsys? - Where's it hidden?
AS/400, iSeries, i5, 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: Oct 8 2009  10:39 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
WilsonAlano
2035 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
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

http://www.wminformatica.com/PDFS/find_source.zip

Regards,
Wislon
Last Answered: Oct 8 2009  7:06 PM GMT by WilsonAlano   2035 pts.
Latest Contributors: Littlepd   720 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Dasi4jpm   10 pts.  |   Oct 8 2009  2:10PM GMT

I cannot find a column in this table (QSYS2/SYSTABLES) that shows the member name for all members in the file.

 

Littlepd   720 pts.  |   Oct 8 2009  4:12PM GMT

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 ;)