VSAM Alternate Index using IDCAMS with Examples

4 years ago

VSAM Alternate index is the additional index that is created for KSDS/ESDS datasets (but not RRDS or extended ESDS) in…

VSAM DEFINE CLUSTER using IDCAMS with Examples

4 years ago

VSAM DEFINE CLUSTER is used to define attributes for the cluster as a whole or for the components like data…

SQL Subqueries with IN or NOT IN operator

4 years ago

SQL Subqueries with IN or NOT IN check is similar to the ANY and SOME checks. Use the IN clause for multiple-record,…

SQL subqueries with operations & examples

4 years ago

SQL Subqueries are also called inner queries or inner select or a nested queries. The statement containing the subquery is…

SQL Subqueries with ANY or ALL operator

4 years ago

Comparison operators (=, >, < , etc.) are used only on subqueries that return one row. SQL Subqueries with ANY and ALL operators, you can…

OUTER JOIN – step by step walkthrough with examples

4 years ago

The JOIN operation allows you to combine rows from two or more tables based on a related column. OUTER JOIN…

Power Interest Grid – Prioritize Stakeholders

4 years ago

A Power Interest Grid is a matrix used for categorizing or prioritizing stakeholders during a project to allow them to…

Ishikawa Diagram use in Root Cause Analysis

4 years ago

Ishikawa diagram is a graphic technique, that is used for displaying the characteristics of a given situation or problem. It…

INNER JOIN – step by step walkthrough with examples

4 years ago

There are four basic types of JOINS – Inner, Outer (left, right, full), Self and Cross join. An inner join…

ASM – Agile Scrum Master Certification – EXIN

4 years ago

ASM - Agile Scrum Master certification is offered by EXIN. It involves a combination of methodologies, Scrum practices, and practical…

Tuckman Ladder Model – Team Development

4 years ago

Tuckman Ladder Model is one of the models used to describe the process or different stages of team development. These four stages…

CAST expression to convert data type – SQL

4 years ago

CAST expression is used to convert one data type to another. It is similar to the various field-type functions (e.g.…

CSV – PIPE TO FIXED LENGTH FORMAT

4 years ago

Let's say your input file has data that is delimited by PIPE or COMMA e.g. you have uploaded a CSV…

Agile Maturity Index & Agile Maturity Level

4 years ago

Agile Maturity Index is a way to know what the degree of maturity of the team is measured by applying…

Planning Onion – Levels of Agile Planning

4 years ago

In Agile planning, there are many layers of planning involved, which gives the name “ Planning Onion ” to Agile…

Create a New Sprint – Manage it in JIRA

4 years ago

Create a New Sprint - In JIRA, a Sprint is a defined time period in which a Scrum team commits…

Text Field search using advanced search in JIRA

4 years ago

Text Field search can be done using the quick search, basic search, and advanced search. Search Filters assist the team…

Stakeholder Engagement & Management in Agile

4 years ago

Stakeholder Engagement and Stakeholder Management are arguably the most important ingredients for successful project delivery. Stakeholders of a project are…

Scrum vs Kanban – Agile Methodologies

4 years ago

Scrum Vs Kanban is about two different frameworks for implementing agile development. Kanban methodologies are continuous and more fluid, whereas…

JIRA Scrum Board – Create & Customize

4 years ago

JIRA Scrum Board is a tool to help teams to achieve their goals and deliver the product in the scheduled/committed…

WSJF – Weighted Shortest Job First Prioritization Technique

4 years ago

WSJF is a Prioritization method that helps calculate and understand what is the level of the financial impact of not…

CHANGE Input Data using SORT Lookup

4 years ago

CHANGE in OUTREC statement can be used to look up and change the content in the file while sorting. Build…

XML statement generation using SORT

4 years ago

We will generate XML statement from input records having fixed positions using SORT. We will use REMOVECC, HEADER1, BUILD, JFY,…

SAVE discarded records using SORT

4 years ago

Record Selection for Output File can be done using STARTREC, ENDREC, INCLUDE/OMIT, SAVE Parameters. Use SAVE to include records for…

Instagram Content: How to Create a Robust Plan for Your Brand

4 years ago

Instagram is a powerful marketing tool for businesses of all sizes. But simply setting up an account and posting at…