.st0{fill:#FFFFFF;}

AS400 Modernization – Upgrading from RPG to SQL RPG for file access? 

 January 31, 2017

By  NickLitten

I’m not sure if upgrading is the right word, perhaps switching or converting or even “just learning a new technique” would be better?

AS400 Modernization

Modernizing legacy applications written on legacy computers like the AS400, or the older iSeries machines can seem like a daunting task

Either way, I didnt write this document but still found it a very enlightening read:

[pullquote align=”normal” cite=”somebloke”]

Free e-book: Converting RPG to Set Based SQL (Part 1: Input Operations)

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.

[/pullquote]

as400 modernization using SQL

DOWNLOAD Converting RPG to Set Based SQL – Part 1 – Input Operations

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.

NickLitten


IBM i Software Developer, Digital Dad, AS400 Anarchist, RPG Modernizer, Shameless Trekkie, Belligerent Nerd, Englishman Abroad and Passionate Eater of Cheese and Biscuits. Nick Litten Dot Com is a mixture of blog posts that can be sometimes serious, frequently playful and probably down-right pointless all in the space of a day. Enjoy your stay, feel free to comment and remember: If at first you don't succeed then skydiving probably isn't a hobby you should look into.

Nick Litten

related posts:

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
    __CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"cff50":{"name":"Main Accent","parent":-1},"a344d":{"name":"Accent Transparent","parent":"cff50"}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"cff50":{"val":"var(--tcb-skin-color-0)"},"a344d":{"val":"rgba(46, 138, 229, 0.85)","hsl_parent_dependency":{"h":210,"l":0.54,"s":0.78}}},"gradients":[]},"original":{"colors":{"cff50":{"val":"rgb(0, 178, 255)","hsl":{"h":198,"s":1,"l":0.5}},"a344d":{"val":"rgba(0, 178, 255, 0.85)","hsl_parent_dependency":{"h":198,"s":1,"l":0.5}}},"gradients":[]}}]}__CONFIG_colors_palette__

    Get In Touch

    Iā€™m always looking for awesome input, feedback and critique!

    >