Below is a link to download a free e-book to help current, or former, RPG
programmers learn SET based SQL. There are significant benefits when using
SQL for I/O, but the benefits increase dramatically when you use SET based
SQL (versus one row at a time processing). This is a learn by example book
with many of the commonly used RPG input operation code combinations, with
their SET based SQL equivalents.
If you're using SQL to simply mimic RPG's input operation codes by reading
one physical row at a time, you're not leveraging the best aspects of SQL.
If you've not mastered SET based SQL, you've not mastered SQL. SET based
SQL provides dramatic run time improvements, a large reduction in code
volume, improved simplicity, and a greatly reduced chance for defects.
Prior to reading this book, you need to already have a basic understanding
of SQL SELECT queries, in particular the SELECT, FROM, JOIN, WHERE, and
ORDER BY clauses. There are numerous online, free training resources
available to you to gain that basic understanding.
This book will provide a solid introduction to SET based SQL for the RPG
programmer. It is not intended to make you an expert, but it should help
you to make good progress thinking, designing, and coding in SETs.
For someone with highly advanced skills in SQL and SET based processing,
this book probably does not have much to offer, since it is intended an
introduction. However, if you are not using LATERAL joins, this book has
something for you. For advanced readers, the book has one complex SET based
example #28, that may keep you entertained if the other examples bore you.
This is a PDF book best read in Adobe Reader.
Download link: Converting RPG to Set Based SQL (Part 1: Input Operations)
<
https://drive.google.com/file/d/0B86kLoHq8E_PeVlhNmZORmpBUjA/view?usp=sharing>
Enjoy !
Mike
midrange.com
