Create and Test an IBM i SQL Stored Procedure
Today, we're tackling something super useful for developers working with DB2 on IBM i: how to create a basic SQL stored procedure. If you're new to stored procedures or just want a straightforward step-by-step guide, this video is for you. We'll cover the essentials from defining your procedure, adding parameters, writing the SQL logic, and executing it all using native IBM i tools like ACS or STRSQL.
https://www.nicklitten.com/course/vid...
---
Hey there, IBM i programmers! Welcome to my channel where I try to cover AS400, iSERIES and IBM-i topics like programming, code refactoring, modernization, and technical things like OS updates, RPG subfiles or SQL stored procedures. All on the IBM i system, focusing on practical steps to improve your development work.
You will find tips on modernization, GIT integration for source control, and tools like Project Bob for refactoring legacy code.
This content is designed for beginners learning iSeries basics or experienced developers optimizing Power Systems performance.
For more IBM i resources, visit https://nicklitten.com, where you can access tutorials, code snippets, and free materials to enhance your programming skills. Download the source code from my public github repository https://github.com/NickLitten/nick.li...
Enjoyed the video? Buy me a beer and fuel more nerdy goodness!
https://www.nicklitten.com/shop/buy-m...
#IBMi #AS400 #IBM-i #PowerSystems #RPGLE #CLProgramming #SQLonIBMi