Using Cursor in SQL Stored Procedure in IBM i DB2 AS400-DECLARE CURSOR,PREPARE,OPEN

This video explains the use of cursor in SQL stored procedure in IBM i DB2 AS400. Declare cursor, prepare statement and OPEN, FETCH and CLOSE statements have been explained in this video.
Dynamic SQL statement has been used in cursor.
Used the parameter marker in SQL stored procedure sql statement being prepared. Creating and using SQL global variable using CREATE VARIABLE statement and DROP SQL global variable to drop SQL global variable. Continue handler is used SQL condition used, WHILE and END WHILE loop used.
This video also explains how to call the SQL stored procedure having OUT parameter.

You can also watch other AS400 Training related playlist as follows:
1-AS400 Training: https://www.youtube.com/watch?v=KwFxsxqMUjw&list=PL34QvIMpkj1mflxSP7nKUQiWaYTyhhnAX
2-ILE RPG Tutorial in AS400: https://www.youtube.com/watch?v=F2bS3kRpC8Q&list=PL34QvIMpkj1lOoWJuyx2BHbXwYC7llIpe
3-DSPF programming tutorial in AS400: https://www.youtube.com/watch?v=LeyaOnFtJgg&list=PL34QvIMpkj1kSEMlxLTYohtjsUYT5Qr1C
4-RPGLE Triggers in AS400: https://www.youtube.com/watch?v=chCduA59sIo&list=PL34QvIMpkj1k7wCd8yXKtmHfwd67d-Z1J
5-AS400 Interview Questions: https://www.youtube.com/watch?v=ojWAVE9kbcQ&list=PL34QvIMpkj1kw5r6y0xAGlMI0nIg0D02u
6-API programming in AS400:https://www.youtube.com/watch?v=6bjhn12c6QE&list=PL34QvIMpkj1lwvJZ4eXjjLtP9ZgmfiGRw
7-AS400 basic Introduction Tutorial: https://www.youtube.com/watch?v=S9MsjCoaWzc&list=PL34QvIMpkj1lPQkfabHoK0KqcnO7KZfLe
8-CL programming Tutorial in AS400: https://www.youtube.com/watch?v=vBBYyd3mRaY&list=PL34QvIMpkj1kg9VnKnyksMTTdNJxAYUjE
9-Tips and Trick in DB2 SQL Tutorial in AS400:https://www.youtube.com/watch?v=WC9iqkPY7R0&list=PL34QvIMpkj1narSP6O0KihSXHPXJXl547
10-Tips and Tricks in AS400:https://www.youtube.com/watch?v=UdxtnLkJzVM&list=PL34QvIMpkj1lw96BgYrud255VYolpJ8rb
11-Production support in AS400:https://www.youtube.com/watch?v=XZp_rPBnubc&list=PL34QvIMpkj1mExgT3jJUlEcwiyyhkPcU-
12-Errors in AS400:https://www.youtube.com/watch?v=32UDiFmXODA&list=PL34QvIMpkj1nf3mqfjya3xyOlF6BohtCn
13-IBM i AS400 Tutorial:https://www.youtube.com/playlist?list=PL34QvIMpkj1nwjyI7fI3xlovdUmu7OcLj
14-SQLRPGLE Tutorial in AS400: https://www.youtube.com/watch?v=g0dDEYWAqak&list=PL34QvIMpkj1nW4H7La_mSRW2MmbeN4Ods
15-Subfile programming in AS400:https://www.youtube.com/watch?v=ZJ8TEdbME50&list=PL34QvIMpkj1mIaSo4fJGoEtLwGwdoKvJR
Database modernization Tutorial in AS400:https://www.youtube.com/watch?v=6F2VGvm6gyM&list=PL34QvIMpkj1lmneWqDcrzU3qU5z-eal4f
16-SQL DB2 Tutorial in AS400:https://www.youtube.com/watch?v=NcndPqx8I0k&list=PL34QvIMpkj1lXxfR_jrNU4IYsWujgi8dc
17-DB2 AS400 DDS Tutorial in AS400:https://www.youtube.com/watch?v=rC25la2-3vI&list=PL34QvIMpkj1l_eHnpTkTmy1NPtNDDoUZe
18-RPG programming Tutorial in AS400:https://www.youtube.com/watch?v=MK8eNhe-i40&list=PL34QvIMpkj1mjTuOBirD_44WBcPjoUEJk

My Easy Classes is the YouTube channel which aims to provide the coding videos on RPG, CL, SQLRPGLE and SQL DB2.