You can use the INCLUDE OMIT Substring Comparison statement in conjunction with other options to select/omit the number of records to be processed, which can reduce processor and data transfer time. There are two types of INCLUDE OMIT Substring Comparison tests: Find a constant within a field value: For example, search the value in a […]
INCLUDE OMIT Substring Comparison using SORT Read More »
Velocity is used for measuring the rate at which scrum development teams consistently deliver business value in other words quantity of work a team can accomplish within a sprint. In simple terms, velocity is the sum of the story points that a team can deliver in an iteration. It can be measured in terms of
Velocity vs Capacity in Sprint Planning Read More »
Outlook Rules evaluate your incoming or outgoing email messages and take various actions with them based on sets of instructions you set up, called . You can create outlook rules based on different message criteria, such as the message sender, message recipients, message content, attachments, and importance. Server-based outlook rules vs client-only outlook rules There
Outlook Rules : Manage Email messages using Rules Read More »
The Agile Coach is someone who is experienced in implementing agile projects and can share that experience with a project team. An Agile Coach helps to define what is to be done, how, who does it, when, why, how it fits in with the organization, change management, people management and interactions between agile teams and other parts of the organization
Agile Coach Interview Questions and Answers – I Read More »
SQL Query optimization is a process of writing optimized SQL queries to improve database performance. It is one of the factors that affect application performance. When working with large-scale data, even the most minor change can have a dramatic impact on performance. Top 10 ways to improve performance Indexing: Proper indexing ensures optimal access to
SQL Query Optimization: Tips & Tricks Read More »
The DB2 Predicates affect how DB2 selects the access path for the statement. Predicates are found in the WHERE, HAVING, or ON clauses of SQL statements; they describe attributes of data. Most DB2 predicates are based on the columns of a table. They either qualify rows (through an index) or reject rows (returned by a
DB2 Predicates : Performance Tuning of DB2 Queries Read More »
SQL predicates, also referred to as conditional expressions, specify a condition of a row or group that has one of three possible states: TRUE, FALSE NULL (or unknown). SQL Predicates are found on the tail end of clauses, functions, and SQL expressions inside of existing query statements SQL Predicates Categories Basic Predicate – A basic
SQL Predicates: use in COBOL DB2 Queries Read More »
Eliminating duplicate records while preserving clean output and capturing the discarded duplicates can be efficiently achieved using the DFSORT or SyncSORT utility’s SUM FIELDS=NONE, XSUM feature. The SUM control statement is designed to aggregate numeric fields when records share a common sort key. However, by specifying FIELDS=NONE, numeric summation is bypassed, and only one unique
XSUM – Remove Duplicate Records using SORT Read More »
OUTFIL can create multiple output data sets from a single input data set. Here are five ways you can use OUTFIL to split datasets into multiple datasets. All five can be used with SORT, MERGE, or COPY. For illustration, the examples shown here assume you want to split the data set into THREE output data
Split dataset using Mainframe SORT utility Read More »
You can change ASCII to EBCDIC in a file using ATOE function. Also EBCDIC to ASCII conversion can be done by using ETOA function. Translation features of INREC, OUTREC and OUTFIL make it easy to Change ASCII characters to their equivalent EBCDIC characters using the default standard TCP/IP service. ATOE – Instructs MFX to translate
ASCII to EBCDIC or EBCDIC to ASCII conversion Read More »
EXISTS and NOT EXISTS are used with a subquery in the WHERE clause to examine if the result the subquery returns is TRUE or FALSE. It will identify the existence of a relationship without regard for quantity. For example, if the subquery returns at least one record in its result set, the EXISTS clause will evaluate to true
EXISTS vs NOT EXISTS use in Subqueries Read More »
WER027A – CONTROL FIELD BEYOND RECORD EXPLANATION Explanation: The location of the last byte of a SORT/MERGE or JOINKEYS control field is located beyond the maximum record length specified or column 32750, or a variable-length record is shorter than the ending location of a specified SORT/MERGE or JOINKEYS control field. SORT FIELDS=(7,4,CH,A,26,4,CH,A) INREC FIELDS=(1:7,4,5:26,4)
WER027A WER039A WER046A WER235A – Syncsort Error Read More »
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 Coach Interview Questions and Answer & Agile Interview Questions and Answer for Agile interview questions related to Agile Fundamentals. Scrum Interview Questions and Answer for interview questions related to Scrum Fundamentals. Agile Principles 1. The
Agile Principles-Values-Challenges Q & A Read More »
The sysibm.sysdummy1 table is a special in-memory table that can be used to fetch the value of DB2 registers Date-Time-Timestamp. To extract a certain portion of data from the current timestamp you can use the below-mentioned functions. Specifying CURRENT_TIMESTAMP is equivalent to specifying CURRENT TIMESTAMP. Date-Time-Timestamp SELECT current date FROM sysibm.sysdummy1 SELECT current time FROM
Date-Time-Timestamp use in SQL Queries Read More »
Sprint Review is to inspect the outcome of the Sprint and determine future adaptations. It is a platform for feedback and a cornerstone in the foundation of iterative excellence. Sprint Review is held at the end of the Sprint before the Sprint Retrospective. It is critical that both the Scrum Team and the stakeholders attending understand
Sprint Review: How to be effective Tips and Tricks Read More »
The VSAM interview questions and answers are intended for those with a working knowledge of VSAM as a programmer. This will help you prepare for technical VSAM interview and online selection tests during campus placement for freshers and job interviews for professionals. VSAM Interview Questions with Answers 1. What is a control interval, control area,
VSAM Interview Questions with Answers Read More »
SHIFT =LEFT will left-squeeze by removing all of the blanks, shifting the remaining characters to the left and padding on the right with blanks if needed. SHIFT =RIGHT indicates that you want to right-squeeze by removing all of the blanks, shifting the remaining characters to the right and padding on the left with blanks if
SHIFT : Add or Remove SPACES-characters to input data Read More »
We can use INSPECT or UPPERCASE or LOWERCASE COBOL function to convert the case of alphanumeric, alphabetic, or national strings. Translation features of INREC, OUTREC and OUTFIL make it easy to change the case of characters in your fields. INSPECT verb in COBOL is very useful and it is used to do the following functionalities
Uppercase to Lowercase conversion – COBOL, DB2 & SORT Read More »
The SPS Certification validates your ability to scale Scrum with Nexus. At 40 questions in 60 minutes (85% pass mark), it rewards sharp recall, nuanced scenario thinking, and calm execution. SPS certification requires that a student demonstrate their knowledge and understanding of Scrum through a rigorous assessment. There are no prerequisites to attempting this certification,
SPS Certification – Important Tips and Tricks Read More »
A Program Increment (PI) starts with a time-boxed PI Planning event in which the Agile Release Train is responsible for planning & delivering incremental value in the form of working, tested software and systems. This is a two-day event where all stakeholders (including Agile/Scrum Teams) on the Agile Release Train (ART) participate in a collocated event.
PI Planning – Tips and Tricks with Steps Read More »
4Ls stands for Liked Learned Lacked Longed and it is a brainstorming technique for collecting feedback on a recently completed project or piece of work. This retrospective highlights the positive (liked & learned) as well as the negative (lacked & longed for). The team has to think mostly from a factual (what happened) perspective, rather
4Ls: Liked Learned Lacked Longed Retrospective Read More »
Sailboat Retrospective is a fun and creative way for teams to reflect on the sprint and identify areas for improvement. It’s called “Sailboat” because the metaphor of a sailboat helps the team visualize their journey, the obstacles they faced, and the direction they want to sail towards in the future. The Sailboat or Speedboat Method
Sailboat or Speedboat – Sprint Retrospective Read More »
The Starfish Retrospective is a highly practical sprint retrospective format that helps teams move beyond “what went well” and “what didn’t” into specific, actionable improvements. It is especially useful when you want the team to think in terms of keep, stop, start, more of, and less of so the discussion turns directly into behavior change. The Starfish Retrospective
Starfish or The Wheel – Sprint Retrospective Read More »
A Mad Sad Glad retrospective is a simple and effective way for teams to reflect on their previous sprint. It involves identifying things that made the team feel happy, things that made them feel sad, and things that made them feel angry or frustrated. By focusing on these three areas, the team can identify what
Mad Sad and Glad – Sprint Retrospective Read More »
The Start Stop and Continue format is a simple, action‑oriented sprint retrospective technique that helps Scrum teams reflect on what is working, what is not, and what they want to change in the next iteration. It structures the conversation around three categories—things to start doing, stop doing, and continue doing—so teams leave the meeting with a concrete, prioritized improvement plan rather than a
Start Stop and Continue – Sprint Retrospective Read More »
