> From: email@example.com > > 2) Joe, There is no such thing as a one line OPNQRYF. You need > the OVRDBF > and the rest of the kludge. New people find SQL easy to use. OPNQRYF's > crud about FILE vs. FORMAT, and which one do you declare in your RPG > program is for people who need a testosterone rush, and this does it for > them. You're right, sort of. OPNQRYF requires an OVRDBF. Dunno what else you're referring to. As to file vs. format, I've never had a problem figuring it out. Guess I read the manual at the beginning and it stuck with me ever since. You're opinion about new people finding SQL easy to use is just that, by the way, and isn't supported by the facts. Check the forums and see how many questions people ask about how to get SQL to work as opposed to how many questions are asked about logical files or even OPNQRYF over the years. You'll find that for many people, SQL is confusing and difficult to understand, the rules seemingly arbitrary, the syntax obscure. Once you get past a simple SELECT or UPDATE, and have to start dealing with subselects and outer joins, many people get lost. Far more people than get lost chaining to a logical file. > 3) I think Alexei's solution was the most simple and straight forward. Which solution? The poor performing SQL or the open/close cursor, which basically mimics RPG, only doesn't perform as well? It's people who insist on coding SQL FETCH loops really make me wonder. RPG is designed for this sort of processing; why add the overhead and obscurity of SQL syntax? Once you start using a cursor, the only real difference between SQL and native I/O, when it comes down to it, is that with SQL you don't have to figure out your database paths ahead of time. And in many situations you can address that with OPNQRYF. Anyway, I'm not going to convince anyone who thinks a cursor fetch beats a READE loop or a primary file read. If you think SQL is a better answer than RPG, then you have a completely different worldview than me anyway.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.