VSAM Alternate index is the additional index that is created for KSDS/ESDS datasets (but not RRDS or extended ESDS) in addition to their primary index. A VSAM alternate index allows logical records of a KSDS or of an ESDS base cluster to be accessed sequentially and randomly by more than one key field. The key […]
VSAM Alternate Index using IDCAMS with Examples Read More »
VSAM DEFINE CLUSTER is used to define attributes for the cluster as a whole or for the components like data and index of the cluster. In other words, the parameters can be specified on the Cluster or Data Component, or Index Component. Usually, a sequence of commands commonly used in a single job step includes
VSAM DEFINE CLUSTER using IDCAMS with Examples Read More »
SQL Subqueries with IN or NOT IN check is similar to the ANY and SOME checks. Use the IN clause for multiple-record, single-column subqueries. After the subquery returns results introduced by IN or NOT IN, the outer query uses them to return the final result. If any row in the sub-query result matches, the answer is true. If the sub-query
SQL Subqueries with IN or NOT IN operator Read More »
SQL Subqueries are also called inner queries or inner select or a nested queries. The statement containing the subquery is also called an outer query or outer select. It is a query within another SQL query and embedded within the WHERE or HAVING clause. A subquery is used to return data that will be used
SQL subqueries with operations & examples Read More »
Comparison operators (=, >, < , etc.) are used only on subqueries that return one row. SQL Subqueries with ANY and ALL operators, you can make comparisons on subqueries that return multiple rows. ANY and ALL evaluate whether any or all of the values returned by a subquery match the left-hand expression. It is similar to SOME and IN operators & must follow
SQL Subqueries with ANY or ALL operator Read More »
The JOIN operation allows you to combine rows from two or more tables based on a related column. OUTER JOIN includes the FULL, RIGHT, and LEFT OUTER JOINS. When two tables are joined there can be NULL values from either table. For INNER JOINs, records with nulls won’t match, and they will be discarded and won’t
OUTER JOIN – step by step walkthrough with examples Read More »
A Power Interest Grid is a matrix used for categorizing or prioritizing stakeholders during a project to allow them to be effectively managed. Stakeholders are plotted on the grid in relation to the Power (Y-axis) & Interest (X-axis) they have in respect of the project. Charting the relationship between different stakeholders is the best way to
Power Interest Grid – Prioritize Stakeholders Read More »
Ishikawa diagram is a graphic technique, that is used for displaying the characteristics of a given situation or problem. It is also known as Fishbone Diagrams, Herringbone Diagrams, Cause-and-Effect Diagrams, or Fishikawa. Ishikawa diagrams are used for defect analysis (Root Cause Analysis). It is very useful when the analyzed defect has multiple causes. A problem
Ishikawa Diagram use in Root Cause Analysis Read More »
There are four basic types of JOINS – Inner, Outer (left, right, full), Self and Cross join. An inner join combines records from two tables based on a join predicate and requires that each record in the first table has a matching record in the second table. Thus, it returns only records from both joined
INNER JOIN – step by step walkthrough with examples Read More »
ASM – Agile Scrum Master certification is offered by EXIN. It involves a combination of methodologies, Scrum practices, and practical assignments. ASM Certification aims at practical application of Agile methodologies and SCRUM practices to test the capability to facilitate cross-functional teams. The exam tests both skills and knowledge of the Agile methodologies and Scrum framework
ASM – Agile Scrum Master Certification – EXIN Read More »
Tuckman Ladder Model is one of the models used to describe the process or different stages of team development. These four stages are “Forming, Storming, Norming, Performing, and Adjourning”. Important Points – Tuckman Ladder Model Usually, the stages occur in order. But teams can get stuck in a particular stage or regress to an earlier stage. Projects
Tuckman Ladder Model – Team Development Read More »
CAST expression is used to convert one data type to another. It is similar to the various field-type functions (e.g. CHAR, SMALLINT) except that it can also handle null values and host-variable parameter markers. CAST syntax: CAST( <Expression> AS Type [ (Length) ] ) <NULL> <Parameter Maker> CAST Rules: EXPRESSION: Value
CAST expression to convert data type – SQL Read More »
Let’s say your input file has data that is delimited by PIPE or COMMA e.g. you have uploaded a CSV file to a mainframe or you extract database variable fields to a CSV or PIPE separated file. To open this file in a copybook or use it in the program it needs to be reformatted
CSV – PIPE TO FIXED LENGTH FORMAT Read More »
Agile Maturity Index is a way to know what the degree of maturity of the team is measured by applying some method, practice, or work technique, to know the level of mastery and the degree of adoption of Agile. It gives opportunities for improvement by challenging the team to implement the best-recommended behaviors to be
Agile Maturity Index & Agile Maturity Level Read More »
In Agile planning, there are many layers of planning involved, which gives the name “ Planning Onion ” to Agile planning. Agile does a lot more planning because it focuses more on frequent planning sessions instead of comprehensive planning that mitigates the risks of longer terms. The Planning Onion helps teams choose the right level of planning
Planning Onion – Levels of Agile Planning Read More »
Create a New Sprint – In JIRA, a Sprint is a defined time period in which a Scrum team commits to delivering a set of product backlog items. Sprints are used to organize and track the work of the development team, and to measure progress toward achieving the project’s goals. Create a New Sprint and
Create a New Sprint – Manage it in JIRA Read More »
Text Field search can be done using the quick search, basic search, and advanced search. Search Filters assist the team with creating views that you need to manage your issues. The text fields in JIRA can be searched for keywords or phrases. Text searches can be done in the advanced search when the CONTAINS (~) Tilda operator is used, e.g. summary~”windows*”. It
Text Field search using advanced search in JIRA Read More »
Stakeholder Engagement and Stakeholder Management are arguably the most important ingredients for successful project delivery. Stakeholders of a project are individuals, groups, or organizations that are affected or perceived to be affected either positively or negatively by a decision, activity, or outcome of a project. A stakeholder group can help it live out the pillars
Stakeholder Engagement & Management in Agile Read More »
Scrum Vs Kanban is about two different frameworks for implementing agile development. Kanban methodologies are continuous and more fluid, whereas scrum is based on short, structured work sprints. Scrum and Kanban are both iterative that rely on process flows and aim to reduce waste. Even though both are Agile but there are significant differences between
Scrum vs Kanban – Agile Methodologies Read More »
JIRA Scrum Board is a tool to help teams to achieve their goals and deliver the product in the scheduled/committed timelines. It is used to manage the sprint releases effectively. The word scrum is a very popular framework for the implementation of the agile software framework. Scrum supports projects that want to manage their issues
JIRA Scrum Board – Create & Customize Read More »
WSJF is a Prioritization method that helps calculate and understand what is the level of the financial impact of not finishing the task or implementing the solution sooner than later. a prioritization model used to sequence jobs (eg., Features, Capabilities, and Epics) to produce maximum economic benefit. At the end of the calculation of the
WSJF – Weighted Shortest Job First Prioritization Technique Read More »
CHANGE in OUTREC statement can be used to look up and change the content in the file while sorting. Build parameter is used to reformat records. Build give complete control over output file format. BUILD parameter can be used on INREC and OUTREC statements in SORT card. BUILD parameter is an alias of the FIELDS
CHANGE Input Data using SORT Lookup Read More »
We will generate XML statement from input records having fixed positions using SORT. We will use REMOVECC, HEADER1, BUILD, JFY, SHIFT, LEFT, LEAD, TRAIL, LENGTH, SQZ & TRAILER1 parameters. REMOVECC: The REMOVECC parameter generates reports that do not include ANSI carriage control characters that specify printer actions (for example, skipping a line or ejecting a
XML statement generation using SORT Read More »
Record Selection for Output File can be done using STARTREC, ENDREC, INCLUDE/OMIT, SAVE Parameters. Use SAVE to include records for OUTFIL processing that have not been included in any other OUTFIL group. If SAVE is specified on more than one OUTFIL group, then each of these OUTFIL groups gets the records that were discarded from
SAVE discarded records using SORT Read More »
Instagram is a powerful marketing tool for businesses of all sizes. But simply setting up an account and posting at random won’t produce the results you want.You need to have a plan. Creating a content strategy for Instagram requires research, analysis, and ongoing effort. But it’s worth it. A strong Instagram presence can help you
Instagram Content: How to Create a Robust Plan for Your Brand Read More »
