@MyKkata I’m thrilled to hear that the video was helpful! If you have any more questions or need further assistance, feel free to ask. Happy learning! 🌟
Hi There, Thank you so much for your feedback. If you like this video then please consider subscribing to our channel for more such video and do share this video with friends. Thank you, Topictrick.
That was really nice presentation and very clear and simple to follow. I just wanted to understand more about 'BEGIN ATOMIC' keyword used in the DDL, mostly whats is significance and when its required or when its not?
@rajeshkumara6 Thank you for your kind words about the presentation! I’m glad you found it clear and simple to follow. Now, let’s dive into your question about the ‘BEGIN ATOMIC’ keyword in Data Definition Language (DDL). The ‘BEGIN ATOMIC’ keyword is part of the ANSI SQL standard. It’s used in atomic blocks at the top level of natively compiled stored procedures, as well as for natively compiled, scalar user-defined functions. Atomic in this context means that either the operation succeeds (and is logged to the binary log) or is completely reversed. This is referred to as atomic DDL. An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. The atomicity ensures that your database remains consistent, even if a server crash occurs during the operation. After the server has restarted, all tables are consistent, there are no temporary files or tables on disk, and the binary log matches the status of the server. However, it’s important to note that atomic DDL is not transactional DDL. DDL statements, atomic or otherwise, implicitly end any transaction that is active in the current session, as if you had done a COMMIT before executing the statement. This means that DDL statements cannot be performed within another transaction, within transaction control statements such as START TRANSACTION … COMMIT, or combined with other statements within the same transaction. I hope this helps! If you have any more questions, feel free to ask. 😊 Thanks!
Hi There, Thank you so much for your feedback. Please consider subscribing to our channel for more such videos and do share this video with your friends. Thanks, Topictrick
@suryab3046 Thanks for your comment. Yes, it is possible to call an API inside a DB2 trigger. DB2 triggers are powerful database objects that can be used to enforce business rules, perform data validation, or execute custom logic when certain events occur, such as insert, update, or delete operations on a table. Refer the following link: developer.ibm.com/tutorials/dm-1105httprestdb2/ Thanks!
@@Topictrick Hi i followed the reference link you provided but when implementing i'm getting error as 'No authorized routine named "HTTPGETCLOB" of type "FUNCTION" having compatible arguments was found.. SQLCODE=-440, SQLSTATE=42884, DRIVER=3.72.44' any idea on this?
@suryab3046 Thanks for your comment. I have never implemented such requirements. But you can try the following steps to resolve the problem: Make sure that the function 'HTTPGETCLOB' is installed and authorized correctly. Check the documentation or instructions that came with the function to ensure you have followed all the necessary steps for installation and authorization. Verify that you are passing the correct arguments to the function. Double-check the syntax and parameter requirements of the 'HTTPGETCLOB' function to ensure you're using it correctly. It's possible that you may be missing a required argument or using an incompatible one. Confirm that the version of the driver you're using is compatible with the function. Sometimes, certain functions may require specific versions of the driver to work properly. Make sure you have the appropriate version installed. If you're working in a shared or restricted environment, such as a database managed by an organization or hosting provider, reach out to your administrator or support team for assistance. They may need to grant you the necessary permissions or provide additional guidance. If none of these suggestions resolve the issue, it might be helpful to provide more information about the context in which you're using the 'HTTPGETCLOB' function and any relevant code snippets. This can help in further diagnosing the problem. Thanks!
@aboutnature522 Thanks for your message. I understand your frustration regarding the time spent by developers in fixing DB2 -805 issues. In my opinion, If the programmer adheres to standard procedures and follows the recommended steps, they can resolve the issue promptly. I don't think it's an issue with IBM. You will find same issue with almost all other DB or Programming language. Please consider subscribing to our channel for more such video. Thanks!
![[LIVE] MCHOICE & MINT AWARDS 2024 at TRUE ICON HALL, ICONSIAM](http://i.ytimg.com/vi/wMewUeT5nbY/mqdefault.jpg)
![Warhammer 40k: Space Marine 2 | เพื่อจักรพรรดิ ! [ตอนเดียวจบ]](http://i.ytimg.com/vi/4M0ckYMA4-U/mqdefault.jpg)
Oh Man -you are a life saver! This video is so clear/concise.. it gave me the answers that I was looking for. Thank you.
@MyKkata I’m thrilled to hear that the video was helpful! If you have any more questions or need further assistance, feel free to ask. Happy learning! 🌟
Excellent!!!. Great Presentation. Very Informative, Thanks!!
Excellent video..thank you so much!!
Hi There,
Thank you so much for your feedback. If you like this video then please consider subscribing to our channel for more such video and do share this video with friends.
Thank you,
Topictrick.
That was really nice presentation and very clear and simple to follow. I just wanted to understand more about 'BEGIN ATOMIC' keyword used in the DDL, mostly whats is significance and when its required or when its not?
@rajeshkumara6
Thank you for your kind words about the presentation! I’m glad you found it clear and simple to follow. Now, let’s dive into your question about the ‘BEGIN ATOMIC’ keyword in Data Definition Language (DDL).
The ‘BEGIN ATOMIC’ keyword is part of the ANSI SQL standard. It’s used in atomic blocks at the top level of natively compiled stored procedures, as well as for natively compiled, scalar user-defined functions.
Atomic in this context means that either the operation succeeds (and is logged to the binary log) or is completely reversed. This is referred to as atomic DDL. An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation.
The atomicity ensures that your database remains consistent, even if a server crash occurs during the operation. After the server has restarted, all tables are consistent, there are no temporary files or tables on disk, and the binary log matches the status of the server.
However, it’s important to note that atomic DDL is not transactional DDL. DDL statements, atomic or otherwise, implicitly end any transaction that is active in the current session, as if you had done a COMMIT before executing the statement. This means that DDL statements cannot be performed within another transaction, within transaction control statements such as START TRANSACTION … COMMIT, or combined with other statements within the same transaction.
I hope this helps! If you have any more questions, feel free to ask. 😊
Thanks!
@@Topictrick Thanks a lot :)
Nicely explained
Hi There,
Thank you so much for your feedback. Please consider subscribing to our channel for more such videos and do share this video with your friends.
Thanks,
Topictrick
As usual great explanation bro
Hi Siddhu,
Thank you so much for your message. We have send you JCL complete reference coupon code, so check your email. Thanks.
@@Topictrick thankyou🤗
Also CICS web services invocation
@prathapn01 Can you please elaborate your questions. Thanks
@@Topictrick I mean, exposing Mainframe host online programs to non mainframe applications via APIs
Can you make a vedio on DB2 stored procs and their execution
@prathapn01 Certainly! I am working on it and will publish the video soon. Thanks!
can we call an api inside db2 trigger?
@suryab3046 Thanks for your comment. Yes, it is possible to call an API inside a DB2 trigger. DB2 triggers are powerful database objects that can be used to enforce business rules, perform data validation, or execute custom logic when certain events occur, such as insert, update, or delete operations on a table. Refer the following link: developer.ibm.com/tutorials/dm-1105httprestdb2/
Thanks!
@@Topictrick thanks
@suryab3046 Your welcome buddy!
@@Topictrick Hi i followed the reference link you provided but when implementing i'm getting error as 'No authorized routine named "HTTPGETCLOB" of type "FUNCTION" having compatible arguments was found.. SQLCODE=-440, SQLSTATE=42884, DRIVER=3.72.44' any idea on this?
@suryab3046 Thanks for your comment. I have never implemented such requirements. But you can try the following steps to resolve the problem:
Make sure that the function 'HTTPGETCLOB' is installed and authorized correctly. Check the documentation or instructions that came with the function to ensure you have followed all the necessary steps for installation and authorization.
Verify that you are passing the correct arguments to the function. Double-check the syntax and parameter requirements of the 'HTTPGETCLOB' function to ensure you're using it correctly. It's possible that you may be missing a required argument or using an incompatible one.
Confirm that the version of the driver you're using is compatible with the function. Sometimes, certain functions may require specific versions of the driver to work properly. Make sure you have the appropriate version installed.
If you're working in a shared or restricted environment, such as a database managed by an organization or hosting provider, reach out to your administrator or support team for assistance. They may need to grant you the necessary permissions or provide additional guidance.
If none of these suggestions resolve the issue, it might be helpful to provide more information about the context in which you're using the 'HTTPGETCLOB' function and any relevant code snippets. This can help in further diagnosing the problem.
Thanks!
btw IBM need think how much time on an average has been spent by developers to fix db2 -805 issues.
its massive waste of time for no good reason !!!
@aboutnature522 Thanks for your message. I understand your frustration regarding the time spent by developers in fixing DB2 -805 issues. In my opinion, If the programmer adheres to standard procedures and follows the recommended steps, they can resolve the issue promptly. I don't think it's an issue with IBM. You will find same issue with almost all other DB or Programming language. Please consider subscribing to our channel for more such video.
Thanks!