Part 2 Challenge 14 solution – Db2 SQL | Master the Mainframe 2019 | IBM MTM 2019



Part 2 Challenge 14 solution – Db2 SQL | Master the Mainframe 2019 | IBM MTM 2019

Part 2 Challenge 14 solution - Db2 SQL | Master the Mainframe 2019 | IBM MTM 2019

This video is solution to the Part 2 challenge 14 of the Master the Mainframe Contest 2019.

In this video you will learn about DB2 SQL. DB2 is a relational database. In this challenge you will configure DB2 Interactive ISPF panel and then execute SQL using SPUFI. You will put the result of the SQL in a dataset.

Master the Mainframe or MTM is an annual contest organized by IBM every year. The aim of the contest is to make students familiar with Mainframes. Students can learn valuable skills and earn digital badges.

These badges help in getting employment as well. You can use the badges to apply for jobs. The badges can also be used on your LinkedIn account.

The Master the Mainframe Contest consists of 3 parts. The solution to all the 3 parts can be found on my channel.

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

For more videos on Mainframes, be sure to subscribe !!!!

SUBSCRIBE ➤➤➤ https://www.youtube.com/channel/UCaZcYzHOLQJqSUv1iP8jbHQ?sub_confirmation=1

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

My BESTSELLER courses:
👉 The Complete Mainframe Professional course: https://www.udemy.com/course/the-complete-mainframe-professional-course-tso-ispf/?referralCode=F35DCE84EBFDE975A112
👉 The Complete Job Control Language (JCL) course: https://www.udemy.com/course/the-complete-job-control-language-jcl-course/?referralCode=D9B2308F2A111ADB0B39

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

My FREE courses:
✦ Mainframe Pi: https://www.udemy.com/course/mainframe-pi-install-mvs-on-your-raspberry-pi/
✦ An Introduction to Job Control Language (JCL): https://www.udemy.com/course/an-introduction-to-jcl/

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

MORE VIDEOS ON MAINFRAMES
⦿ JCL tutorial: https://www.youtube.com/watch?v=C9WukMUZoYo&list=PL2mIqhVadmYID0rOTmNCdo231wqSyVLyT
⦿ COBOL tutorial: https://www.youtube.com/watch?v=W0Sre-5qfUY&list=PL2mIqhVadmYJCqScWAPRnoXd0JvfbZWfM
⦿ Full solution to the Master the Mainframe 2019 contest: https://www.youtube.com/watch?v=-0iwar0cIiU&list=PL2mIqhVadmYJFMqu3zYgN2qZ7DdfcQ_nS

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

COME SAY HELLO! 👋
➡️ Website: https://mainframenation.com/
➡️ Subscribe on YouTube: https://www.youtube.com/channel/UCaZcYzHOLQJqSUv1iP8jbHQ?sub_confirmation=1
➡️ Follow on Twitter: https://www.twitter.com/MainframeNation
➡️ Follow on Instagram: https://www.instagram.com/mainframenation/
➡️ Like on Facebook: https://www.facebook.com/Mainframe-Nation-113405350093090/
➡️ Pinterest: https://www.pinterest.com/mainframenation/
➡️ My EMAIL: [email protected]

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Still reading this? Then write “👌 Hey! Mainframe Nation” in the comments!

#mainframe #ibm #ibmz #zos #mainframenation #masterthemainframe #MTM #MTM2019 #masterthemainframe2019 #ibmz #ibmzday #zos #ibmmainframe #mtmsolution #mtm2019solution #masterthemainframe2019solution #masterthemainframesolution #parttwo #part2 #parttwochallengefourteen #Challenge14 #challengefourteen #p2ch14

https://youtu.be/0Ft-Z6Iqh44