-
DB2- Avoid Select Column Before do UPDATE
We do not have to retrieve data first and manipulate it before executing the SQL UPDATE. Avoiding that work requires an extra call to DB2. Below example dynamically retrieve a row, and update the Column value. suppose an employee is to be given a 10% raise. You could select the employee’s salary,… Read More ⇢
-
DB2 Creating Index: 6 Thumb Rules
Indexes speed-up the performance in database. Here are best practices to keep in mind while creating an index in DB2. Best Practices to Create Index From DB2 V9 onwards, we can create Index on expression. By creating expression as alias, and we can create index on alias. Related posts Read More ⇢
-
CICS – Pseudo Conversational Program
CICS- is also called Customer information control system. The term pseudo conversation program refers effective utilization of resources, and the conversation terminates itself. Traditional program has both presentation logic and business logic in single program. Where as in modular design presentation logic is separated from business logic. CICS- is following pseudo conversational… Read More ⇢
-
COBOL VSAM Files READ with START Logic
Here’s COBOL sample program that explains that reading of VSAM files. Read More ⇢
-
How to Improve Your SQL Queries
The following SQL checklist will help to review SQL Queries. Check for by mistake any inner join is coded as outer-join Check all union statements, is it really needed, or we can go with UNION ALL Check for NULLABLE columns, if NULL value comes, we need to handle -305 errors… Read More ⇢
-
SQL -204 error resolution to resolve quickly
SQL -204 error quick resorption Read More ⇢
-
COBOL VB Files – Top Interview Questions
Variable records are very common in Mainframe real-time projects. The data varies in length. The awesome collection of question on VB files really an asset for you to review quickly when you are in leisure or working on the COBOL project. Read More ⇢
-
6 DB2 SQL Set Operators
Here are complete DB2 SQL Set operators that use to get data from multiple Tables Read More ⇢
Srinimf 