In this video, I'd like to show you an example of how to access to tables (flat or keyed tables), using SQL and the record number.
I show you an example of a SELECT, an UPDATE, and a DELETE, and also, I show you a simple RPG program.
Please, let me know what you think about it. Leave your comments below.
Don't forget to subscribe!
#ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #sqltraining #as400 #common #modernize #sql #ibmchampion
0:00 Introduction
0:34 Showing the table that I'm going to use for the example, from within VSCode
1:40 How to retrieve the RRN of every row using SQL
2:35 Updating data in a table using the RRN and SQL
3:49 Deleting data from a table using the RRN and SQL
4:29 Using RRN in a RPG program (example)
6:53 Running the program on the green screen
7:29 Final comments and ending
Download
0 formats
No download links available.
Coding in RPG (IBM i/AS400). Accessing tables using SQL and record number | NatokHD