Srini

Srinimf

Blog: https://srinimf.com/
Blog: https://srinimf.com/
Profile: https://srinimf.com/author/moonrobot/
Profile: https://srinimf.com/author/moonrobot/
Homepage: https://srinimf.com
Homepage: https://srinimf.com

How to Understand Triggers in DB2 SQL Context

SQL triggers of different types in DB2 context
How DB2 Keeps Logs for Changes to Tables

When changes are made to the data in tables, subsequently changing the table space and index spaces, DB2 writes one or more records to its log so that a blackout of the changes can be performed if the unit of work fails. DB2 can also use this information to reapply changes that may have been…
How to Send Pdf to email id Using Batch JCL

The sample jcl where you send pdf to your mail id. This kind of technic people use to create a report and send it to email id.
How to Insert Rows in DB2 Tables: 2 Top Methods

DB2 Insert and Load utility are popular methods to insert data to database.
What is Business Intelligence and Why You Need

Do you think that Data warehousing and BI are the same? The answer is NO. Warehouse stores data in an RDBMS, but Business intelligence (BI) is an outcome of data. Data warehousing Business Intelligence Keep Reading Related
IMS DC MFS Control Blocks (2 of 3)

The use of Message format service (MFS) control blocks in IMS DC explained in this post.
How to Use Perl to Write UNIX Scripts

Perl is one of the top scripting languages. This post tells you how to write UNIX script in Perl.
IMS DB: How to Restart Batch Job When U102 Error

The batch jobs in IMS DB before you restart a DL/I batch job, ensure all database changes have been backed out. Read more.
PLI Program: Process Options Real Usage (1 of 2)

The %PROCESS statement identifies the start of each external procedure and allows compile-time options to be specified for each compilation. The options you specify in adjacent %PROCESS statements apply to the compilation of the source statements to the end of input, or the next %PROCESS statement. To specify options in the %PROCESS statement, code as…
How to Use REPAIR Utility in DB2

Here is all about REPAIR utility. It fixes data in tables and their related data structures. The data can be of any type, such as data contained in a table or data that is generally not accessed, such as map pages and index entries. DB2 REPAIR Utility REPAIR DBD: Tests Database Descriptors (DBDs) that point…
MQSeries Tutorial for Mainframe Programmers (1 of 5)

MQSeries is most popular in case of mainframe environment to interface with the Open system applications. So that mainframe is capable to interact with modern front end applications. MQSeries is the best tools and this tutorial really good to all the developers.
SQL code -180 DATE, TIME, OR TIMESTAMP Value is Invalid

SQL error code -180 reason and quick resolution.