Mainframe Wednesday Talks#7 - DB2 Refresher in Just one Hour

[@lambuzambu4956]

Thank you somuch Sir ..very detailed explanation and covered all topics in a quick way ...😊

[@carolyns1965]

I've just come back to COBOL/DB2 after a few years break and these are exactly what I needed to kickstart my old brain. Thanks so much

[@bhuvanabhuvi1699]

Hello sir, I have followed all your videos for my interview for jcl cobol and db2. And finaly I ve selected for first attempt. Thanks to you. I wil definitely recommend your channel for my friends. GREAT WORK 👏👏👏

[@KumarITChannel]

Keep it up!! and Congratulations Bhuvana bhuvi...

[@hemak8969]

@@kadamanchilavanya9547 How s your job in TCS andi

[@hemak8969]

@@kadamanchilavanya9547 How many years of experience you have in mainframes

[@RameshKumar-ng3nf]

People are so selfish. They write a comment. Then others asking help.. They dont respond at all. Then they say i was "BUSY". If you really wanted to help anyone there is no busy. Everybody is busy and if interested to help will help or multiple excuses.

[@richardOutOfMatrix]

Thank you for this Video. I found it super helpful. I am a long timer on mainframes and was out of touch for few years and this really helped a lot.

[@manonmanik3178]

You got us.. We have been smashed with pre compilation that I was expecting in the whole video.. Nicely explained all the concepts.

[@suzannesellers7383]

Excellent class! Will look at your other classes.

[@nirmala-2025]

Well explained

[@sreevidya9247]

No words really quick refresher so useful thanks bro👍

[@KumarITChannel]

Welcome 👍

[@pakoymm]

Thank you so much Kumar for share this helpful video with all the concepts of DB2 refresh, it help us to have the concepts fresh and understand better and be prepared for the interviews, thanks so much again.

[@DoNaK_DeViL]

Very Useful 🎉

[@motivationwithkailas]

You have covered almost everything in short time

[@ksssrikanth]

Excellent refresher, Keep it up for thankless Job you have done.

[@KumarITChannel]

Thanks a lot

[@hemak8969]

Thank you so much , very nice refresher, quick n easy to understand

[@mounikamona9274]

This is too Good👌

[@meenakshikumar5467]

Great work Sir

[@meenakshikumar5467]

Can you please make refresher for SQL

[@sutharsanamsaranathan1112]

Very Good. very useful

[@sdharani532]

Awesome....Very useful👍

[@wesg01]

Awesome! Thank you

[@ravinderkaleru7097]

Great useful course .. thanks

[@sarathpelluri9621]

thanks kumar.. it helped me a lot ..

[@stephenit4772]

It's very helpful bro

[@sbiswas2798]

Very useful before the interview.

[@mubasheeruddiinkhaja7025]

Thanks Kumar

[@robinmathew659]

It's really helpful 👍

[@luisaugusto4865]

...good..... From Salvador Brasil

[@shirazbasha]

Thank you so much for listening to us and preparing the DB2 refresher........!!!!!!

[@KumarITChannel]

Any time!

[@kartik9525]

Thank you Sir..!!!

[@Khane_pe_Charcha]

Very helpful 👍

[@raghileshr1246]

Thank you so much.. It is very useful.. Please consider taking stored procedures

[@KumarITChannel]

Thank you! Raghilesh. Input taken.

[@dharanipalanisamy9762]

Thanks for this refresher... it will be useful if you can make some videos on IMS DB/DC & CICS Thank you.

[@devotionallife2108]

Thanks

[@veminenivj4042]

Hi sir..can u plz make a series on IMS DB as well..plz..?

[@anuishwarya6601]

As ur explanation is easy to understand so kindly do videos on vision plus-cards and domain

[@mayurakshidey7787]

This is so good!!! How much you can cover in one hour!!

[@anuishwarya6601]

Hello sir thanks for all ur videos kindly do videos on vision plus-cards and domain

[@reenadavid6497]

I think the query for selecting top nth salary is wrong. It should be A.EMPSAL

[@monisharaji5686]

Hi Kumar Sir ,Thanks for this video.And post a video on DB2 real time scenario questions

[@KumarITChannel]

Sure As soon as possible thanks!

