×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
The RTVQMQRY method has been around a long time. My only point was to offer an alternate method to the previous message I posted with Simon Hutchinson's SQL method of retrieving the DSPDBR command via WRKQRY and a conversion.
https://www.rpgpgm.com/2019/10/getting-database-relationships-using-sql.html
Agreed it's not the way to learn SQL. I don't think I said anything about learning SQL that way.
Very Respectfully,
Michael Mayer
IBM i Support / System Admin.
IT Operations.
The Florida Bar
651 E. Jefferson St
Tallahassee, Florida 32399-2300
mmayer@xxxxxxxxxxxxxx
https://www.floridabar.org
Office: 850.561.5761
Cell: 518.641.8906
2. RTVQMQRY WAS: DSPDBR via SQL view (Rob Berendt)
message: 2
date: Tue, 9 Jun 2020 15:31:32 +0000
from: Rob Berendt <rob@xxxxxxxxx>
subject: RTVQMQRY WAS: DSPDBR via SQL view
Decades ago I had a magazine article published on this process. However trying to learn SQL from doing RTVQMRQY is a rotten way to learn SQL. If you're going to use newer IBM i Services there are many examples out there with simple statements. And, since you mentioned ACS Run SQL Scripts the newer the version of ACS the more examples are included with that.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
________________________________
Please note: Florida has very broad public records laws. Many written communications to or from The Florida Bar regarding Bar business may be considered public records, which must be made available to anyone upon request. Your e-mail communications may therefore be subject to public disclosure.
midrange.com
