filmov
tv
Coding in RPG (IBM i/AS400). Using SQL Objects with Native RPG file operations.
Показать описание
Maybe you haven't made the leap to using SQL in your programming yet, but you should already be creating your tables and other objects using SQL, for many reasons. They are better. It is a fact.
Sometimes we don't want to take the leap because we think our old RPG programs can't use SQL objects, and that's not the case.
I show you an example of a program that reads objects created in SQL, using native RPG disk operations.
Additionally, I show you how easy it is to convert old DDS logical files to indexes with the Where clause (in case they can be converted), instead of converting them to views.
Hope you like!
Enjoy!
#ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #sqlrpgle #sqltraining #as400 #common #modernize #IBMChampion
0:00 Introduction
0:44 Let's start with the DDS of the physical and the first logical file
1:30 Checking the data stores in those files using SQL
2:01 The second logical file, with a selection
3:20 Converting the selection logical file into an INDEX with a WHERE clause
7:46 An RPG program using SQL tables and indexes, using native disk operations
9:26 Checking how it works on the green screen
11:11 Final comments and ending
Sometimes we don't want to take the leap because we think our old RPG programs can't use SQL objects, and that's not the case.
I show you an example of a program that reads objects created in SQL, using native RPG disk operations.
Additionally, I show you how easy it is to convert old DDS logical files to indexes with the Where clause (in case they can be converted), instead of converting them to views.
Hope you like!
Enjoy!
#ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #sqlrpgle #sqltraining #as400 #common #modernize #IBMChampion
0:00 Introduction
0:44 Let's start with the DDS of the physical and the first logical file
1:30 Checking the data stores in those files using SQL
2:01 The second logical file, with a selection
3:20 Converting the selection logical file into an INDEX with a WHERE clause
7:46 An RPG program using SQL tables and indexes, using native disk operations
9:26 Checking how it works on the green screen
11:11 Final comments and ending
0:08:33
Coding in RPG (IBM i/AS400). Improving a process with activation groups.
0:09:16
Coding in RPG (IBM i/AS400). How to use Regular Expressions in RPG.
0:07:17
Coding in RPG (IBM i/AS400). Using WHEN-IS and WHEN-IN
0:14:41
Coding in RPG (IBM i/AS400). How to use SQL Data Sets in RPG.
0:03:36
Coding in RPG (IBM i/AS400). Using the option *convert.
0:25:06
Coding in RPG (IBM i/AS400). How to get information from the columns of a file
0:17:15
Coding in RPG (IBM i/AS400). Converting file operations in RPG to embedded SQL operations in RPG.
0:06:13
Coding in RPG (IBM i/AS400). Comparing occurs with other structures
0:12:37
Coding in RPG (IBM i/AS400). Using SQL to look for jobs information.
0:11:28
Coding in RPG (IBM i/AS400). Using SQL to look for object locks.
0:13:55
IBM i, AS400 Tutorial, iSeries, System i - Introduction to RPG programming for Beginners_ENGLISH
0:11:57
Coding in RPG (IBM i/AS400). Using SQL Objects with Native RPG file operations.
0:12:07
Coding in RPG (IBM i/AS400). Using SQL history tables.
0:07:22
Coding in RPG (IBM i/AS400). Templates.
0:13:22
Coding in RPG (IBM i/AS400). Creating a service program.
0:09:06
Coding in RPG (IBM i/AS400). RPG & VScode & make, adding a display file
0:07:07
Coding in RPG (IBM i/AS400). Using ON EXIT.
0:09:05
Coding in RPG (IBM i/AS400). Using data queues.
0:11:44
Coding in RPG (IBM i/AS400). RPG programs with logic cycle vs RPG programs without logic cycle
0:14:36
Coding in RPG (IBM i/AS400). Using pointers.
0:07:06
Coding in RPG (IBM i/AS400). New RPG functions: using EXPROPTS.
0:07:09
Coding in RPG (IBM i/AS400). Converting Physical Files to SQL Tables.
0:14:36
Coding in RPG (IBM i/AS400). Using %RIGHT and %LEFT
0:13:54
Coding in RPG (IBM i/AS400). Activation Groups.
Комментарии