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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 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

5 years ago

Start Stop and Continue is a great format to focus on the things that are working (CONTINUE), things that are…

EMPTY File condition check using JCL utilities

5 years ago

If you have a requirement to check Empty File before applying certain operations then it can be done using ICETOOL…

Product Backlog Prioritization – Tips and Tricks

5 years ago

Product Backlog Refinement consists of Creating & Refining User Stories, Estimating User Stories & Product Backlog Prioritization. It is the…

INSPECT statement in COBOL Programs

5 years ago

The INSPECT statement can be used to tally the number of occurrences of specific character strings, to replace characters by…

DB2 Cursor use in COBOL Programs

5 years ago

DB2 Cursor builds a results table to hold all the rows retrieved by executing a SELECT statement. DB2 uses a…

DoD (Definition of Done) Vs DoR (Definition of Ready)

5 years ago

Many teams use the Definition of Done (DoD) to check if a user story is finished and the product is…

Definition of Ready – Importance in Agile

5 years ago

Definition of Ready is a set of agreements that let you know when a user story is really done, the team…

Definition of Done – Importance in Agile

5 years ago

Definition of Done is an agreement between Development Team and the Product Owner on what needs to be completed for…

Effective User Story – Card, conversation, confirmation

5 years ago

3C's is an Effective User Story technique. 3Cs: Card, Conversation, and Confirmation. The Card is the index card that the User Story…