Coding in RPG (IBM i/AS400). Using BLOB SQL fields in RPG to store and retrieve data.
New example video!
In this video I'd like to show you an example of how to create a table with a BLOB field, that can be used to store binary huge data (for example an IFS file). After that I'm adding a file that is stored in the IFS, and I'm show you how to retrieve it from the table and create it again in the IFS...
Check it and have fun!
#ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #as400 #common #sql #sqlrpg
0:00 Introduction
0:12 Creating a new SQL table with a BLOB field
1:34 Creating an example program to use this table
4:29 Creating a subroutine that will store a JSON (that is in the IFS), into the BLOB field of the table
7:38 Creating a subroutine that will retrieve the JSON from the BLOB field of the table
8:57 Testing the program in the green screen
10:39 Final coments and ending