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 👏👏👏
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.
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.
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.
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.
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
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
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..
Thank you somuch Sir ..very detailed explanation and covered all topics in a quick way ...😊
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 👏👏👏
Keep it up!! and Congratulations Bhuvana bhuvi...
@@kadamanchilavanya9547 How s your job in TCS andi
@@kadamanchilavanya9547 How many years of experience you have in mainframes
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.
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.
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
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.
You got us.. We have been smashed with pre compilation that I was expecting in the whole video.. Nicely explained all the concepts.
Excellent class! Will look at your other classes.
No words really quick refresher so useful thanks bro👍
Welcome 👍
You have covered almost everything in short time
Excellent refresher, Keep it up for thankless Job you have done.
Thanks a lot
Thank you so much , very nice refresher, quick n easy to understand
Thank you so much for listening to us and preparing the DB2 refresher........!!!!!!
Any time!
Thank you so much.. It is very useful.. Please consider taking stored procedures
Thank you! Raghilesh. Input taken.
Very useful before the interview.
Very Useful 🎉
Well explained
Thanks for this refresher... it will be useful if you can make some videos on IMS DB/DC & CICS Thank you.
Very Good. very useful
Great useful course .. thanks
thanks kumar.. it helped me a lot ..
This is too Good👌
It's very helpful bro
Great work Sir
Can you please make refresher for SQL
Awesome....Very useful👍
Awesome! Thank you
Thanks Kumar
It's really helpful 👍
Hi sir..can u plz make a series on IMS DB as well..plz..?
...good..... From Salvador Brasil
Thank you Sir..!!!
As ur explanation is easy to understand so kindly do videos on vision plus-cards and domain
Very helpful 👍
Hello sir thanks for all ur videos kindly do videos on vision plus-cards and domain
This is so good!!! How much you can cover in one hour!!
Thanks
Hi Kumar Sir ,Thanks for this video.And post a video on DB2 real time scenario questions
Sure As soon as possible thanks!
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.
Great suggestion! Sure will work on it!! Thank you! Raghav for your input as always..
@@KumarITChannel Ur welcome😊
@@KumarITChannel Are there videos on fileaid
Bro please upload most important and commonly asked interview questions for cobol, JCL,vsam, DB2 and cics in one video
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.
Do you have the CICS course on UDEMY? the voice sounds very similar... ;)
I do! . Good Catch
Can you please explain the major components and physical and logical objects in db2
How can I get access to a system like this? There are some Hercules mainframe and all but didn’t feel good.
Good and quick refresher☺️
Would have been great if bind plan/package is covered
Yes, you are right!! thanks! It's next in the queue..
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
We have to use WITH HOLD.. He has mentioned in the video
the ppt has wrong sql code when select query fetches more than one record.. its given as -81. where it is -811.
I was gonna point out the same, I am surprised he just read the PPT with sqlcode -81 🤣🤣
Can I access both VSAM and DB2 from a cobol Cics program?
I think the query for selecting top nth salary is wrong. It should be A.EMPSAL
Please add CICS refresher also ..
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
Pls upload the video on DB2 precompile and bind part
Hello Manish,
Please checkout the below video.
ruclips.net/video/vscxnkxLuhg/видео.html
convert cobol to c# tool for db2 database connection
Sir please add null indicator.
Sure will do. Thanks
what is db2 stored procedure?
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
Hi can you please provide lectures pdf or drive link where can we get these lectures pdf
COBOL db2 JCL pdf
42:56
Can you provide a quick refresher on SAS
Thanks! for the inputs Anusha. I added the topic to my Queue,.
pls add restart logic
Bro.. can you please share the ppt doc
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..
Your video is useful but it need some correction
Like what?
how to create database and tabl space
#1
CREATE DATABASE
#2
CREATE TABLESPACE
IN
USING (
FILE '///file'
4K
)
#3
COMMIT
This 2nd salary query do not look correctly.
This needs distinct then count on salary
Thanks! let me re-look on it. There are multiple ways of writing a query. Thanks for the input.
can you share the pdf pls?
I think I met u