Coding in RPG (IBM i/AS400). Converting Logical Files to SQL Indexes or Views
In this example video, I'd like to show you how a logical file, can be converted to a SQL index or view, depending on the case.
In some cases, while converting logical files into indexes, we will have no need to write any code, and the programs that uses that logical file will work in the same way without doing anything else. In other cases, we will have to make changes in our programs.
Let's modernize our databases and programs!
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 #convertingLogicalFiles #bestperformance #databaseperformance #SQLindexes #SQLviews
0:00 Introduction
0:26 The physical and logical files that we will use in the example
0:45 The original DDS of the logical files
1:27 The program that we use in the example
2:17 Running the program (first run)
3:58 Doing an SQL SELECT on the first logical file
4:27 Converting the first logical file into an SQL index
6:48 Doing an SQL SELECT on the converted logical file (the SQL index)
7:44 Converting the second logical file into an SQL index
8:53 Converting the third logical file into an SQL view (why not an index?)
9:36 Running the program (second run)
10:40 Problems that we can have converting the logical file into a view
10:53 Running the program (third run)
11:45 Fixing the problem caused by converting the logical file into a view
12:10 Running the program (fourth run)
12:19 Final comments and ending