[@siddaboinasravanthi4771]

Very good learning refresher.. Thank you..sir but, sometimes we couldn't able to read letters in video, some sentences was not clear when u r explaining.please look into this...other than this everything looks good.

[@basicbadmintonusa]

How can I get access to a system like this? There are some Hercules mainframe and all but didn’t feel good.

[@stephenit4772]

Bro please upload most important and commonly asked interview questions for cobol, JCL,vsam, DB2 and cics in one video

[@raghavagarwal6545]

Thanks for this refresher... it will be useful if you can make some videos on some of the main MF tools, like Endeavor, File-Aid, Xpeditor, etc. Thank you.

[@KumarITChannel]

Great suggestion! Sure will work on it!! Thank you! Raghav for your input as always..

[@raghavagarwal6545]

@@KumarITChannel Ur welcome😊

[@LUXESTATEX]

@@KumarITChannel Are there videos on fileaid

[@ramivemi5985]

Can you please explain the major components and physical and logical objects in db2

[@poornimaganapathiraman5991]

Thanks a lot for this video, it is really helpful to prepare for interviews! I faced this question recently - why cursors get closed when commit is issued. Can anyone pls help clarify this

[@honeychoobies483]

We have to use WITH HOLD.. He has mentioned in the video

[@xypq8310]

Can I access both VSAM and DB2 from a cobol Cics program?

[@732mojo]

the ppt has wrong sql code when select query fetches more than one record.. its given as -81. where it is -811.

[@loveforcrickett]

I was gonna point out the same, I am surprised he just read the PPT with sqlcode -81 🤣🤣

[@nareshvangari3815]

Good and quick refresher☺️ Would have been great if bind plan/package is covered

[@KumarITChannel]

Yes, you are right!! thanks! It's next in the queue..

[@nairshyama98]

Please add CICS refresher also ..

[@CPR1922]

Hi Kumar How to contact you ,I have some doughts in mainframe errors or can you make more videos jcl abends and errors in COBOL plz

[@007rockford]

Do you have the CICS course on UDEMY? the voice sounds very similar... ;)

[@KumarITChannel]

I do! . Good Catch

[@manishmisra78]

Pls upload the video on DB2 precompile and bind part

[@KumarITChannel]

Hello Manish, Please checkout the below video. kzbin.info/www/bejne/rKTGqaGhrbGonsk

[@tanyabarnwal2061]

what is db2 stored procedure?

[@KumarITChannel]

A DB2 stored procedure is a precompiled program that is stored in a database and can be executed by calling it from other programs or applications. Stored procedures allow developers to encapsulate a set of SQL statements into a single, reusable program. This makes it easier to maintain and reuse complex business logic, and also helps to improve performance by reducing the amount of network traffic between the client and the database server

[@factnation1363]

Sir please add null indicator.

[@KumarITChannel]

Sure will do. Thanks

[@archiee_]

Hi can you please provide lectures pdf or drive link where can we get these lectures pdf COBOL db2 JCL pdf

[@BobMossanen]

convert cobol to c# tool for db2 database connection

[@priyaagarwal3104]

pls add restart logic

[@anilreddyadithya2788]

Bro.. can you please share the ppt doc

[@anushanag489]

Can you provide a quick refresher on SAS

[@KumarITChannel]

Thanks! for the inputs Anusha. I added the topic to my Queue,.

[@732mojo]

the examples you showed for Joins is wrong.. we need to do it using alias.. please update.. if someone is not doing a cross check.. he is bound to fail if it comes in interview.. it can cost a job.. thanks for the video though..

[@kalyankumarkanuturi1914]

how to create database and tabl space

[@KumarITChannel]

#1 CREATE DATABASE #2 CREATE TABLESPACE IN USING ( FILE '///file' 4K ) #3 COMMIT

[@shubhangijadhav8396]

Your video is useful but it need some correction

[@KumarITChannel]

Like what?

[@motivationwithkailas]

This 2nd salary query do not look correctly. This needs distinct then count on salary

[@KumarITChannel]

Thanks! let me re-look on it. There are multiple ways of writing a query. Thanks for the input.

[@Akshaytyagixin]

42:56

[@gatlavaishnavi3347]

can you share the pdf pls?

[@sumibharali4061]

I think I met u