Christian Larsen’s Post

A new video, with a little more about XML files, RPG and SQL. Now, parsing an XML file with namespaces, attributes, duplicated tags... Enjoy! #ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #SQLtraining #XML #as400 #common #ibmchampion

Today I'd like to show an example of how to create a trigger using SQL. You will see that it is simpler than using RPG. Enjoy! #ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining  #as400 #common #sql #ibmchampion

Are you still creating your triggers using RPG? Did you know that it is very easy to do it directly using SQL? Here is a video where you can see how simple it is!! https://lnkd.in/dNFxzYST #IBMi #IBM #rpg #rpgle #rpgfree #ibmtraining #ibmcoding #rpgtraining #as400 #common #IBMChampion

In this video I'd like to show you two different things. First, we can continue using native disk operations in RPG, using SQL objects... (it doesn't have to be the best, but it can be done)... Also, I show you an example of how you can convert logical files with selection into SQL indexes with the WHERE clause, instead of views. They are faster and more efficient. I hope you like it! Enjoy! #ibmi #ibm #rpg #rpgle #rpgfree #ibmtraining #ibmcoding #rpgtraining #as400 #common #IBMChampion

In this video I show you an example of how to use a SCROLL CURSOR, and how you can reuse it between different program executions, in the same activation group. That means, less OPEN and CLOSE file operations! Enjoy! #ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining  #as400 #common #sql #sqlrpgle #ibmchampion

In this video, I'd like to show you an example of how you can easily use the SQL statements, CREATE FUNCTION and CREATE PROCEDURE, to call RPG procedures and functions that are inside a service program. Hope you like it! Enjoy! #ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #as400 #common #sql #sqlrpgle #sqltraining #ibmchampion

Today I want to show you an example of how to use LISTAGG, that is an SQL function, that can be used to aggregate a set of strings into one string by contatenating them. In the example, I use it to group different results into only one field. Enjoy! #ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining  #as400 #common #rpgsql #embeddedsql #sqlcoding #ibmchampion

There are people who have asked me about how to correctly use the opcode xml-into to import XML documents! I show you a small example of how to use it! Enjoy! #ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining  #as400 #common #xml #ibmchampion

Here's a weird discovery I had in 2023. I tried to learn many concepts by watching videos and taking notes Forgot about the concept in the Interview 😮 . At the end of December, I started doing a project Employee Leave Project. By doing project , I learned  →Creating Modules  →Debugging Program →Monmsg In RPGLE →FREE FORMAT →File Declarations →Variable Declarations →Indicator Data Structure →Built-In-Functions ↳ %found , %date , %char ,%diff →Opcodes ↳chain →Loops ↳Dow →Conditional statements ↳IF ,Select →Procedures →sub procedures →Modules 👉 DM me "PROJECT" for code 📥 I'll send you: ✅ Project Code ✅ Design Screen Screenshots ✅ And much more Follow D John for more content like this! #rpgle #clp #as400 #project

In many programs, we have the need to insert a record into a table, or, if it already exists, insert a new one... To do this, many of us do it checking the value of SQLCOD. We do the update, and if it fails because the record does not exist, then we add a new record... There is a simpler, and more elegant, way to do this, using the Merge statement. I show you an example of how you can use it! Enjoy! #ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #as400 #common #sql #sqltraining #ibmchampion