Kanban board provides transparency of work, team capacity, increases efficiency, and helps to visualization of work. Kanban means is a card or virtual signal. Kanban boards in Jira help teams visualize their workflow, limit work-in-progress, and maximize efficiency. Kanban is a method based on the continuous delivery of work, kanban board is designed to help […]
Kanban Board – Create & Customize for Kanban Team Read More »
JIRA Structure helps the team visualize, track and manage progress across JIRA projects. It lets you build hierarchical lists and share them with your team. A structure can contain issues, folders, and other items. There is no limit on the hierarchy depth, and you can bring together all types of issues from different projects. Epics:
JIRA Structure – Create & Manage Epics and Stories Read More »
The COBOL MERGE statement combines two or more identically sequenced files on a set of specified keys. As part of the merge operation, it makes records available in their merged order to an output procedure or an output file. The records are made available following the actual merging of the files. The output procedure or
COBOL MERGE statement with Examples Read More »
COBOL SORT files are common functionalities of COBOL applications. Sorting is required for sequential processing as the files need to be sorted in ascending/descending order. The COBOL SORT statement creates a sort file by executing input procedures or by transferring records from another file, sorts the records in the sort file on a set of
COBOL SORT statement with Examples Read More »
The VSAM EXPORT-IMPORT commands are usually used to take the backup and recovery. The EXPORT option is used to export the dataset or alternate index or catalog. EXPORT-IMPORT can be used with the VSAM dataset (KSDS, ESDS, RRDS, and LDS), Alternate indexes, and the dataset created by EXPORT can have only a sequential organization. EXPORT
VSAM EXPORT-IMPORT using IDCAMS with Examples Read More »
VSAM cluster should be deleted using IDCAMS utility. VSAM DELETE command can be used to delete the VSAM or non-VSAM objects such as CLUSTER, GDG, Alternate Index, Alias, CATALOG, PS file, SPACE, USERCATALOG, etc. DELETE command removes the entry of the VSAM cluster from the catalog and optionally removes the file & freeing up the space.
VSAM DELETE using IDCAMS with Examples Read More »
The VSAM VERIFY command is used to verify, and if necessary, update, the end of file information in the VSAM catalog in order to make the catalog information consistent with the data file. The command adds correct End-Of-Data records to the file. This command cannot be used for an empty VSAM file where the high-used
VSAM VERIFY EXAMINE using IDCAMS with Examples Read More »
VSAM PRINT command is used to print the contents of VSAM or non-VSAM datasets. Contents can be printed in various formats such as CHAR, HEX, or DUMP. We can specify our choice of format while specifying the parameters of the PRINT command. Up to 120 characters/digits are printed per line. If the record length is
VSAM PRINT using IDCAMS with Examples Read More »
VSAM REPRO command is used to copy data from one file(Input file) to another file(Output file). Input & Output files can be VSAM datasets (like KSDS, ESDS, RRDS, etc.) or a non-VSAM dataset (like PS file or a member of PDS). A few critical functionalities of REPRO are It is used to copy data from
VSAM REPRO using IDCAMS with Examples Read More »
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 »
