My experience with DB2 on AS/400 is VERY limited - a few days 10 years
ago! - so please forgive me if this response makes no sense or is way out of
date!

Am I correct in remembering that QRY/400 is the AS/400 equivalent of QMF in
OS/390? I really don't recall but, if it is, and if it closely mirrors QMF
on OS/390, it's pretty easy to list all of the queries by name. You probably
even have a PF Key that lists all queries or that brings up a search screen
where you can specify the type of object you want - form, table, query,
etc. - and specify a pattern for the names. If such a screen exists in
QRY/400, you'll simply have to choose Query as your object type and specify
SC_ as the pattern for the query name.

You haven't specified with version of DB2 for AS/400 your are using but
there should be an Information Center for it on the IBM site, www.ibm.com,
somewhere. If you search on AS/400 Information Center you should find it
eventually. That Information Center should contain full documentation for
QRY/400. (Or just search on QRY/400 and then make sure you look for only the
version of the manual that reflects your sofware.) The documentation should
take you through the techniques you'll need and even have screen shots of
the screens you'll encounter.

I saw a documentary once where a scientist at MIT claimed they had a working
time machine (or maybe it was a Star Trek style transporter) but that it was
down for repairs at the moment that the documentary crew was there. He was
winking though so I think you may need to wait another few decades before
that technology becomes available. :-)

--
Rhino