Coding in RPG (IBM i/AS400). How to get information from the columns of a file
In this video I'd like to show you how to obtain information from the fields of a file, or table, using SQL from an RPG program.
For this I use the SYSCOLUMNS system table.
In addition, the program that I make as an example is created in a local repository using VSCode. I configure it to be deployed on the IBMi, and finally, I upload it to GitHub to share it with you!
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 #gitandRPG #gitandVSCode #modernRPG
0:00 Introduction
0:17 Explaining about SYSCOLUMNS and SYSCOLUMNS2
0:52 Creating a table for the example
1:33 Using SYSCOLUMNS with the new table
3:30 Creating a project in VSCode for the example
4:24 Creating the RPGLE source
5:05 Creating the main procedure
8:45 Creating the getFileInfo subprocedure
16:26 Preparing the project to be deployed to the IBMi
18:03 Creating the local repository
18:20 Setting up the options for deploying
19:20 Deploying the project
20:30 Using STRDBG to debug the program in the green screen
23:45 Comments and updating my local repository with the program
24:39 Uploading the project to GitHub
24:50 Ending