INCLUDE OMIT Numeric Test Alphanumeric Test

5 years ago

You can use one of the numeric test capabilities of the INCLUDE OMIT Numeric test statement to collect the records…

INCLUDE OMIT Substring Comparison using SORT

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 years ago

XSUM Control Statement captures the dropped duplicate records which are eliminated out of DFSORT in a separate file. The SUM…

Split dataset using Mainframe SORT utility

5 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

5 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

5 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

5 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

5 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

5 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

5 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

6 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

6 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

6 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

6 years ago

SPS Certification - Scaled Professional Scrum™ (SPS) with Nexus™ is one of the most popular Agile certifications provided by Scrum.org.…

PI Planning – Tips and Tricks with Steps

6 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

6 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

6 years ago

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

Starfish or The Wheel – Sprint Retrospective

6 years ago

The Starfish Method for Sprint Retrospectives is an easy way to achieve focus, give a voice to every member, and…

Mad Sad and Glad – Sprint Retrospective

6 years ago

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