filmov
tv
Coding in RPG (IBM i/AS400). Using SQL history tables.
Показать описание
In this video I'd like to show you an example of how you can create and use history tables in SQL.
This is something that is very useful, for storing changes and deleted records, and is something that is automatically done by the database engine.
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 #SQL #temporaltables #ibmchampion
0:00 Introduction
0:45 Starting creating a table using Run SQL Scripts
1:26 Creating the history table
1:50 Adding both tables to be journalized
3:10 Using "ADD VERSIONING USE HISTORY TABLE"
3:48 Adding some records to the table
4:45 Talking about "implicitly hidden" fields
6:40 Updating a record in my table, and watching the history table
8:00 Deleting a record in my table, and watching the history table
8:56 Recovering deleted data from the history table and inserting it into the main table
10:44 Unlinking the history table with the main table, so I can drop them
11:34 Final comments and ending
This is something that is very useful, for storing changes and deleted records, and is something that is automatically done by the database engine.
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 #SQL #temporaltables #ibmchampion
0:00 Introduction
0:45 Starting creating a table using Run SQL Scripts
1:26 Creating the history table
1:50 Adding both tables to be journalized
3:10 Using "ADD VERSIONING USE HISTORY TABLE"
3:48 Adding some records to the table
4:45 Talking about "implicitly hidden" fields
6:40 Updating a record in my table, and watching the history table
8:00 Deleting a record in my table, and watching the history table
8:56 Recovering deleted data from the history table and inserting it into the main table
10:44 Unlinking the history table with the main table, so I can drop them
11:34 Final comments and ending
0:18:49
Coding in RPG (IBM i/AS400). Creating and using a VIEW.
0:12:38
Coding in RPG (IBM i/AS400). Using Deploy tool in VS Code/Code for IBM i
0:07:22
Coding in RPG (IBM i/AS400). Templates.
0:06:13
Coding in RPG (IBM i/AS400). Comparing occurs with other structures
0:17:15
Coding in RPG (IBM i/AS400). Converting file operations in RPG to embedded SQL operations in RPG.
0:11:28
Coding in RPG (IBM i/AS400). Using SQL to look for object locks.
0:03:36
Coding in RPG (IBM i/AS400). Using the option *convert.
0:13:55
IBM i, AS400 Tutorial, iSeries, System i - Introduction to RPG programming for Beginners_ENGLISH
0:12:37
Coding in RPG (IBM i/AS400). Using SQL to look for jobs information.
0:11:52
Coding in RPG (IBM i/AS400). Subroutines and subprocedures.
0:08:33
Coding in RPG (IBM i/AS400). Improving a process with activation groups.
0:14:23
Coding in RPG (IBM i/AS400). Using *nopass and *omit parameter options
0:14:36
Coding in RPG (IBM i/AS400). Using pointers.
0:13:22
Coding in RPG (IBM i/AS400). Creating a service program.
0:13:54
Coding in RPG (IBM i/AS400). Activation Groups.
0:07:17
Coding in RPG (IBM i/AS400). Using WHEN-IS and WHEN-IN
0:05:35
Coding in RPG (IBM i/AS400). Recursion in subprocedures.
0:12:26
Coding in RPG (IBM i/AS400). Creating IFS files using RPG and SQL
Coding in RPG (IBM i/AS400). Using SQL history tables.
0:07:07
Coding in RPG (IBM i/AS400). Using ON EXIT.
0:12:03
Coding in RPG (IBM i/AS400). Using CREATE FUNCTION and CREATE PROCEDURE
0:07:47
Coding in RPG (IBM i/AS400). Reading Data Areas using SQL.
0:09:06
Coding in RPG (IBM i/AS400). RPG & VScode & make, adding a display file
0:08:04
Coding in RPG (IBM i/AS400). When to create a SQL index.
Комментарии