Coding in RPG (IBM i/AS400). How to detect SQL execution errors in our RPG programs.

In this video I'd like to show you how detect the different errors or warnings that I can get while executing SQL statements embedded in our RPG programs.
To do that, I'm explaining about SQLCOD and SQLSTATE, and I show it to you in a sample program.
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 #embeddedSQL #SQLerrors #modernRPG

0:00 Introduction
0:18 Preparing the example
0:42 Showing the example table
1:17 Taking a look to the example source RPG code
2:08 Running the program (no error checks, program working fine)
2:45 Running the program (file doesn't exists in the system... but no error received)
4:35 Running the program (record doesn't exists in the table... but no error received)
5:29 Adding a monitor statement to catch the errors (doesn't work...)
6:46 Introducing SQLCOD and SQLSTATE
8:10 All the SQLCOD and SQLSTATE possible values that can be checked (IBM documentation)
9:05 Adding SQLCOD check to the program
10:45 Running the program with the error check added
11:55 Final comments and ending