-
SQL Index Vs Database Index: Top Differences
The differences between SQL index and Database index is little tricky question. This is the most confusing and discussed in many social media. The differences listed here are simple and you can grasp the subject quickly. Read More ⇢
-
Essential DL/I Functions for Efficient IMS DB Operations
The complete list of DL/I functions that you need to write a COBOL program for IMS DB database. This list helps you write your programs so effectively. The main use of DL/I functions is to interact with database and to manipulate segments in IMS DB database. Read More ⇢
-
How to Use DECODE in SQL Query and Its Real Purpose
The DECODE scalar function in DB2 SQL helps you handle logic related scenarios. You can also handle NULL values and you can replace NULL values with values as you wish in your end result. Read More ⇢
-
How to Delete VSAM Secondary Index
Here is a logic to Delete alternative index in VSAM intelligently. Read More ⇢
-
SQL Query You Need to Create Pivoting Table
The best and mostly asked SQL query is converting rows into columns. This is a tricky question and it needs little intelligence to write effectively. This SQL query can be written in two steps with SQL functions either CASE or DECODE. Read More ⇢
-
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. Read 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. Read More ⇢
-
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. Read More ⇢
-
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. Read More ⇢
Srinimf 