Back to Browse

Coding in RPG (IBM i/AS400). Accessing tables using SQL and record number

1.7K views
Mar 17, 2024
8:06

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