Coding in RPG (IBM i/AS400). Converting Physical Files to SQL Tables.

In this example video, I'd like to show you how a physical file with data, can be converted to a SQL table without writing any code, and the programs that uses that table will work in the same way without doing anything else.

Let's modernize our databases!

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 #as400 #common #modernize #modernizingDB2 #DB2 #SQL #convertingPhysicalFiles #bestperformance #databaseperformance

0:00 Introduction
0:48 Showing you the original DDS of the physical and logical files used in the example
1.33 Showing you the RPG program that I use in the example
2:10 Running the program with the physical and logical files
2:55 Converting the physical file into a SQL table without writing code
4:35 Running the program again with the SQL table and logical file, without doing any changes
5:00 The original logical file is treated as a view
5:46 Comments about converting PF and LF to SQL tables/indexes/views
6:58 Ending

[ManuelHMoreno]

Christian, Your explanation is very clear. thanks a lot

[mongliu]

What editing tool you use when you open your program?