INCLUDE OMIT Substring Comparison using SORT

7 years ago

INCLUDE OMIT Substring Comparison You can use the INCLUDE OMIT Substring Comparison statement in conjunction with other options to select/omit…

Velocity vs Capacity in Sprint Planning

7 years ago

Velocity vs Capacity Velocity is used for measuring the rate at which scrum development teams consistently deliver business value in…

Outlook Rules : Manage Email messages using Rules

7 years ago

Outlook Rules evaluate your incoming or outgoing email messages and take various actions with them based on sets of instructions…

Agile Coach Interview Questions and Answers – I

7 years ago

Agile Coach The Agile Coach is someone who is experienced in implementing agile projects and can share that experience with a project team. An Agile…

SQL Query Optimization: Tips & Tricks

7 years ago

SQL Query optimization is a process of writing optimized SQL queries to improve database performance. It is one of the…

DB2 Predicates : Performance Tuning of DB2 Queries

7 years ago

The DB2 Predicates affect how DB2 selects the access path for the statement. Predicates are found in the WHERE, HAVING,…

SQL Predicates: use in COBOL DB2 Queries

7 years ago

SQL predicates, also referred to as conditional expressions, specify a condition of a row or group that has one of…

XSUM – Remove Duplicate Records using SORT

7 years ago

Eliminating duplicate records while preserving clean output and capturing the discarded duplicates can be efficiently achieved using the DFSORT or…

Split dataset using Mainframe SORT utility

7 years ago

OUTFIL can create multiple output data sets from a single input data set. Here are five ways you can use…

ASCII to EBCDIC or EBCDIC to ASCII conversion

7 years ago

You can change ASCII to EBCDIC in a file using ATOE function. Also EBCDIC to ASCII conversion can be done…

EXISTS vs NOT EXISTS use in Subqueries

7 years ago

EXISTS and NOT EXISTS are used with a subquery in the WHERE clause to examine if the result the subquery…

WER027A WER039A WER046A WER235A – Syncsort Error

7 years ago

WER027A - CONTROL FIELD BEYOND RECORD EXPLANATION Explanation: The location of the last byte of a SORT/MERGE or JOINKEYS control…

Agile Principles-Values-Challenges Q & A

7 years ago

Agile Principles-Values-Challenges: This is in Question and Answer form so that we can understand Agile Principles-Values-Challenges in detail. Please read Agile…

Date-Time-Timestamp use in SQL Queries

7 years ago

The sysibm.sysdummy1 table is a special in-memory table that can be used to fetch the value of DB2 registers Date-Time-Timestamp.…

Sprint Review: How to be effective Tips and Tricks

7 years ago

Sprint Review is to inspect the outcome of the Sprint and determine future adaptations. It is a platform for feedback…

VSAM Interview Questions with Answers

7 years ago

The VSAM interview questions and answers are intended for those with a working knowledge of VSAM as a programmer. This…

SHIFT : Add or Remove SPACES-characters to input data

7 years ago

SHIFT =LEFT will left-squeeze by removing all of the blanks, shifting the remaining characters to the left and padding on…

Uppercase to Lowercase conversion – COBOL, DB2 & SORT

7 years ago

We can use INSPECT or UPPERCASE or LOWERCASE COBOL function to convert the case of alphanumeric, alphabetic, or national strings.…

SPS Certification – Important Tips and Tricks

7 years ago

The SPS Certification validates your ability to scale Scrum with Nexus. At 40 questions in 60 minutes (85% pass mark),…

PI Planning – Tips and Tricks with Steps

7 years ago

A Program Increment (PI) starts with a time-boxed PI Planning event in which the Agile Release Train is responsible for planning…

4Ls: Liked Learned Lacked Longed Retrospective

7 years ago

4Ls stands for Liked Learned Lacked Longed and it is a brainstorming technique for collecting feedback on a recently completed…

Sailboat or Speedboat – Sprint Retrospective

7 years ago

Sailboat Retrospective is a fun and creative way for teams to reflect on the sprint and identify areas for improvement.…

Starfish or The Wheel – Sprint Retrospective

7 years ago

The Starfish Retrospective is a highly practical sprint retrospective format that helps teams move beyond “what went well” and “what didn’t” into…

Mad Sad and Glad – Sprint Retrospective

7 years ago

A Mad Sad Glad retrospective is a simple and effective way for teams to reflect on their previous sprint. It…

Start Stop and Continue – Sprint Retrospective

7 years ago

The Start Stop and Continue format is a simple, action‑oriented sprint retrospective technique that helps Scrum teams reflect on what is working,…