- Blog
- Blog
- Homepage
- Homepage
-
Logging in IMS DB: A Complete Guide to Audit Trail Records
In IMS DB, there are strong reasons why monitoring log activities is really needed. The DBA or Senior programmer must watch the logs about what activities happened on the database. In IMS DB the log file contains 3 key records. Read for more.
-
How to describe Data consistency in better way
The database consistency is very important to get up to date information. In DB2 database why data consistency is necessary and best explained with example when it is needed. Committing the data is a main task in data consistency.
-
A Guide to Creating a Test Plan for Software Testing
In Software development testing is a major share of the work. Writing test cases effectively helps not only get first time approval by reviewers and you can control the bugs in the piece code you are changing in Software development. You need some tips to write better Test cases.
-
A Comprehensive Guide to Aggregate, Scalar, Table and Row Functions
A function connects input to result values. They vary into aggregate, scalar, table, and row types.
-
The Purpose of ‘When Other’ in COBOL EVALUATE
These are the basic reasons why when other is needed in COBOL evaluate
-
SQL Aggregate Vs Group By
SQL aggregate function and their rules. Built-in SQL functions.
-
How to get Query Details in SYSIBM.SYSQUERY
Process you need to analyze SQL query to improve performance.
-
SUM Aggregate function ideas to use on multi columns
SUM aggregate function explained how to use on multiple table columns and given sample SQL query.
-
Getting Started with Cloud Computing: An Overview of the Basics
In this post, given top cloud technology tricky questions useful for interviews
-
DB2 in simple way: what is index only access
Most programmers confuse on index only access. This post tells in simple way how DB2 index only access works, and how it improves performance.
-
How to choose cleverly DATE,TIME OR TIMESTAMP for Table Columns
In DB2 Date , time and timestamp are three different columns in a table. So this post gives the best idea on how to choose these columns in Table to suit project requirements as well as better performance.
-
Exception JOIN in SQL: How to Write Correctly – And Best Example
Exception JOINS are one kind of JOINS in SQL. The SQL query given in simple way gives you the actual use of it. This is an alternative to complex sub-queries. Sub-queries need lot of lines of SQL lines instead of JOINS. So JOINs are less confusing compared to Sub-queries.
Srinimf 