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 […]
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
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
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
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
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,
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 »
SPS Certification – Scaled Professional Scrum™ (SPS) with Nexus™ is one of the most popular Agile certifications provided by Scrum.org. Nexus builds upon traditional Scrum by expanding it to handle more complex organizational needs while keeping the basic Scrum structure intact and not introducing anything fancy, which makes it very popular among growing organizations. It
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.
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
The 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
The Starfish Method for Sprint Retrospectives is an easy way to achieve focus, give a voice to every member, and foster the thinking around practices and the value the team gets from them. It helps teams reflect on varying degrees of actions and activities rather than simply the traditional what went well or what did
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
Start Stop and Continue is a great format to focus on the things that are working (CONTINUE), things that are not working (STOP), and things that the team should start doing (START). Its focuses on the past, present, and future at the same time. It is an action-oriented retrospective technique that encourages participants to come
If you have a requirement to check Empty File before applying certain operations then it can be done using ICETOOL or FILEAID or IDCAMS or IEBPTPCH or ISRSUPC or SORT utilities.The following requirements can be met using below mentioned JCL utilities: 1. Need to check if a data set is empty or not. If it’s
Product Backlog Refinement consists of Creating & Refining User Stories, Estimating User Stories & Product Backlog Prioritization. It is the act of adding detail, estimates, and orders to items in the Product Backlog. This is an ongoing process in which the Product Owner and the Scrum Team collaborate on the details of the Product Backlog,
Product Backlog Prioritization – Tips and Tricks Read More »
The INSPECT statement can be used to tally the number of occurrences of specific character strings, to replace characters by other characters, or to convert from one set of characters to another including UPPERCASE TO LOWERCASE and vice versa. The INSPECT verb has two options, TALLYING and REPLACING. You can do one or the other
DB2 Cursor builds a results table to hold all the rows retrieved by executing a SELECT statement. DB2 uses a cursor to make the rows, from the results table, available to the application program. A cursor identifies the current row of the results table. When you use a cursor, the program can retrieve each row
Many teams use the Definition of Done (DoD) to check if a user story is finished and the product is ready to be delivered. But what about the user stories that a team receives from their product owner? Teams can check the quality of the user stories using a Definition of Ready. While the value
DoD (Definition of Done) Vs DoR (Definition of Ready) Read More »
Definition of Ready is a set of agreements that let you know when a user story is really done, the team makes explicit and visible the criteria (generally based on the INVEST matrix) that a user story must meet prior to being accepted into the upcoming iteration. The Definition of Ready is a different concept. It is a set of
Definition of Done is an agreement between Development Team and the Product Owner on what needs to be completed for each user story so that it can be satisfactorily verified and validated – usually in the form of a clear and concise list of acceptance criteria that a software Increment must adhere to for the
3C’s is an Effective User Story technique. 3Cs: Card, Conversation, and Confirmation. The Card is the index card that the User Story is written on. The index card format serves two purposes: To write requirements on index cards, each requirement has to be small and self-contained; this helps us focus on what we need to do for
Effective User Story – Card, conversation, confirmation Read More »
